| sujet suivant »

[Nova91]

Bonjour bonjour.
Alors voila j'ai lu la plus part de vos tutos mais je n'arrive toujours pas à faire ce que je veux.

Alors voila je veux me lancer dans le scriptage mais d'abord je veux lancer un mod pré fait le Paradise de Mabako qui est disponible ici https://nodeload.github.com/mabako/mta-paradise/zipball/master.
Je fait ce qui est dit dans le install.txt qui vient avec le mod Paradise mais ça ne marche pas. Je ne sais pas où est mon erreur.

J'arrive à lancer le mod DM qui est présent de base.
Je suis un pur novice, j'attend vos reponses.
Je uis là pour apprendre =D.

Sinon mon but final est de crée un serveur RP français mais bon j'en suis pas encore là.

[Citizen]

Bonjour,
MTA Paradise est assez complexe à installer, car il requiert un serveur MySQL.
Pour cela, il te faut installer:
-EasyPHP ( recommandé )
ou
-xamp
ou
-wamp

Pour EasyPHP:
  Une fois installé, il faut faire un clique droit sur l’icône d'EasyPHP ( le E avec un carré rouge ) et cliquer sur Administration et cliquer sur Administrer vos bases de données qui est le panel d'administration du MySQL. D'après le README, il te faut juste créer une table ( par ex: paradise ), pour cela tu cliques sur Base de données en haut à gauche et tu tapes paradise puis clique sur Créer.

Tu as maintenant une database pour Paradise, maintenant il faut que tu mettes le fichier settings.txt qui est en pièce jointe et tu vas placer dans le dossier sql puis le renommé en settings.xml.
Tu peux maintenant lancer le mod paradise.

Si tu rencontres des problèmes, n'hésite pas.

Sinon mon but final est de crée un serveur RP français mais bon j'en suis pas encore là.

Certaines personnes t'ont déjà devancé, je te laisse regardé ce topic:
http://forum.mtasa.com/viewtopic.php?f=128&t=31010

Cordialement,
 Citizen

[Nova91]

Alors ça marche jusqu’à "Starting resources....."  .
Puis ça met une liste d'erreurs :

[2011-10-30 16:47:49] ERROR: Unable to connect to mysql: (2013) Lost connection to MySQL server at 'reading initial communication packet', system error: 0
[2011-10-30 16:47:49] ERROR: sql\mysql.lua:42: Connection to MySQL Failed.
[2011-10-30 16:47:49] Server shutdown as requested by resource sql (MySQL failed to connect.)
[2011-10-30 16:47:49] Start up of resource sql cancelled by script
[2011-10-30 16:47:49] ERROR: Unable to start resource sql; Start up of resource cancelled by script

[2011-10-30 16:47:49] Start up of resource irc cancelled by script
[2011-10-30 16:47:49] ERROR: Unable to start resource irc; Start up of resource cancelled by script

[2011-10-30 16:52:50] ERROR: Unable to connect to mysql: (2013) Lost connection to MySQL server at 'reading initial communication packet', system error: 0
[2011-10-30 16:52:50] ERROR: sql\mysql.lua:42: Connection to MySQL Failed.
[2011-10-30 16:52:50] Server shutdown as requested by resource sql (MySQL failed to connect.)
[2011-10-30 16:52:50] Start up of resource sql cancelled by script
[2011-10-30 16:52:50] ERROR: exports: Call to non-running server resource (sql) [string "?"]
[2011-10-30 16:52:50] Start up of resource players cancelled by script
[2011-10-30 16:52:50] ERROR: Unable to start resource players; Start up of resource cancelled by script

Je vais voire si j'arrive à trouver une solution. J'ai l'impression que le soucis vient de MySQL.

[Citizen]

Essaye avec ce mysql.lua

[CafeOLait]

Bonsoir,

Apres 2 heures de recherches, je tombe sur votre sujet...
J'ai exactement le même problème que Nova91...

J'ai essayer le mysql.lua de Citizen, mais j'ai toujours le problème...
Voici les logs...

Spoiler :

===========================================================
= Multi Theft Auto: San Andreas v1.2
===========================================================
= Server name      : paradise ~ Roleplay
= Server IP address:
= Server port      : 22003
=
= Log file         : .. 1.2/Server/mods/deathmatch/logs/server.log
= Maximum players  : 32
= HTTP port        : 22005
= Voice Chat       : Disabled
===========================================================
[2012-01-16 18:45:25] ERROR: Not processing resource 'admin' as it has duplicates on different paths:
                  Path #1: "resources\admin"
                  Path #2: "resources\[admin]\admin"
[2012-01-16 18:45:25] ERROR: Problem with resource: editor;
[2012-01-16 18:45:25] ERROR: Problem with resource: editor_main; Failed to link to freecam
[2012-01-16 18:45:25] ERROR: Not processing resource 'freecam' as it has duplicates on different paths:
                  Path #1: "resources\freecam"
                  Path #2: "resources\[editor]\freecam"
[2012-01-16 18:45:25] ERROR: Not processing resource 'interiors' as it has duplicates on different paths:
                  Path #1: "resources\interiors"
                  Path #2: "resources\[gameplay]\interiors"
[2012-01-16 18:45:25] ERROR: Problem with resource: job-carrier; Failed to link to interiors
[2012-01-16 18:45:25] ERROR: Not processing resource 'runcode' as it has duplicates on different paths:
                  Path #1: "resources\runcode"
                  Path #2: "resources\[admin]\runcode"
[2012-01-16 18:45:25] Resources: 220 loaded, 3 failed
[2012-01-16 18:45:25] Querying game-monitor.com master server... success!
[2012-01-16 18:45:25] Querying backup master server... success!
[2012-01-16 18:45:25] MODULE: Unable to find modules/mta_mysql.dll!
[2012-01-16 18:45:25] MODULE: Loaded "SHA Module" (1.02) by "mabako"
[2012-01-16 18:45:25] Starting resources.....
[2012-01-16 18:45:25] SCRIPT ERROR: sql\mysql.lua:27: malformed number near '127.0.0.1'
[2012-01-16 18:45:25] WARNING: Loading script failed: sql\mysql.lua:27: malformed number near '127.0.0.1'
[2012-01-16 18:45:25] Start up of resource irc cancelled by script
[2012-01-16 18:45:25] ERROR: Unable to start resource irc; Start up of resource cancelled by script

[2012-01-16 18:45:25] WARNING: players/main.lua(Line 379) [Server] setPedFrozen is deprecated and may not work in future versions. Please replace with setElementFrozen before Tuesday.
[2012-01-16 18:45:25] Some files in 'players' use deprecated functions.
[2012-01-16 18:45:25] Use the 'upgrade' command to perform a basic upgrade of resources.
[2012-01-16 18:45:25] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:25] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:25] Start up of resource players cancelled by script
[2012-01-16 18:45:25] ERROR: Unable to start resource players; Start up of resource cancelled by script

[2012-01-16 18:45:25] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:25] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:25] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:25] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:25] Start up of resource vehicles cancelled by script
[2012-01-16 18:45:25] ERROR: Unable to start resource vehicles; Start up of resource cancelled by script

[2012-01-16 18:45:25] ERROR: Couldn't find resource interiors. Check it exists.
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource players cancelled by script
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource items cancelled by script
[2012-01-16 18:45:26] ERROR: Unable to start resource items; Start up of resource cancelled by script

[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource players cancelled by script
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource vehicles cancelled by script
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource players cancelled by script
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource items cancelled by script
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource players cancelled by script
[2012-01-16 18:45:26] ERROR: Couldn't find resource admin. Check it exists.
[2012-01-16 18:45:26] WARNING: shops/shop.lua(Line 57) [Server] setPedFrozen is deprecated and may not work in future versions. Please replace with setElementFrozen before Tuesday.
[2012-01-16 18:45:26] Some files in 'shops' use deprecated functions.
[2012-01-16 18:45:26] Use the 'upgrade' command to perform a basic upgrade of resources.
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource players cancelled by script
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource items cancelled by script
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource players cancelled by script
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource shops cancelled by script
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource players cancelled by script
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:26] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:26] Start up of resource items cancelled by script
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource players cancelled by script
[2012-01-16 18:45:27] ERROR: Unable to start resource shops; Start up of resource cancelled by script

[2012-01-16 18:45:27] ERROR: Unable to start resource job-carrier; Failed to link to interiors
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource vehicles cancelled by script
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource vehicles cancelled by script
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource maps cancelled by script
[2012-01-16 18:45:27] ERROR: Unable to start resource maps; Start up of resource cancelled by script

[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource teleports cancelled by script
[2012-01-16 18:45:27] ERROR: Unable to start resource teleports; Start up of resource cancelled by script

[2012-01-16 18:45:27] ERROR: Couldn't find resource freecam. Check it exists.
[2012-01-16 18:45:27] WARNING: bank/bank.lua(Line 59) [Server] setPedFrozen is deprecated and may not work in future versions. Please replace with setElementFrozen before Tuesday.
[2012-01-16 18:45:27] Some files in 'bank' use deprecated functions.
[2012-01-16 18:45:27] Use the 'upgrade' command to perform a basic upgrade of resources.
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource players cancelled by script
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource players cancelled by script
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource items cancelled by script
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource players cancelled by script
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource bank cancelled by script
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource players cancelled by script
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource players cancelled by script
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource items cancelled by script
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource players cancelled by script
[2012-01-16 18:45:27] ERROR: Unable to start resource bank; Start up of resource cancelled by script

[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource players cancelled by script
[2012-01-16 18:45:27] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:27] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:27] Start up of resource factions cancelled by script
[2012-01-16 18:45:28] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:28] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:28] Start up of resource players cancelled by script
[2012-01-16 18:45:28] ERROR: Unable to start resource factions; Start up of resource cancelled by script

[2012-01-16 18:45:28] ERROR: sql\layout.lua:65: attempt to call global 'query_assoc_single' (a nil value)
[2012-01-16 18:45:28] ERROR: call: failed to call 'sql:create_table' [string "?"]
[2012-01-16 18:45:28] Start up of resource 3dtext cancelled by script
[2012-01-16 18:45:28] ERROR: Unable to start resource 3dtext; Start up of resource cancelled by script

[2012-01-16 18:45:28] Server started and is ready to accept connections!
[2012-01-16 18:45:28] Type 'help' for a list of commands.
[2012-01-16 18:45:28]               _                                    _ _
[2012-01-16 18:45:28]              | |                                  | (_)
[2012-01-16 18:45:28]     _ __ ___ | |_ __ _   _ __   __ _ _ __ __ _  __| |_ ___  ___
[2012-01-16 18:45:28]    | '_ ` _ \| __/ _` | | '_ \ / _` | '__/ _` |/ _` | / __|/ _ \
[2012-01-16 18:45:28]    | | | | | | || (_| | | |_) | (_| | | | (_| | (_| | \__ \  __/
[2012-01-16 18:45:28]    |_| |_| |_|\__\__,_| | .__/ \__,_|_|  \__,_|\__,_|_|___/\___|
[2012-01-16 18:45:28]                         | |
[2012-01-16 18:45:28]                         |_| v1.00

Dans mon malheur, j'ai encore un peu de chance...
il se lance, mais quand on essaye d'y acceder... un écran noir...

La, je Butte contre un mur... 

Auriez-Vous une idée?

PS: J'allais oublier...
Dans mysql.lua, je n'ai rien changé vu que c'est un bête serveur local
et que l'user ROOT est de rigueur...


Bonne soirée a tous 

[Citizen]

Bonsoir,
En fait il te manque une ( ou 2 dll ) pour que ton serveur connaissent les fonctions SQL.
et il utilise les fonctions de bases de libmysql qui doit être mis au même endroit que ton MTA Server.exe
Fiche mta_mysql et libmysql
Voila