phpmyadmin priviledges - cant logon as root

[Roundcat]

I am struggling with PHPadmin. I want to GRANT my server access to write to my sourcebans database but do not have the priviledges to do so (even though it was me who installed it).

To see my 'priviledges tab' or user options menu I have to, apparently, logon as 'root'.

It is set up so that nopassword is false (which I cant change but it then gives connection error).

How do I find out my root logon info? How do I set it up/edit it? I only use PHPmyadmin I do not know how to enter code into a dos window so please dont advise it as it makes my head hurt.

Now my forums' has collapsed... pft. Need help.

(I have also submitted a ticket on this - apologies for the repeat info

[Hot Carl]

You can't login as root under the paid webhosting, your login would be your identifier. You can grant access through the NFO control panel, just check Allow external connections next to the database you want to allow external connections from.

All the login info is under the Databases tab.

Cheers,
Carl

[Roundcat]

Im on my 4th clean install of this and I still cant get it to work. The error log file in sourcebans log is:

L 08/01/2012 - 13:38:44: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on 'localhost' (10061). See FAQ: http://www.sourcebans.net/node/20

When I check the FAQ is says i need to edit the permissions but I cant edit the permissions because I cant login as root. Why wont this just work I have gone throught the instructions so carefully.

I also noticed that when I am ingame as an admin - the server list in sourcebans says there are no admins online. So its not even reading that.

Do I need to do something to the admins.cfg file - do the groups in there need to match the groups in sourcebans? Could it be to do with the admins_group.cfg file? Should that be updated too?

NFO have said they wont support this and the sourcemod forum tells me to enter a bunch of code into a dos window whcih eman downlaoding more software and fiddling around. Im going mad trying to make sourcebans work. Can anyone help?

[Edge100x]

The MySQL server would not be located at localhost, from your game server. You will need to edit the database information to reflect the correct DNS of the webserver. The hostname that you should be using is the same one as your site (such as xxx.site.nfoservers.com).

[Roundcat]

Do I change that in both the config.php file and the database.cfg?

When I tried it on both I got a huge error message when I refreshed sourcebans:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 't4s'@'hosted4.nfoservers.com' (using password: YES) in /usr/www/t4s/public/sourceban/includes/adodb/drivers/adodb-mysql.inc.php on line 358
Access denied for user 't4s'@'hosted4.nfoservers.com' (using password: YES)

SQL Query type: CONNECT
Script: '/sourceban/index.php'
SQL Query: t4s.site.nfoservers.com
SQL Params: t4s_sourcebans

[Edge100x]

No, you just needed to change it on the game server. The one on the web hosting can remain "localhost".

Your error message also suggests that you may not yet have turned on external connections to the database, as Hot Carl suggested. If you are connecting to the server from outside NFO's network (with an IP that doesn't resolve to something.nfoservers.com), you must do this.

If all else fails, also try a database repair. This will fix any permissions problem, if there is one.

[Roundcat]

Hi - thanks for that Edge - but even after competing all your suggestions it is still not working. I wonder if it has something to do with the fact I have admin_groups.cfg and admins.cfg still running?

Anyone know if I am supposed to remove those two files?

Also sourcebans.log reports a new error though!:

Code: Select all

L 08/02/2012 - 08:34:04: [sourcebans.smx] Database failure: [1045]: Access denied for user 't4s'@'c-66-150-188-225.internap-la.nfoservers.com' (using password: YES). See FAQ: http://www.sourcebans.net/node/20

Mean anything to anyone?

[Edge100x]

If you open a support request, we can directly double-check the permissions for you. Apart from that, you could try using a different password.

[Roundcat]

A support request was opened 3 days ago but I was told it could not be supported because it is 3rd party plugin (or something) and I have already changed the password yesterday too.

Please do look at the permissions thing. The ticket is still open.