mysql problems.

[benwilkins]

When resource starts I get this:

[23:56:00] ERROR: mysql/connection.lua:16: attempt to call global 'mysql_connect' (a nil value) 

Line 16:

MySQLConnection = mysql_connect(hostname, username, password, database, port) 

And then:

local hostname = get( "hostname" ) or "localhost" 
local username = get( "username" ) or "root" 
local password = get( "password" ) or "xxxxxxxxx" 
local database = get( "database" ) or "server" 
local port = tonumber( get( "port" ) ) or 3306 

Whats wrong?

[Kenix]

Show your mtaserver.conf

Show 'start' log server.

I think you not load module mysql.

And your script server side?

[Castillo]

Indeed, I would said either he didn't load the MySQL module or he put the script as client side.

[Kenix]

Maybe.

[benwilkins]

  
    -- This parameter specifies the name the server will be visible as in the ingame server browser  
         and on Game-Monitor. It is a required parameter. --> 
    || (AceMTA.com) ||
     
    -- ONLY USE THIS PARAMETER IF YOU ARE SURE OF WHAT YOU ARE DOING - it is generally only 
         needed for professional servers and should be left blank otherwise. 
         This parameter specifies the IP to use for servers that have multiple IP addresses. If left 
         blank, it will default to server's standard local IP address. --> 
     
     
  
     
    22003 
     
     
    1024 
     
     
    1 
     
     
    22005 
     
     
     
     
    0 
     
     
    8 
  
     
    20 
  
     
    -1 
  
     
     
  
     
    1 
  
    [url=https://wiki.multitheftauto.com/wiki/GetPlayerVersion]https://wiki.multitheftauto.com/wiki/GetPlayerVersion[/url] 
         and look like this: 1.1.0-9.03100.0 --> 
     
  
     
     
  
     
    1 
  
      
    0 
  
     
    
  
    -- This parameter reduces the server's bandwidth usage by using various optimizations. 
         Values: none, medium or maximum ; default value: medium --> 
    none
  
    -- Specifies the location and file name of this servers unique private key. 
         This is used to prevent private files saved on the client from being read by other servers. 
         More infomation about client private files can be found here: [url=https://wiki.multitheftauto.com/wiki/Filepath]https://wiki.multitheftauto.com/wiki/Filepath[/url] 
         Keep a backup of this file in a safe place. Default value: server-id.keys--> 
    server-id.keys
  
    -- Specifies the location and name of the main server log file. If left blank, server won't be saving this file. --> 
    logs/server.log
  
    -- As well as the main log file, login successes and failures are logged here for easy reviewing of security issues. 
         If left blank, this file is not used --> 
    logs/server_auth.log
     
    -- This parameter specifies the location and name of the Access Control List settings file. If left 
         blank, server will use acl.xml file, located in the same folder as this configuration file. --> 
    acl.xml
  
    -- Specifies the location and name of the debugscript log file. If left blank, server won't be saving this file. --> 
    logs/scripts.log
     
    -- Specifies the level of the debugscript log file. Available values: 0, 1, 2, 3. When not set, defaults to 0. --> 
    3
     
    -- Specifies the level of the html debug. Available values: 0, 1, 2, 3. When not set, defaults to 0. --> 
    0
  
    -- Specifies the frame rate limit that will be applied to connecting clients. 
         Available range: 25 to 100. Default: 36. --> 
    100
     
    -- Specifies whether or not players should automatically be logged in based on their IP adresses --> 
    0
  
    -- This parameter specifies whether or not to enable player voice chat in-game 
         Values: 0 - disabled , 1 - enabled --> 
    1
     
    -- This parameter specifies the sample rate for voice chat.  'voice' parameter must be set to 1 for this to be effective. 
         Higher settings use more bandwidth and increase the sampling quality of voice chat 
         Values: 0 - Narrowband (8kHz), 1 - Wideband (16kHz), 2 - Ultrawideband (32kHz).  Default - 1 --> 
    2
     
    -- This parameter specifies the voice quality for voice chat.  'voice' parameter must be set to 1 for this to be effective. 
         Higher settings use more bandwidth and increase the the overall quality of voice chat 
         Available range: 0 to 10.  Default - 4 --> 
    5
  
    -- Specifies the voice bitrate, in bps. This optional parameter overrides the previous two settings.  
         If not set, MTA handles this automatically.  Use with care. --> 
    --  --> 
  
    -- Specifies the module(s) which are loaded with the server. To load several modules, add more 
         parameter(s). Optional parameter. --> 
  
    "mta_mysql.so" /> 
  
    "global" startup="1" protected="0" /> 
    "mysql" startup="1" protected="0" /> 
    "account-system" startup="1" protected="0" /> 
    "pool" startup="1" protected="0" /> 
    "rangeban-system" startup="1" protected="0" /> 
    "glue-system" startup="1" protected="0" /> 
    "superman" startup="1" protected="0" /> 

  

[Castillo]

I also have the module in the mtaserver.conf, but it doesn't load when I start the server, I have to write "load mta_mysql.dll"

[benwilkins]

load mta_mysql.so

start mysql

[00:13:33] start: Requested by Console

[00:13:33] start: Resource is already running

restart mysql

[00:13:35] restart: Requested by Console

[00:13:35] restart: Resource restarting...

[00:13:35] Stopping mysql

[00:13:35] Starting mysql

[00:13:35] ERROR: mysql/connection.lua:16: attempt to call global 'mysql_connect' (a nil value)

[00:13:35] mysql restarted successfully

[Castillo]

Have you checked if the script is set to server side?

[benwilkins]

Yup:

Ive just tested a PHP file on the same server using localhost, root, server (all the same login details) and it connected fine, so its deffinatly an issue with the script, the details are all correct.

[-ffs-Sniper]

Could you please post the logs directly after starting your MTA server?

Most likely the module is not loading. I would also like to know your system (Debian? Squeeze? 64bit?)

[benwilkins]

ubuntu 64 bit.

I've just noticed...

  
  
  
loadmodule mta_mysql.so 
[00:25:40] loadmodule: Requested by Console 
[00:25:40] MODULE: Unable to find modules/mta_mysql.so (libmysqlclient.so.15: cannot open shared object file: No such file or directory)! 
[00:25:40] stop: Resource could not be found 
  
  
  

The file is 100% in the deathmatch/modules folder..

[-ffs-Sniper]

You are missing a library called libmysqlclient.so.15 in your ubuntu system.

Maybe my tutorial for Debian Squeeze could help you:

viewtopic.php?f=106&t=34979

Are you using a 32bit emulator?