Full documentation and information about XLRstats can be found on our XLRstats website: www.xlrstats.com

You are here: Big Brother Bot ForumAdd-OnsXLRstatsXLRstats webfron online installer cant connect to my database
Pages: [1]   Go Down
  Print  
Author Topic: XLRstats webfron online installer cant connect to my database  (Read 510 times) Bookmark and Share
Newbie
*
OS: Windows
Type: Owner dedicated server(s)
Gameservers: urt
Posts: 6
Offline Offline
« on: January 29, 2012, 05:12:00 PM »

i really really need help figuring out how to get my webfront connected to my database and the site going when i enter my database info it says cannot connect to the database if someone can help me it would be apreciated Smiley))  Cheesy
Logged

Dev. Team
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: COD2,COD4,COD5
Posts: 1098
Offline Offline
« Reply #1 on: January 29, 2012, 05:54:40 PM »

Are they on the same computer?
Logged
Support Hero
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2629
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #2 on: January 30, 2012, 06:09:10 AM »

As Bravo mentioned, we need more info.

1) Are the MySQL database and xlrstats on the same machine?
2) Are you able to connect to your database with a different tool such as Navicat?
3) Are you trying to use the username "root"? Most of the time it is tied to localhost.

Please provide more information for more help.
Logged

Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Newbie
*
OS: Windows
Type: Owner dedicated server(s)
Gameservers: urt
Posts: 6
Offline Offline
« Reply #3 on: January 30, 2012, 06:01:03 PM »

xlrstats and database are on the same machine
i ahvent tried to connect to my database with anything other than b3
im using localhost
i put in all the info that i put in for my b3 bot to connect to my database but the webfornt wont connect
EDIT:i can connect to it with navicat
ANOTHER EDIT:well wat do i have to do besides do that setup anyway? the one on the site http://xlr.cosiestao.net/install/
« Last Edit: January 30, 2012, 06:29:10 PM by undacova » Logged
Support Hero
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2629
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #4 on: January 31, 2012, 06:27:24 AM »

You have a old version of xlrstats.
Try updating to this one:

https://github.com/Freelander/xlrstats-web-v2/zipball/master
Logged

Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Newbie
*
OS: Windows
Type: Owner dedicated server(s)
Gameservers: urt
Posts: 6
Offline Offline
« Reply #5 on: February 01, 2012, 07:13:20 PM »

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM DEFAULT CHARSET=utf8' at line 20
cant make the ctim sql table!
and i still get the same online installer
« Last Edit: February 01, 2012, 07:19:09 PM by undacova » Logged
Support Hero
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2629
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #6 on: February 02, 2012, 05:21:01 AM »

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM DEFAULT CHARSET=utf8' at line 20
cant make the ctim sql table!
and i still get the same online installer
Well, what you need to do for ctime sql is edit with notepad, find and replace TYPE= with ENGINE=
Logged

Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Newbie
*
OS: Windows
Type: Owner dedicated server(s)
Gameservers: urt
Posts: 6
Offline Offline
« Reply #7 on: February 02, 2012, 03:02:52 PM »

ok got it to work now wat do i do?
Logged
Support Hero
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2629
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #8 on: February 02, 2012, 06:59:42 PM »

ok got it to work now wat do i do?
I don't know... if it working perfectly then you get to sit back and enjoy!
Logged

Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Newbie
*
OS: Windows
Type: Owner dedicated server(s)
Gameservers: urt
Posts: 6
Offline Offline
« Reply #9 on: February 02, 2012, 08:43:57 PM »

well it wont work now it wont connect to database again how do i do it wat login should i use
Logged
Support Hero
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2629
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #10 on: February 03, 2012, 05:40:44 AM »

well it wont work now it wont connect to database again how do i do it wat login should i use
You are going to have to be more specific.
Please clarify exactly what has happened? Have you installed the webfront completely or are you stuck in installing? What is the URL? IF you installed it before, did it work and now it doesn't? Or did it never work? And the like.

The more information you give, the better we can help you.
Logged

Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Tags:
Pages: [1]   Go Up
  Print  
 
Jump to:  


Rate this page +1 at Google Search


SimplePortal 2.3.1 © 2008-2009, SimplePortal