BeBot - An Anarchy Online and Age Of Conan chat automaton
General => General discussion => Topic started by: lordamadeus on November 16, 2010, 02:56:36 pm
-
i got a webpage with php served with apache accessing mysql
but the bot says that mysql isnt there
running virtual private server -- ubuntu 8
please help, im going mad here :)
-
Install "mysql-cli" package, not sure what exactly the packages is named in Ubuntu 8
And i recomend you to upgrade your server as 8.04-lts isnt supported as stable release of Ubuntu anymore.
-
i got the vps at sh3lls.net, there is other versions of linux i can get, ubuntu is the main one ive seen on here and the only version available is 8, ill try to figure out that mysql-cli, i had to install cli for php scripts to work, didnt realize there was a mysql one also, thx :)
-
ive upgraded lamp to max available, which is im sure more than enough to run the bot, im getting:
_/_/_/ _/_/_/ _/_/_/ _/_/ _/_/
An Anarchy Online Chat Automaton
And
An Age of Conan Chat Automaton
v.0.6.8 - PHP 5.2.4-2ubuntu5.12
OS:
Your operating system is detected as 32bit
===================================================
MySQL support required to run this bot
its all setup basically the same way i had it setup on windows, but i got a webpage that works with php and mysql working fine, but form some reasont the bot is saying that, i have no idea lol
-
"aptitude search php|grep mysql"
i php5-mysql - MySQL module for php5
Do you have MySQL working on a webpage running at webserver?
And do "mysqlclient" work from command line?
-
Some setups have a separate php.ini for command line php and normal php. And you could experience that the commandline php simply does not load or enable mysql.
I would recommend creating a file called test.php containing only
<?php
phpinfo();
?>
and running it from command line php. This should output all settings information from the command line php viewpoint and you should then be able to grep both for "ini" and "mysql" to get a clearer picture.
-
got a dif issue now and i aint the only one from searching google
i for the sake of testing swapped my ubuntu 8 vps for a debian 5 vps (fresh mirror)
and mysql during install wont start due to dependency issues. i googled it and a lot of others around are having the same prob. "mysql-server-5.0" refuses to install and run. i had the exact same problem on the ubuntu but after a billion different things, i cant remember how i got it to work, and i do beleive that this error might have something to do with the bot not starting and not recognizing mysql being there.
if one of you can thro together a test box with ubuntu 8 or deb 5 and install lamp, one tell me if yall having the same issues, and two yall are far more qualified to fix such an issue, tell me how the heck you fix it
i have litterally spent nearly 30 hours researching and trying to get this to work, but im obviously missing something very crucial, i really am doing the work on my end but im getting nowhere lol
my vps so yall know what exactly i got
sh3lls.net -- linux vps hosting, currently running deb 5, i have the 10 dollar package, stripped down lamp with no extras should work on this package for private site and a few bots
i beat in one side of my head over this, starting on the other :)
-
back to ubuntu
mysqld refuses to start
im going freaking batty here :(
-
does bebot use "InnoDB"
-
InnoDB is an storage engine for MySQL.
As far as I can recall, BeBot does not specifically request a storage engine but allows MySQL to choose the default.
For your ubuntu problems I would recommend that you try seeking help on the official ubuntu support forums or irc channels.
-
http://208.98.29.146/index.php
looks a bit familiar :)
now y dont bebot work :P
-
http://bebot.link/general-discussion/loading-gun-aiming-at-ubuntu/msg16571/#msg16571
-
Delete the php.ini from BeBot's directory (remove this from BeBot and put it in the PHP bundle already...). That alone might solve your problem.
If not, then check /etc/php5. If there is no /etc/php5/conf.d directory, check /etc/php5/cli/php.ini and make sure the mysql.so extension is mentioned. extension=mysql.so
If there is a conf.d directory, make sure there is an /etc/php5/conf.d/mysql.ini file that contains the line: extension=mysql.so.
-
ive figured out a bunch of stuff.
http://aoforums.futureone.us
using budabot for the time being to save ram, doesnt require mysql, being that bebot albeit a great program, isnt of the standard to require industry class mysql database
from what i hav eseen running both bebots and budabots, the exchange of info, thruput/lag doesnt exsist, for a bot such as either of these, sqlite is well more than enough of a db.
i understand the mysql usage, portability. if php and mysql can run on the box, so can the bot. but if you really look at the mem stamp on a cheap 128 meg vps, for instance, php and mysql and the bot together, hahahahaha.
1 bot at full setup, and thats it, no web server, no nothing, just one bot.
using sqlite, a 128 meg vps can achieve a fully functional website (smf/simple portal), and 2 bots running at full capacitys (had to use budabot to do this).
bebot has features that budabot dont, and i want it back, but with my budget, i have no choice to use what i can use. either rewrite bebot to run on sqlite, or right a modult to translate mysql stuff into sqlite stuff so that sqlite can be used with bebot.
i would happily do it, but at my current skill lvl, that is quite a bit over my head.
welcome to my 12 cent rant :)
-
a liason module, sounds sexy i think ;)
write a mod that intercepts all db requests and restates them into sqlite SQL. that way you dont have to rewrite the whole thing, just an "update" or sorts. change a couple of the main core files to recongnize this new mod and create a new sqlite db to interact with.
there is a crap load of tools to tranlate the exsisting db from mysql to sqlite, but something that this mod can do as an aside since mysql is knwon well here, make a 1 time running mod to come with it that will convert the db as well.
in this way all you have to do is add to the exsisting bot for the most part, and there is a lot of memory crippled folks out there that would love you for it.
theres 3 more cents :)