next »

[ilxShot]

Hi,
I'd like to run Echelon from my website but if I try to connect to a DB on the website (for b3) I (ofc) get a error, here is the log

Code:

111117 20:28:14 BOT    'www.bigbrotherbot.net (b3) v1.7.1 [nt] [Myrthe]'
111117 20:28:14 BOT    'Python: 2.7.2 (default, Jun 12 2011, 15:08:59) [MSC v.1500 32 bit (Intel)]'
111117 20:28:14 BOT    'Default encoding: ascii'
111117 20:28:14 BOT    'Starting Iourt41Parser v1.11.0 for server 127.0.0.1:27960'
111117 20:28:14 BOT    '--------------------------------------------'
111117 20:28:14 BOT    'Attempting to connect to database mysql://md235059db190126:******@db.truewarriorsclan.nl/md235059db190126...'
111117 20:28:35 ERROR 'Database connection failed, working in remote mode: (2003, "Can\'t connect to MySQL server on \'db.truewarriorsclan.nl\' (10060)") - [(\'C:\\\\UrbanTerror\\\\b3\\\\b3\\\\storage\\\\database.py\', 231, \'connect\', \'self.db = self.getConnection()\'), (\'C:\\\\UrbanTerror\\\\b3\\\\b3\\\\storage\\\\database.py\', 176, \'getConnection\', \'use_unicode = True)\'), (\'C:\\\\Python27\\\\lib\\\\site-packages\\\\MySQLdb\\\\__init__.py\', 81, \'Connect\', \'return Connection(*args, **kwargs)\'), (\'C:\\\\Python27\\\\lib\\\\site-packages\\\\MySQLdb\\\\connections.py\', 187, \'__init__\', \'super(Connection, self).__init__(*args, **kwargs2)\')]'
111117 20:28:35 BOT    'Game log C:\\UrbanTerror\\q3ut4\\games.log'
111117 20:28:35 BOT    'Starting bot reading file C:\\UrbanTerror\\q3ut4\\games.log'

Im running b3 as you possibly can see with UrT on a homeserver, a another option is that I make a 2nd DB for Echelon on my homeserver self but than is the question how to connect on the website (im running XAMPP and I always need to open the ports my selve)

[MordyT]

You need to open the posts on the webserver (or add your ip in cpanel for remote access) so that mysql server will accept connections from your computer. Then B3 will be able to write to the db on the webserver.

The other option is to open the ports on your pc and have echelon connect to your computer.

[ilxShot]

The other option is to open the ports on your pc and have echelon connect to your computer.

And to do that? (which ports and how do I config xampp)

[MordyT]

You need to open port 3306, forward it through your router, then go into phpmyadmin and make sure that the user which b3 uses (i.e. root) is not restricted to localhost.

[ilxShot]

Ok, its still not quite working

Code:

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'echelon'@'blade111.mijndomein.nl' (using password: YES) in /public/sites/www.truewarriorsclan.nl/echelon/Connections/wwwvalidate.php on line 3
Access denied for user 'echelon'@'blade111.mijndomein.nl' (using password: YES)

Anyone maybe got some experince with doing this with the dutch hoster Mijndomein?
Could he help me?

"alvast bedankt"

[Garreth]

You've got access denied info, so triple check your login/password/databaseaddress/database name.
Also, check if you've got access to the database from the internet. By default, if you create user and database in mysql, access to it is restricted to the localhost.

[ilxShot]

Yes,...

It now finally works, the trick was that when you make a DB account you have to set under the space that you fill in the name, what is the host (or "machine") and select instead of local, Any host.

ty all