1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Problem with MySQL.
tsonn1
Big Clucker
***
Posts: 195
Threads: 38
Joined: Aug 2012
Reputation: 0
#1

05.10.2012, 16:28
( Последний раз редактировалось tsonn1; 05.10.2012 в 17:59. )
Hi!

I've got a little problem with mysql. I'm using the mysql plugin R6.
Here's the server log:
Код:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3e, ©2005-2012 SA-MP Team

[20:38:28] 
[20:38:28] Server Plugins
[20:38:28] --------------
[20:38:28]  Loading plugin: mysql.so
[20:38:28] 

  > MySQL plugin R6 successfully loaded.

[20:38:28]   Loaded.
[20:38:28]  Loading plugin: sscanf.so
[20:38:28] 

[20:38:28]  ===============================

[20:38:28]       sscanf plugin loaded.     

[20:38:28]    © 2009 Alex "******" Cole

[20:38:28]    0.3d-R2 500 Players "dnee"

[20:38:28]  ===============================

[20:38:28]   Loaded.
[20:38:28]  Loading plugin: streamer.so
[20:38:28] 

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

[20:38:28]   Loaded.
[20:38:28]  Loaded 3 plugins.

[20:38:28] 
[20:38:28] Filterscripts
[20:38:28] ---------------
[20:38:28]   Loading filterscript 'Raadio.amx'...
[20:38:28]   Unable to load filterscript 'Raadio.amx'.
[20:38:28]   Loaded 0 filterscripts.

[20:38:28] MYSQL: Trying to connect to server...
[20:38:28] MYSQL: Error. Trying again...
[20:38:28] MYSQL: Couldn't connect to server.
[20:38:28] Gameode - On
[20:38:28]  _____________________________
[20:38:28] 162 cars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 50 bikes loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 0 aCars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 9 caravans loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:29] 3 aHelis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 14 boats loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 11 helis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 39 bizzes loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 109 houses loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 5 points loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] Pickups limit = 400, Pickups loaded = 4
[20:38:30]  
[20:38:30] GM
[20:38:30]  _____________________________
[20:38:30]  
[20:38:30] Number of vehicle models: 103
[20:38:30] Bizzes updated, (2215)
[20:38:30] Houses updated, (2276)
[20:38:28] MYSQL: Trying to connect to server...
[20:38:28] MYSQL: Error. Trying again...
[20:38:28] MYSQL: Couldn't connect to server.
[20:38:28] Gameode - On
[20:38:28]  _____________________________
[20:38:28] 162 cars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 50 bikes loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 0 aCars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 9 caravans loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:29] 3 aHelis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 14 boats loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 11 helis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 39 bizzes loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 109 houses loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 5 points loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] Pickups limit = 400, Pickups loaded = 4
[20:38:30]  
[20:38:30] GM
[20:38:30]  _____________________________
[20:38:30]  
[20:38:30] Number of vehicle models: 103
[20:38:30] Bizzes updated, (2215)
[20:38:30] Houses updated, (2276)
[20:38:28] MYSQL: Trying to connect to server...
[20:38:28] MYSQL: Error. Trying again...
[20:38:28] MYSQL: Couldn't connect to server.
[20:38:28] Gameode - On
[20:38:28]  _____________________________
[20:38:28] 162 cars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 50 bikes loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 0 aCars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 9 caravans loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:29] 3 aHelis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 14 boats loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 11 helis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 39 bizzes loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 109 houses loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 5 points loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] Pickups limit = 400, Pickups loaded = 4
[20:38:30]  
[20:38:30] GM
[20:38:30]  _____________________________
[20:38:30]  
[20:38:30] Number of vehicle models: 103
[20:38:30] Bizzes updated, (2215)
[20:38:30] Houses updated, (2276)
[20:38:28] MYSQL: Trying to connect to server...
[20:38:28] MYSQL: Error. Trying again...
[20:38:28] MYSQL: Couldn't connect to server.
[20:38:28] Gameode - On
[20:38:28]  _____________________________
[20:38:28] 162 cars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 50 bikes loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 0 aCars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 9 caravans loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:29] 3 aHelis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 14 boats loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 11 helis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 39 bizzes loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 109 houses loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 5 points loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] Pickups limit = 400, Pickups loaded = 4
[20:38:30]  
[20:38:30] GM
[20:38:30]  _____________________________
[20:38:30]  
[20:38:30] Number of vehicle models: 103
[20:38:30] Bizzes updated, (2215)
[20:38:30] Houses updated, (2276)
[20:38:28] MYSQL: Trying to connect to server...
[20:38:28] MYSQL: Error. Trying again...
[20:38:28] MYSQL: Couldn't connect to server.
[20:38:28] Gameode - On
[20:38:28]  _____________________________
[20:38:28] 162 cars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 50 bikes loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 0 aCars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 9 caravans loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:29] 3 aHelis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 14 boats loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 11 helis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 39 bizzes loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 109 houses loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 5 points loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] Pickups limit = 400, Pickups loaded = 4
[20:38:30]  
[20:38:30] GM
[20:38:30]  _____________________________
[20:38:30]  
[20:38:30] Number of vehicle models: 103
[20:38:30] Bizzes updated, (2215)
[20:38:30] Houses updated, (2276)
[20:38:28] MYSQL: Trying to connect to server...
[20:38:28] MYSQL: Error. Trying again...
[20:38:28] MYSQL: Couldn't connect to server.
[20:38:28] Gameode - On
[20:38:28]  _____________________________
[20:38:28] 162 cars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 50 bikes loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 0 aCars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 9 caravans loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:29] 3 aHelis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 14 boats loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 11 helis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 39 bizzes loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 109 houses loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 5 points loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] Pickups limit = 400, Pickups loaded = 4
[20:38:30]  
[20:38:30] GM
[20:38:30]  _____________________________
[20:38:30]  
[20:38:30] Number of vehicle models: 103
[20:38:30] Bizzes updated, (2215)
[20:38:30] Houses updated, (2276)
[20:38:28] MYSQL: Trying to connect to server...
[20:38:28] MYSQL: Error. Trying again...
[20:38:28] MYSQL: Couldn't connect to server.
[20:38:28] Gameode - On
[20:38:28]  _____________________________
[20:38:28] 162 cars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 50 bikes loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 0 aCars loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:28] 9 caravans loaded. (MySQL)
[20:38:28]  _____________________________
[20:38:29] 3 aHelis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 14 boats loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 11 helis loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 39 bizzes loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 109 houses loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] 5 points loaded. (MySQL)
[20:38:29]  _____________________________
[20:38:29] Pickups limit = 400, Pickups loaded = 4
[20:38:30]  
[20:38:30] GM
[20:38:30]  _____________________________
[20:38:30]  
[20:38:30] Number of vehicle models: 103
[20:41:33] MYSQL: Connection dead. Reconnecting...
See - The server just keeps restarting. (I removed a couple of lines)
(Don't mind the times. I translated the text, so everything is 20:38:30. )


Here's the thing causing this:
pawn Код:
public MySQLConnect(sqlhost[], sqluser[], sqlpass[], sqldb[]) // by Luk0r
{
    print("MYSQL: Trying to connect to server...");
    mysql_connect(sqlhost, sqluser, sqldb, sqlpass);
    if(mysql_ping()==0)
    {
        print("MYSQL: Connection successful.");
        return 1;
    }
    else
    {
        print("MYSQL: Error. Trying again...");
        mysql_connect(sqlhost, sqluser, sqldb, sqlpass);
        if(mysql_ping()==0)
        {
            print("MYSQL: Reconnection success! Continuing normally.");
            return 1;
        }
        else
        {
            print("MYSQL: Couldn't connect to server.");
            return 0;
        }
    }
}

public MySQLDisconnect() // by Luk0r
{
    mysql_close();
    return 1;
}

public MySQLCheckConnection() // by Luk0r
{
    if(mysql_ping()==0)
    {
        return 1;
    }
    else
    {
        print("MYSQL: Connection dead. Reconnecting...");
        MySQLDisconnect();
        MySQLConnect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS,MYSQL_DB);
        if(mysql_ping()==0)
        {
            print("MYSQL: Reconnection success! Continuing normally.");
            return 1;
        }
        else
        {
            print("MYSQL: Couldn't connect to server.");
            return 0;
        }
    }
}

About the host: OS - Debian 5
Find
Reply
Red_Dragon.
High-roller
*****
Posts: 1,391
Threads: 85
Joined: Sep 2012
Reputation: 0
#2

05.10.2012, 16:46
Post in non English section please
Find
Reply
tsonn1
Big Clucker
***
Posts: 195
Threads: 38
Joined: Aug 2012
Reputation: 0
#3

05.10.2012, 17:49
( Последний раз редактировалось tsonn1; 05.10.2012 в 18:59. )
Moment. I'll translate it.
Find
Reply
tsonn1
Big Clucker
***
Posts: 195
Threads: 38
Joined: Aug 2012
Reputation: 0
#4

05.10.2012, 18:59
Translated.

Waiting for response. (+rep)
Find
Reply
Mean
High-roller
*****
Posts: 2,726
Threads: 85
Joined: Jul 2010
Reputation: 0
#5

05.10.2012, 21:28
Kind of a beginner question but: your databases are all set up?
Find
Reply
tsonn1
Big Clucker
***
Posts: 195
Threads: 38
Joined: Aug 2012
Reputation: 0
#6

06.10.2012, 06:45
Of course.
It worked with the old sampmysql plugin, but after the upgrade to BlueG's MySQL plugin, I keep having this problem.
Find
Reply
tsonn1
Big Clucker
***
Posts: 195
Threads: 38
Joined: Aug 2012
Reputation: 0
#7

06.10.2012, 10:25
And also.. Mysql doesn't load some stuff. I think, it's caused by the removal of samp_mysql_strtok.
Find
Reply
Unfriendly
Big Clucker
***
Posts: 109
Threads: 18
Joined: Dec 2011
Reputation: 0
#8

06.10.2012, 14:09
With the update to R7 you're gonna need to rewrite a lot of your code.
I would suggest staying with R6 until you can update the code, just to keep your server online.

Also make sure your mysql database has direct access allowed.
Find
Reply
tsonn1
Big Clucker
***
Posts: 195
Threads: 38
Joined: Aug 2012
Reputation: 0
#9

06.10.2012, 15:32
No no...
I had an old MySQL plugin. I think it was R2 or smthing like this.
Now I updated it to R6.
Find
Reply
tsonn1
Big Clucker
***
Posts: 195
Threads: 38
Joined: Aug 2012
Reputation: 0
#10

07.10.2012, 15:27
Bump!
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help