Upvote Upvoted 3 Downvote Downvoted
SQL Database Connections w/Sourcemod & DigitalOcea
posted in Q/A Help
1
#1
1 Frags +

Have you changed the

mysqld.cnf

file in

/etc/mysql/mysql.conf.d/mysqld.cnf

(i think) and changed the

bind-address

to 0.0.0.0? (Restart the mysql service after that change) Spent ages trying to do the same. Also need to create a user that listens to all addresses so

CREATE USER '<username>'@'%' IDENITIFIED BY '<password>';

then

GRANT ALL ON *.* TO '<username>'@'%';

or whatever. I think that should fix it.

Have you changed the [code]mysqld.cnf[/code] file in [code]/etc/mysql/mysql.conf.d/mysqld.cnf[/code] (i think) and changed the [code]bind-address[/code] to 0.0.0.0? (Restart the mysql service after that change) Spent ages trying to do the same. Also need to create a user that listens to all addresses so [code]CREATE USER '<username>'@'%' IDENITIFIED BY '<password>';[/code] then [code]GRANT ALL ON *.* TO '<username>'@'%';[/code] or whatever. I think that should fix it.
2
#2
0 Frags +

I've had issues with sourcemod plugins that do things outside of TF2 being functionally disabled by selinux and it is very possible that the ubuntu solution of apparmor is doing the same. Try disabling apparmor if #2 doesn't work.

As an aside, google compute offers a free low-end vm that is more than enough to run a mumble server on, which may save you some money.

I've had issues with sourcemod plugins that do things outside of TF2 being functionally disabled by selinux and it is very possible that the ubuntu solution of apparmor is doing the same. Try disabling apparmor if #2 doesn't work.

As an aside, google compute offers a free low-end vm that is more than enough to run a mumble server on, which may save you some money.
3
#3
serveme.tf
3 Frags +

If everything runs on the same machine, please do not set the bind-address to 0.0.0.0.

Do you get an error in sourcemod? Have you checked the sourcemod logs, have you checked the mysqld logs?

If everything runs on the same machine, please do not set the bind-address to 0.0.0.0.

Do you get an error in sourcemod? Have you checked the sourcemod logs, have you checked the mysqld logs?
4
#4
serveme.tf
0 Frags +

MySQL 1045 is an authentication error. So your sourcemod can connect to MySQL server, it just doesn't have the right credentials. You probably didn't set up the database user correctly in MySQL (Thermite's post has the right commands) or made a typo in your sourcemod configuration.'

Also, please bind to 127.0.0.1 if everything runs locally. Else you'll be mining bitcoins for someone soon.

MySQL 1045 is an authentication error. So your sourcemod can connect to MySQL server, it just doesn't have the right credentials. You probably didn't set up the database user correctly in MySQL (Thermite's post has the right commands) or made a typo in your sourcemod configuration.'

Also, please bind to 127.0.0.1 if everything runs locally. Else you'll be mining bitcoins for someone soon.
5
#5
serveme.tf
1 Frags +

Here are a few ways
- Limit MySQL access with iptables to certain IPs
- Put the servers in a VPN, bind MySQL to the VPN address. (Has DO launched their VPC solution yet?7)
- Set up tunnels to the server hosting the MySQL server
- Restrict the MySQL user to a certain IP: 'foobar'@'123.123.123.123' (I like this one the least, since your mysql server is still reachable from the outside and bound to 0.0.0.0)

Here are a few ways
- Limit MySQL access with iptables to certain IPs
- Put the servers in a VPN, bind MySQL to the VPN address. (Has DO launched their VPC solution yet?7)
- Set up tunnels to the server hosting the MySQL server
- Restrict the MySQL user to a certain IP: 'foobar'@'123.123.123.123' (I like this one the least, since your mysql server is still reachable from the outside and bound to 0.0.0.0)
Please sign in through STEAM to post a comment.