Mysql problem? - Printable Version

Mysql problem? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Mysql problem? (/showthread.php?tid=574612)

Mysql problem? - Gheecco - 18.05.2015

Hello everyone, I'm trying to open a RP server, everything is OK but if I start my server on Linux, the server starts, but if I try to register my account, it says me 'Wrong Password, re-try', the chatlog doesn't show any problem.
Anyone can help me?

Re: Mysql problem? - Michael B - 19.05.2015

Are you using the same databse while running the server at localhost & VPS?

Re: Mysql problem? - Phaze - 19.05.2015

Do you even have the MYSQL installed? Just curious. Make sure the database uploaded correctly, and it didn't timeout the request while it was uploading because that will lead into uncompleted data.

Re: Mysql problem? - Gheecco - 19.05.2015

Quote:

Originally Posted by Michael B

Are you using the same databse while running the server at localhost & VPS?

Yes, the same database.

Re: Mysql problem? - Gheecco - 19.05.2015

Quote:

Originally Posted by Phaze

Do you even have the MYSQL installed? Just curious. Make sure the database uploaded correctly, and it didn't timeout the request while it was uploading because that will lead into uncompleted data.

Yes, MySQL is installed correctly, same thing with the database.

Re: Mysql problem? - Jake187 - 19.05.2015

check ur logs see exactly whats going on? even put debug on mySQL on.

Re: Mysql problem? - Gheecco - 19.05.2015

Quote:

Originally Posted by Jake187

check ur logs see exactly whats going on? even put debug on mySQL on.

----------

SA-MP Dedicated Server
----------------------
v0.3.7, ©2005-2015 SA-MP Team

[19:38:47] filterscripts = "" (string)
[19:38:47]
[19:38:47] Server Plugins
[19:38:47] --------------
[19:38:47] Loading plugin: mysql.so
[19:38:47]

> MySQL plugin R6 successfully loaded.

[19:38:47] Loaded.
[19:38:47] Loading plugin: sscanf.so
[19:38:47]

[19:38:47] ===============================

[19:38:47] sscanf plugin loaded.

[19:38:47] Version: 2.8.1

[19:38:47] © 2012 Alex "******" Cole

[19:38:47] ===============================

[19:38:47] Loaded.
[19:38:47] Loading plugin: streamer.so
[19:38:47]

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[19:38:47] Loaded.
[19:38:47] Loading plugin: audio.so
[19:38:47]

*** Audio Plugin v0.5 R2 by Incognito loaded ***

[19:38:47] Loaded.
[19:38:47] Loading plugin: nativechecker.so
[19:38:47] Loaded.
[19:38:47] Loading plugin: mysql_static.so
[19:38:47] >> plugin.mysql: R33 successfully loaded.
[19:38:47] Loaded.
[19:38:47] Loaded 6 plugins.

[19:38:47]
[19:38:47] Filterscripts
[19:38:47] ---------------
[19:38:47] Loaded 0 filterscripts.

[19:38:47]
[19:38:47]
[19:38:47]
[19:38:47] =======================================
[19:38:47] | |
[19:38:47] | YSI version 3.09.0684 |
[19:38:47] | By Alex "******" Cole |
[19:38:47] | |
[19:38:47] =======================================
[19:38:47]
[19:38:47] [MySQL]: Connection with database failed.
[19:38:47] Number of vehicle models: 0

Now the connection with the database fails..

Re: Mysql problem? - Gheecco - 19.05.2015

Quote:

Originally Posted by Jake187

check ur logs see exactly whats going on? even put debug on mySQL on.

Now the situation is different: the server_log says the server starts correctly, the database connects with the server too, but the server doesn't start, why?

Код:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7, ©2005-2015 SA-MP Team

[20:10:43] filterscripts = ""  (string)
[20:10:43] 
[20:10:43] Server Plugins
[20:10:43] --------------
[20:10:43]  Loading plugin: mysql.so
[20:10:43] 

  > MySQL plugin R6 successfully loaded.

[20:10:43]   Loaded.
[20:10:43]  Loading plugin: sscanf.so
[20:10:43] 

[20:10:43]  ===============================

[20:10:43]       sscanf plugin loaded.     

[20:10:43]          Version:  2.8.1        

[20:10:43]    © 2012 Alex "******" Cole  

[20:10:43]  ===============================

[20:10:43]   Loaded.
[20:10:43]  Loading plugin: streamer.so
[20:10:43] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[20:10:43]   Loaded.
[20:10:43]  Loading plugin: audio.so
[20:10:43] 

*** Audio Plugin v0.5 R2 by Incognito loaded ***

[20:10:43]   Loaded.
[20:10:43]  Loading plugin: nativechecker.so
[20:10:43]   Loaded.
[20:10:43]  Loading plugin: mysql_static.so
[20:10:43]  >> plugin.mysql: R33 successfully loaded.
[20:10:43]   Loaded.
[20:10:43]  Loaded 6 plugins.

[20:10:43] 
[20:10:43] Filterscripts
[20:10:43] ---------------
[20:10:43]   Loaded 0 filterscripts.

[20:10:43]  
[20:10:43]  
[20:10:43]  
[20:10:43]  ======================================= 
[20:10:43]  |                                     | 
[20:10:43]  |        YSI version 3.09.0684        | 
[20:10:43]  |        By Alex "******" Cole        | 
[20:10:43]  |                                     | 
[20:10:43]  ======================================= 
[20:10:43]  
[20:10:43] 
----------------------------------------------
[20:10:43] [MySQL]: The connection to database is occurred succefuly.
[20:10:43] ------------------------------------------------
[20:10:43] Number of vehicle models: 0

Re: Mysql problem? - Jake187 - 19.05.2015

Quote:

Originally Posted by Gheecco

Now the situation is different: the server_log says the server starts correctly, the database connects with the server too, but the server doesn't start, why?

Код:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7, ©2005-2015 SA-MP Team

[20:10:43] filterscripts = ""  (string)
[20:10:43] 
[20:10:43] Server Plugins
[20:10:43] --------------
[20:10:43]  Loading plugin: mysql.so
[20:10:43] 

  > MySQL plugin R6 successfully loaded.

[20:10:43]   Loaded.
[20:10:43]  Loading plugin: sscanf.so
[20:10:43] 

[20:10:43]  ===============================

[20:10:43]       sscanf plugin loaded.     

[20:10:43]          Version:  2.8.1        

[20:10:43]    © 2012 Alex "******" Cole  

[20:10:43]  ===============================

[20:10:43]   Loaded.
[20:10:43]  Loading plugin: streamer.so
[20:10:43] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[20:10:43]   Loaded.
[20:10:43]  Loading plugin: audio.so
[20:10:43] 

*** Audio Plugin v0.5 R2 by Incognito loaded ***

[20:10:43]   Loaded.
[20:10:43]  Loading plugin: nativechecker.so
[20:10:43]   Loaded.
[20:10:43]  Loading plugin: mysql_static.so
[20:10:43]  >> plugin.mysql: R33 successfully loaded.
[20:10:43]   Loaded.
[20:10:43]  Loaded 6 plugins.

[20:10:43] 
[20:10:43] Filterscripts
[20:10:43] ---------------
[20:10:43]   Loaded 0 filterscripts.

[20:10:43]  
[20:10:43]  
[20:10:43]  
[20:10:43]  ======================================= 
[20:10:43]  |                                     | 
[20:10:43]  |        YSI version 3.09.0684        | 
[20:10:43]  |        By Alex "******" Cole        | 
[20:10:43]  |                                     | 
[20:10:43]  ======================================= 
[20:10:43]  
[20:10:43] 
----------------------------------------------
[20:10:43] [MySQL]: The connection to database is occurred succefuly.
[20:10:43] ------------------------------------------------
[20:10:43] Number of vehicle models: 0

Are you sure you're using the right mySQL plugin seems odd the message is The connection to database is occurred succefuly. I've never seen the message with a spelling and grammar error.

Re: Mysql problem? - Gheecco - 19.05.2015

Quote:

Originally Posted by Jake187

Are you sure you're using the right mySQL plugin seems odd the message is The connection to database is occurred succefuly. I've never seen the message with a spelling and grammar error.

Now I have installed ubuntu on my vps, but when I start the server:

Код:

Loading plugin: mysql.so
[23:45:09]   Failed (libmysqlclient_r.so.16: wrong ELF class: ELFCLASS64)

How I fix?