Raised This Month: $12 Target: $400
 3% 

MySQL connection only uses part of the connection user


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
eyal282
Veteran Member
Join Date: Aug 2011
Old 08-12-2018 , 11:14   MySQL connection only uses part of the connection user
Reply With Quote #1

[SM] Admin cache has been refreshed.
exec: couldn't exec server2.cfg
L 08/12/2018 - 18:03:26: [SM] Exception reported: [1045]: Access denied for user 'coolserver_csgo_j'@'CENSORED IP ADDRESS' (using password: YES)
L 08/12/2018 - 18:03:26: [SM] Blaming: gangs.smx
L 08/12/2018 - 18:03:26: [SM] Call stack trace:
L 08/12/2018 - 18:03:26: [SM] [0] SetFailState
L 08/12/2018 - 18:03:26: [SM] [1] Line 30, C:\Users\Eyal282\Desktop\DesktopReal\Compiler \Gangs.sp::OnSQLConnect

The full connection user as appears in databases.cfg is coolserver_csgo_jail_gang.

On the actual server it works flawlessly but this issue occurs ONLY on a listen server to test before uploading to the real server.

What could cause it? It's clearly related to my listen server, and not the plugin since the same plugin works on one server and not in the other.
__________________
I am available to make plugins for pay.

Discord: Eyal282#1334

Last edited by eyal282; 08-12-2018 at 11:19.
eyal282 is offline
DarkDeviL
SourceMod Moderator
Join Date: Apr 2012
Old 08-12-2018 , 13:19   Re: MySQL connection only uses part of the connection user
Reply With Quote #2

Quote:
Originally Posted by eyal282 View Post
What could cause it? It's clearly related to my listen server, and not the plugin since the same plugin works on one server and not in the other.
Access restrictions on the user account, the user account is restricted to connections from individual IP addresses/networks.

The way you explain it, that it works normally, but not on another "network" is pretty obvious that it is the reason.

It is also very classic for hosting providers to allow only connections from their own network, unless you ask for otherwise, for safety reasons.
__________________
Mostly known as "DarkDeviL".

Dropbox FastDL: Public folder will no longer work after March 15, 2017!
For more info, see the [SRCDS Thread], or the [HLDS Thread].

Last edited by DarkDeviL; 08-12-2018 at 13:19.
DarkDeviL is offline
eyal282
Veteran Member
Join Date: Aug 2011
Old 08-12-2018 , 13:35   Re: MySQL connection only uses part of the connection user
Reply With Quote #3

The owner of the mySQL account told me this:

The user is not restricted. it's currently on %.
__________________
I am available to make plugins for pay.

Discord: Eyal282#1334
eyal282 is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 08-12-2018 , 16:08   Re: MySQL connection only uses part of the connection user
Reply With Quote #4

You / someone asked about this on Discord, but didn't follow up.

So I repeat my question: Are both servers using the exact same version of SM? Which version on each?
__________________
asherkin is offline
eyal282
Veteran Member
Join Date: Aug 2011
Old 08-12-2018 , 16:18   Re: MySQL connection only uses part of the connection user
Reply With Quote #5

Quote:
Originally Posted by asherkin View Post
You / someone asked about this on Discord, but didn't follow up.

So I repeat my question: Are both servers using the exact same version of SM? Which version on each?
Not me. The sourcemod version of the listen server is newest version relative to a week ago. My compiler version is 5302 and 1.7 ( or something ).

The actual server version is 1.9.0.6248

Also what discord?
__________________
I am available to make plugins for pay.

Discord: Eyal282#1334
eyal282 is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 08-12-2018 , 17:20   Re: MySQL connection only uses part of the connection user
Reply With Quote #6

Quote:
Originally Posted by eyal282 View Post
The sourcemod version of the listen server is newest version relative to a week ago.
There are multiple branches, that is meaningless. Check the version.
__________________
asherkin is offline
eyal282
Veteran Member
Join Date: Aug 2011
Old 08-12-2018 , 17:23   Re: MySQL connection only uses part of the connection user
Reply With Quote #7

Quote:
Originally Posted by asherkin View Post
There are multiple branches, that is meaningless. Check the version.
1.9.0.6245

Edit: Changing the name to be eyal_pro solved the issue, proving the issue ( which I want fixed ) is the name being too long for some reason.
__________________
I am available to make plugins for pay.

Discord: Eyal282#1334

Last edited by eyal282; 08-12-2018 at 17:44.
eyal282 is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 11:06.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode