Xaseco won't start:( pls help!

Discuss everything about Xymph's Aseco flavoured server control scripts for TM Forever / classic TMN and for TM² Canyon.

Moderators: Xymph, TM-Patrol

Post Reply
Pajo
wheelbarrow operator
wheelbarrow operator
Posts: 21
Joined: 12 Nov 2009 18:15
Owned TM-games: TMU, TM2
Location: Cazin

Xaseco won't start:( pls help!

Post by Pajo » 10 Aug 2010 17:27

Hey all , i have one question for you all i have a big problem on my servers xaseco won't start and i tryed to fix it but i can't find the problem :S..Hope u can help me :
[Local DB] Load settings file [localdatabase.xml]
> [Local DB] Try to connect to MySQL server on 'localhost' with database
> 'aseco10'
> [PHP Warning] mysql_connect(): Access denied for user 'root'@'localhost'
> (using password: YES) on line 74 in file
> /usr/games/trackmania/Server10/xaseco/plugins/plugin.localdatabase.php
> [XASECO Fatal Error] [Local DB] Could not authenticate at MySQL server!
> on line 75 in file
> /usr/games/trackmania/Server10/xaseco/plugins/plugin.localdatabase.php

Please give me the detail explanation what is wrong here , i tryed to use new user but same error :S..Thanks!

User avatar
maau
road tourist
road tourist
Posts: 101
Joined: 12 Apr 2009 18:36
Owned TM-games: Finally I've TMUF ^^

Re: Xaseco won't start:( pls help!

Post by maau » 10 Aug 2010 18:52

Well, I configured my XAseco DB loooong ago so I don't remember it well.

But I think you had misspelled something wrong in the config of plugin.localdatabase.php. Try checking if you configured fine the username and the password of your DB, or wait for someone more experienced than me ^^
Image

Image

dukez30
sunday driver
sunday driver
Posts: 59
Joined: 23 Aug 2008 14:26
Owned TM-games: TMU

Re: Xaseco won't start:( pls help!

Post by dukez30 » 10 Aug 2010 18:54

Self explanitory really - Your passwords don't match in your configs.....

nocturne
solid chaser
solid chaser
Posts: 1390
Joined: 08 Jun 2007 18:48
Owned TM-games: all
Contact:

Re: Xaseco won't start:( pls help!

Post by nocturne » 10 Aug 2010 19:11

Don't use root accounts to run anything... security nightmare.
Chief Janitorial Supervisor of the Let'sRock! TM community : www.LetsRock-TM.com

User avatar
haker0srb
sunday driver
sunday driver
Posts: 56
Joined: 08 Jul 2009 06:59
Owned TM-games: TMUF

Re: Xaseco won't start:( pls help!

Post by haker0srb » 11 Aug 2010 03:34

Thank you for the answers but they are definitely funny :D Do you are overwriting the answers from other places!
Don't use root accounts to run anything... security nightmare.
MySQL don't accept remote connections and xaseco don't run in WEB directory.
Self explanitory really - Your passwords don't match in your configs.....
All passwords are ok, and until yesterday all servers worked without problem!

All other scripts except xaseco work without problems! Example:
<?php
$link = mysql_connect('localhost', '****', '*********');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully!';
mysql_close($link);
?>

Output: Connected successfully! Try it http://178.63.226.163/test_mysql.php

PhpMyAdmin work, MySQL monitor work ... And please do not talk to me that the wrong password in the config file because it can be done only by child! If anyone knows a real answer please say something. Meanwhile, Flash is on the same machine without any problems! And also use mysql database!!!

cat /etc/*-release
CentOS release 5.5 (Final)

Now I try this:
CREATE USER 'aseco1'@'localhost' IDENTIFIED BY '******';
GRANT USAGE ON * . * TO 'aseco1'@'localhost' IDENTIFIED BY '******' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE IF NOT EXISTS `aseco1` ;
GRANT ALL PRIVILEGES ON `aseco1` . * TO 'aseco1'@'localhost';
FLUSH PRIVILEGES ;

Users having access to "aseco1"
aseco1 localhost database-specific ALL PRIVILEGES

Change config to:
<!-- MySQL Server Settings -->
<mysql_server>localhost</mysql_server>
<mysql_login>aseco1</mysql_login>
<mysql_password>*****</mysql_password>
<mysql_database>aseco1</mysql_database>

:3 For some reason the problem is related to more concurrent connections to mysql with root account just in case xaseco, no other scripts. But in any case, now works ... barely :3
Last edited by haker0srb on 11 Aug 2010 04:21, edited 1 time in total.
International >Click to Join<

User avatar
Clinton
smooth traffic navigator
smooth traffic navigator
Posts: 241
Joined: 26 Jan 2008 20:56
Owned TM-games: TMU, TMN, TMO
Location: Dripping Springs, Texas
Contact:

Re: Xaseco won't start:( pls help!

Post by Clinton » 11 Aug 2010 03:59

You don't have to use root. Make a an account like xaseco@localhost & xaseco@127.0.0.1

Also, your authentication is messed up somewhere, so recheck everything including mysql.
Image

http://allgamer.net cheapest Trackmania server hosting with the best support. We also do VPS hosting, Dedicated Servers, and Web Hosting! Request a free 3 day trial for a VPS

clinton@teameo.net for more information.

User avatar
haker0srb
sunday driver
sunday driver
Posts: 56
Joined: 08 Jul 2009 06:59
Owned TM-games: TMUF

Re: Xaseco won't start:( pls help!

Post by haker0srb » 11 Aug 2010 04:25

Clinton wrote:You don't have to use root. Make a an account like xaseco@localhost & xaseco@127.0.0.1

Also, your authentication is messed up somewhere, so recheck everything including mysql.
Do you see this :D
Output: Connected successfully! Try it http://178.63.226.163/test_mysql.php

Please read whole post ty ;)

Complete mysql has been deleted and re-installed and it did not help :D

Whatever xaseco and root do not go together, other scripts works. Why is this so i still do not understand :ftw:
International >Click to Join<

User avatar
Clinton
smooth traffic navigator
smooth traffic navigator
Posts: 241
Joined: 26 Jan 2008 20:56
Owned TM-games: TMU, TMN, TMO
Location: Dripping Springs, Texas
Contact:

Re: Xaseco won't start:( pls help!

Post by Clinton » 11 Aug 2010 10:52

I didn't see that post because I was typing at the time.... I have about 15 tabs open at any given time.

You shouldn't use root anyway, it's very insecure to do so.
Image

http://allgamer.net cheapest Trackmania server hosting with the best support. We also do VPS hosting, Dedicated Servers, and Web Hosting! Request a free 3 day trial for a VPS

clinton@teameo.net for more information.

Post Reply