You aren't using the proper syntax for setting the MySQL password.

SET PASSWORD FOR Nova@localhost = PASSWORD('*******');

The PASSWORD() function will create the 40 character hex whatever for you based on the string you provide the password function. Again, review the instructions carefully to find what you missed as the proper command for setting your MySQL password was included.

Win XP SP2, MySQL Server 5, running, PHP 5.2.0 (latest as of today), Apache 2.2, BeBot 2.10,

I too am getting the following when trying to call the bot up...


Warning: dl(): sockets: Unable to initialize module
Module compiled with module API=20050922, debug=0, thread-safety=1
PHP    compiled with module API=20060613, debug=0, thread-safety=1
These options need to match
 in C:\php\main.php on line 59
Loading php_sockets.dll failed. Sockets extention required to run this bot

Installed all extensions in my c:\php folder (where I have BeBot and PHP 5), modified the files, etc.  Sticks in a loop until I CTRL+C.  Apache has the stuff loaded, PHP 5 has Apache 2.2 modules loaded with the appropriate apache2blahblah.dll, etc.  What's causing the safty issue during compiling?

Khalem,

I did that.  Both PHP 5.2.0 and BeBot 2.10 are in the directory c:\php.  I installed the BeBot PHP package and the rest of the files properly.  Apache 2.2 is fully operational, so is MySQL5 with me having it open and pointing to the bot's database.   c:\php\Startbot.bat actually calls startbot.php which was not in the actual BeBot packages for v2.10.  Both start.php and startbot.bat are calling the php.exe within the c:\php\ folder.  Main.php, bot.php, and conf.php all point to the proper directory of c:\php as required.

To call the bot manually, I used CMD and went to the c:\php directory and then called php.exe start.php.  I still get the compiler safety message when compiling php_sockets.dll.  I ensured that the php_sockets.dll from the php_extension folder is the one I am using in every single directory.  I also checked PATH to ensure pathing points to the c:\php folder.  php_sockets.dll is in the following directories:  c:\php, c:\php\dlls, c:\php\php_extension, c:\windows, c:\windows\system, c:\windows\system32, and just to make sure, c:\windows\system32\dllcache.

The only thing I see different is BeBot's PHP coding is to PHP 5.1.5 and I am using 5.2.0.  When using BeBot's php.exe (5.1.5) it totally errors out and gives me the lovely "Report error" window.  When using PHP's 5.2.0 php.exe it gives me the compiling error on php_sockets.dll.   If you like, I can de-install PHP 5.2.0 and just install the BeBot PHP bundle and give that a try.  I just can't  understand the compiling error if it's the same file in all those places.