Mysql problem?
#1

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?
Reply
#2

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

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.
Reply
#4

Quote:
Originally Posted by Michael B
Посмотреть сообщение
Are you using the same databse while running the server at localhost & VPS?
Yes, the same database.
Reply
#5

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.
Reply
#6

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

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..
Reply
#8

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
Reply
#9

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.
Reply
#10

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?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)