SA-MP Forums Archive
MySQL is not saving in Linux. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL is not saving in Linux. (/showthread.php?tid=393883)


MySQL is not saving in Linux. - JaKe Elite - 20.11.2012

In Windows MySQL is saving fine.

However, In Linux, I test with my tester, I register it work...
However i notice this after i reconnect. And the dialog is register, It must be login..

Why it doesn't work in Linux?
It only works in Windows??

AW: MySQL is not saving in Linux. - Skimmer - 20.11.2012

Do you have the new plugin? On .so format.

Re: MySQL is not saving in Linux. - JaKe Elite - 21.11.2012

Yes, Also it's in R6, i recompile the script properly..

Re: MySQL is not saving in Linux. - JaKe Elite - 22.11.2012

bump..

Re: MySQL is not saving in Linux. - iggy1 - 22.11.2012

Since your using R6 put this under OnGameModeInit before you call any mysql functions.

pawn Код:
mysql_debug(1);
Which will create a debug file in your server directory that records errors. It's kind of hard to help when the only info we are given is that it doesn't work on linux. You might not even need help after you have read that file.

Re: MySQL is not saving in Linux. - JaKe Elite - 22.11.2012

here is the result

pawn Код:
CMySQLHandler::Connect() - Access denied for user 'root'@'localhost' (using password: NO) (Error ID: 1045)
Here is my code

pawn Код:
#define mysql_host "127.0.0.1"
#define mysql_user "root"
#define mysql_password ""
#define mysql_database "mysql"


Re: MySQL is not saving in Linux. - iggy1 - 22.11.2012

You need to get the MYSQL database details from your linux server host. Contact them and ask for the details for the MYSQL database. They are not the same as the ones you have been using on your windows machine.

Re: MySQL is not saving in Linux. - JaKe Elite - 23.11.2012

i saw this

Код:
DB Host (IP):
DB Host (Domain):
DB Port: 
PHPMyAdmin:
So how i could set it up in the script??

Re: MySQL is not saving in Linux. - JaKe Elite - 24.11.2012

Bump

i saw this

Код:
DB Host (IP):
DB Host (Domain):
DB Port: 
PHPMyAdmin:
So how i could set it up in the script??
so where should i put them??

Re: MySQL is not saving in Linux. - Glad2BeHere - 24.11.2012

Check the Linux Database cause it can be very different from the windows database