In our support boards we aim to provide support for the B3 core in its current state. Older releases of B3 are NOT supported. Check our front page for the latest version. You may post feature requests in our General Discussion board. Modifications and Hacks of the core B3 code are NOT supported.
Before you ask for support: [ Read the Support Instructions ] - More info: [ Full Support Disclaimer ]

You are here: Big Brother Bot ForumSupport ForumsInstallation Support (Moderator: MordyT)Server 2K3 64-bit database connection error due to MySql-Python (Resolved)
Pages: [1]   Go Down
  Print  
Author Topic: Server 2K3 64-bit database connection error due to MySql-Python (Resolved)  (Read 600 times) Bookmark and Share
Newbie
*
OS: Linux
Type: Owner dedicated server(s)
Gameservers: CoD4
Posts: 9
Offline Offline
WWW
« on: August 30, 2010, 04:46:30 PM »

This is not exactly my first installation, I have been dabbling for a couple of years and successfully installed on 32-bit Win platforms as well as Debian and CentOs. So I am not a *total* noob.  Grin

Now, it seems I am stuck. Has anyone successfully gotten B3 to run on a AMD64 Server 2K3 platform?

I am getting the all-too-familiar database connector problem:
Code:
100830 19:06:19 BOT     www.BigBrotherBot.com (b3) v1.3.3 [nt] (Daniel)
100830 19:06:19 BOT     Python: 2.6.6 (r266:84297, Aug 24 2010, 18:13:38) [MSC v.1500 64 bit (AMD64)]
100830 19:06:19 BOT     Starting Cod4Parser v1.3.2 for server 127.0.0.1:28960
100830 19:06:19 BOT     --------------------------------------------
100830 19:06:19 BOT     Attempting to connect to database mysql://SecretUserName:******@localhost/b3...
100830 19:06:19 CRITICAL DLL load failed: The specified module could not be found.. You need to install python-mysqldb. Look for 'dependencies' in B3 documentation.
Traceback (most recent call last):
  File "C:\Python26\lib\site-packages\b3-1.3.3-py2.6.egg\b3\storage.py", line 160, in getConnection
    import MySQLdb
  File "C:\Python26\lib\site-packages\MySQLdb\__init__.py", line 19, in <module>
    import _mysql
ImportError: DLL load failed: The specified module could not be found.
100830 19:06:19 INFO STDOUT 220
100830 19:06:19 INFO STDOUT

The MySql Python libraries are right where they belong but are not being loaded (I checked the file locations against a working 32-bit Windoze machine). I suspect the problem is with the 64-bit Python or MySql connector.

I am using the 64-bit MySql-Python package located here:
http://www.codegood.com/archives/4  (The "MySQL-python-1.2.2.win-amd64-py2.6.exe" version)

I tried to install the 32-bit versions and got an error on execution of the installer package. Any ideas?
« Last Edit: August 31, 2010, 03:55:22 PM by rdwilson » Logged

Senior Dev.
*
OS: Linux
Type: Home user
Posts: 3484
Offline Offline
WWW
Support Specialty: B3-Core, UrT/SmG/BFBC2 parsers, Plugin development
« Reply #1 on: August 30, 2010, 10:54:09 PM »

most issues with python mysqldb is when people install both python2.5 and python2.6 and install python-mysqldb for only one of them.

Your case looks similar from what we see in your log, but from your description it looks more tricky than this.
I'm running B3 on a Win7 64bit system but IIRC python2.6 and python-mysqldb 32bit. I have no experience with running the bot on python 64bit unfortunately
Logged

Newbie
*
OS: Linux
Type: Owner dedicated server(s)
Gameservers: CoD4
Posts: 9
Offline Offline
WWW
« Reply #2 on: August 31, 2010, 01:12:31 PM »

Thanks for the reply. This at least lets me know that it's possible to run on Win64 albiet with 32-bit binaries.

I can verify that only Ptyhon 2.6 (64-bit) is installed on this system.

When I try to run the Win32 installation of Python 26 I get the following error:
"This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem."

When I have seen this in the past (win32) it usually means a dependency is missing. So I installed the VB runtimes, C++ runtimes and Dot Net. Still the same error. Am I missing something here?

Sorry but I am but a lowly SysAdmin and not a coder.  Smiley

I prefer Linux game servers but this particular Clan has a long history with Halo and M$ only provides a Windows binary. WINE was not an option due to mixed reports of problems and lag.

If the 32-bit Python runs fine, I suppose I should try and tackle "shoehorning" it on this server unless someone else has a better suggestion.
Logged
Senior Dev.
*
OS: Linux
Type: Home user
Posts: 3484
Offline Offline
WWW
Support Specialty: B3-Core, UrT/SmG/BFBC2 parsers, Plugin development
« Reply #3 on: August 31, 2010, 02:09:04 PM »

in that case you could try the win32 standalone build of B3 which does not require to have python installed at all on your machine.
http://www.bigbrotherbot.net/forums/downloads/?sa=view;down=70
Logged

Newbie
*
OS: Linux
Type: Owner dedicated server(s)
Gameservers: CoD4
Posts: 9
Offline Offline
WWW
« Reply #4 on: August 31, 2010, 03:37:16 PM »

Thanks but already tried.

That executable tosses out the same error:
"This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem."

-------

Doh! I feel so stupid. I just downloaded and installed the 32-bit Visual C++ runtime and now the binaries will at least run. Of course I needed that!

I had been trying the 64-bit C++ on 32-bit binaries.  Roll Eyes

It is now complaining that there is no Python installed but I think that if I start from scratch with 32-bit only things will be OK.

I'll post back here with the results as this may help others in the same predicament.
Logged
Newbie
*
OS: Linux
Type: Owner dedicated server(s)
Gameservers: CoD4
Posts: 9
Offline Offline
WWW
« Reply #5 on: August 31, 2010, 04:03:32 PM »

OK, here's the fix for that specific problem.

B3 will run just fine under Server 2K3 64-bit. The trick is to use 100% 32-bit Python.

If you get the same error when trying to execute the 32-bit Python installers, get Microsoft's 32-bit C++ runtime. Here:
http://www.microsoft.com/downloads/details.aspx?familyid=9b2da534-3e03-4391-8a4d-074b9f2bc1bf&displaylang=en

Once I got help from the kind folks here in confirming that b3 *will* actually run, it took all of 10 minutes to get it up and running.

Thanks for the help!

Yippee!   Grin
Logged
Tags: 2k3 64 bit windows server 
Pages: [1]   Go Up
  Print  
 
Jump to:  


Rate this page +1 at Google Search


SimplePortal 2.3.1 © 2008-2009, SimplePortal