Jump to content

MTA - MYSQL


Foxlu

Recommended Posts

Estaba tratando de iniciar un sv RP , uso Workbench no Xampp, Ya subi los .sql a la DB fui a mods/resource/mysql puse la conección y puse el setting.. pero me tira lo siguientes errores:

(el libmysql.dll que tiene es el que trajo por defecto el RP) ((Es el Owl Gaming))

Spoiler

2016-12-01 19:33:13] Resources: 182 loaded, 0 failed
[2016-12-01 19:33:13] MODULE: Loaded "MySQL 5.0 database module" (0.50) by "Alberto Alonso <[email protected]>"
[2016-12-01 19:33:13] MODULE: Unable to initialize mods\deathmatch\modules\libmysql.dll!
[2016-12-01 19:33:13] MODULE: Loaded "SHA Module" (1.02) by "mabako"
[2016-12-01 19:33:13] Starting resources...
[2016-12-01 19:33:13] INFO: --FORUMS DATABASE CREDENTIALS--
[2016-12-01 19:33:13] INFO: --HOST: Error
[2016-12-01 19:33:13] INFO: --DB: Error
[2016-12-01 19:33:13] INFO: --USER: Error
[2016-12-01 19:33:13] INFO: --PW: Error
[2016-12-01 19:33:13] INFO: --PORT: Error
[2016-12-01 19:33:13] INFO: --RESULT: 
[2016-12-01 19:33:13] ERROR: mysql\connection.lua:78: bad argument #1 to 'mysql_connect' (string expected, got boolean)
[2016-12-01 19:33:13] INFO: --FORUMS DATABASE CREDENTIALS--
[2016-12-01 19:33:13] INFO: --HOST: Error
[2016-12-01 19:33:13] INFO: --DB: Error
[2016-12-01 19:33:13] INFO: --USER: Error
[2016-12-01 19:33:13] INFO: --PW: Error
[2016-12-01 19:33:13] INFO: --PORT: Error
[2016-12-01 19:33:13] INFO: --RESULT: 
[2016-12-01 19:33:13] ERROR: mysql\connection.lua:180: bad argument #1 to 'mysql_connect' (string expected, got boolean)
[2016-12-01 19:33:13] ERROR: mysql\connection.lua:235: bad argument #1 to 'mysql_ping' (mysqlHandler expected, got nil)
[2016-12-01 19:33:13] ERROR: global\s_money_globals.lua:26: call: failed to call 'mysql:query' [string "?"]
[2016-12-01 19:33:13] ERROR: mysql\connection.lua:235: bad argument #1 to 'mysql_ping' (mysqlHandler expected, got nil)
[2016-12-01 19:33:13] ERROR: global\s_money_globals.lua:37: call: failed to call 'mysql:query' [string "?"]
[2016-12-01 19:33:13] Server minclientversion is now 1.5.3-9.10791.0
[2016-12-01 19:33:13] ERROR: mysql\connection.lua:235: bad argument #1 to 'mysql_ping' (mysqlHandler expected, got nil)
[2016-12-01 19:33:13] ERROR: datetime\datetime_s.lua:5: call: failed to call 'mysql:query_fetch_assoc' [string "?"]
[2016-12-01 19:33:13] ERROR: datetime\datetime_s.lua:5: attempt to index a boolean value
[2016-12-01 19:33:15] Server password cleared
[2016-12-01 19:33:15] WARNING: admin-system\Player\s_player_commands.lua:734: Expected number, got non-convertible string. This warning may be an error in future versions.
[2016-12-01 19:33:15] WARNING: admin-system\Player\s_player_commands.lua:734: Expected number, got non-convertible string. This warning may be an error in future versions.  [DUP x34]
[2016-12-01 19:33:15] ERROR: mysql\connection.lua:235: bad argument #1 to 'mysql_ping' (mysqlHandler expected, got nil)
[2016-12-01 19:33:15] ERROR: camera-system\s_camera_management.lua:4: call: failed to call 'mysql:query' [string "?"]
[2016-12-01 19:33:15] WARNING: admin-system\Player\s_player_commands.lua:734: Expected number, got non-convertible string. This warning may be an error in future versions.
[2016-12-01 19:33:16] WARNING: admin-system\Player\s_player_commands.lua:734: Expected number, got non-convertible string. This warning may be an error in future versions.  [DUP x13]
[2016-12-01 19:33:16] ERROR: mysql\connection.lua:235: bad argument #1 to 'mysql_ping' (mysqlHandler expected, got nil)
[2016-12-01 19:33:16] ERROR: computers-system\s_internetcafe.lua:2: call: failed to call 'mysql:query' [string "?"]
[2016-12-01 19:33:16] WARNING: admin-system\Player\s_player_commands.lua:734: Expected number, got non-convertible string. This warning may be an error in future versions.
[2016-12-01 19:33:16] WARNING: admin-system\Player\s_player_commands.lua:734: Expected number, got non-convertible string. This warning may be an error in future versions.  [DUP x13]
[2016-12-01 19:33:16] ERROR: mysql\connection.lua:235: bad argument #1 to 'mysql_ping' (mysqlHandler expected, got nil)
[2016-12-01 19:33:16] ERROR: elevator-system\s_elevator_lift.lua:192: call: failed to call 'mysql:query' [string "?"]
[2016-12-01 19:33:16] ERROR: mysql\connection.lua:235: bad argument #1 to 'mysql_ping' (mysqlHandler expected, got nil)
[2016-12-01 19:33:16] ERROR: elevator-system\s_elevator_lift.lua:210: call: failed to call 'mysql:query_free' [string "?"]
[2016-12-01 19:33:16] INFO: elevator-system/s_elevator_lift.lua: loadAllLifts failed
[2016-12-01 19:33:16] WARNING: admin-system\Player\s_player_commands.lua:734: Expected number, got non-convertible string. This warning may be an error in future versions.
[2016-12-01 19:33:16] WARNING: admin-system\Player\s_player_commands.lua:734: Expected number, got non-convertible string. This warning may be an error in future versions.  [DUP x13]
[2016-12-01 19:33:16] ERROR: mysql\connection.lua:235: bad argument #1 to 'mysql_ping' (mysqlHandler expected, got nil)
[2016-12-01 19:33:16] ERROR: faction-system\s_faction_system.lua:18: call: failed to call 'mysql:query' [string "?"]
[2016-12-01 19:33:16] ERROR: mysql\connection.lua:235: bad argument #1 to 'mysql_ping' (mysqlHandler expected, got nil)
[2016-12-01 19:33:16] ERROR: faction-system\s_faction_admin.lua:344: call: failed to call 'mysql:query_fetch_assoc' [string "?"]
[2016-12-01 19:33:16] ERROR: mysql\connection.lua:235: bad argument #1 to 'mysql_ping' (mysqlHandler expected, got nil)
[2016-12-01 19:33:16] ERROR: faction-system\s_faction_admin.lua:499: call: failed to call 'mysql:query' [string "?"]
[2016-12-01 19:33:16] ERROR: mysql\connection.lua:235: bad argument #1 to 'mysql_ping' (mysqlHandler expected, got nil)
[2016-12-01 19:33:16] ERROR: faction-system\s_faction_admin.lua:500: call: failed to call 'mysql:query' [string "?"]
[2016-12-01 19:33:16] INFO: [Factions] ERROR: Duty allow permissions failed.

 

el Settings:

Spoiler

<settings>
    <setting name="@mysql.database" value="owl_mta" />
    <setting name="@mysql.username" value="root" />
    <setting name="@mysql.password" value="cras4984" />
    <setting name="@mysql.hostname" value="localhost" />
    <setting name="@mysql.port" value="3306" />
    
    <setting name="@mysql.forums_database" value="owl_forums" />
    <setting name="@mysql.forums_username" value="root" />
    <setting name="@mysql.forums_password" value="cras4984" />
    <setting name="@mysql.forums_hostname" value="localhost" />
    <setting name="@mysql.forums_port" value="3306" />
    
    <setting name="@mysql.logs_database" value="owl_logs" />
    <setting name="@mysql.logs_username" value="root" />
    <setting name="@mysql.logs_password" value="cras4984" />
    <setting name="@mysql.logs_hostname" value="localhost" />
    <setting name="@mysql.logs_port" value="3306" />
</settings>
 

 

y el mysql : C:\Program Files (x86)\MTA San Andreas 1.5\server\mods\deathmatch\resources\mysql

Spoiler

-- connection settings
hostname = get( "localhost" ) 
username = get( "root" ) 
password = get( "cras4984" ) 
database = get( "owl_mta" ) 
port = tonumber( get( "3306" ) ) 

-- external mysql connection settings
externalhostname = get( "localhost" ) 
externalusername = get( "root" ) 
externalpassword = get( "cras4984" ) 
externaldatabase = get( "owl_mta" ) 
externalport = tonumber( get( "3306" ) ) 

 

Link to comment
Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...