MTA:Paradise modules

[MatXpl]

Hi all!

I have problem in mta:paradise gamemode, i upload all files and configure other files, but i can't start my server later...

This is console debug:

[2010-12-16 15:07:02] Resources: 131 loaded, 0 failed 
[2010-12-16 15:07:02] Querying game-monitor.com master server... success! 
[2010-12-16 15:07:02] MODULE: Unable to find modules/mta_mysql.dll (/home/maxrate/gaz23/mods/deathmatch/modules/mta_mysql.dll: invalid ELF header)! 
[2010-12-16 15:07:02] MODULE: Unable to find modules/sha.dll (/home/maxrate/gaz23/mods/deathmatch/modules/sha.dll: invalid ELF header)!  

Server can't find modules but i upload all in mods/deathmatch/modules/

Pls help!

[dzek (varez)]

you are trying to load Windows modules on Linux? great idea

upload *.so files instead of *.dll, and change the configuration files:

instead of:

use:

[MatXpl]

it work thanks!, but i have next problem

Server stop all scripts.

Debug:

[2010-12-17 09:13:09] ERROR: Unable to start resource sql; Start up of resource cancelled by script 
  
  
[2010-12-17 09:13:09] ERROR: Unable to start resource irc; Start up of resource cancelled by script 
  
  
[2010-12-17 09:13:09] ERROR: Unable to start resource players; Start up of resource cancelled by script 
... 

[dzek (varez)]

this is common problem, some ppl never fix it, but i think the only thing you need is to proper setup mysql connection (please, don't touch the lua files! most ppl are editing lua files, broking the script, then come to forums and complain. only thing you need to edit is some xml file (configuration.xml in the /mods/deathmatch/ directory? or meta.xml in sql resource? i can't remember))

[MatXpl]

in my opinion mysql connection is good, i setup mysql connection in /mods/deathmatch/settings.xml

    <settings> 
        <!-- MySQL Configuration --> 
        <setting name="@sql.user" value="[b]here i add my username[/b]"/> 
        <setting name="@sql.password" value="[b]here i add my password[/b]"/> 
        <setting name="@sql.database" value="[b]here i add my database name[/b]"/> 
        <setting name="@sql.hostname" value="localhost"/> 
        <setting name="@sql.port" value="3306"/> 
        <!-- Only use this on Linux if the normal connection does fail even though using the correct username & password. --> 
        <setting name="@sql.socket" value="/var/run/mysqld/mysqld.sock"/> 
</settings> 

and i setup in script sql/mysql.lua

local function connect( ) 
    -- retrieve the settings 
    local server = get( "server" ) or "localhost" 
    local user = get( "user" ) or "[b]here i add my username[/b]" 
    local password = get( "password" ) or "[b]here i add my passworld[/b]" 
    local db = get( "database" ) or "[b]here i add my database name[/b]" 
    local port = get( "port" ) or 3306 
    local socket = get( "socket" ) or nil 
     
    -- connect 
    connection = mysql_connect ( server, user, password, db, port, socket ) 

[dzek (varez)]

ask your server provider (maxrate.pl i assume) how you should connect to mysql (you should be able to find such info in their FAQ or something).

i mean: if you should use "localhost" as host, and if you need to change port (3306) maybe. sometimes they are adding a prefix to db/username too.