collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: loading gun, aiming at ubuntu  (Read 5260 times)

0 Members and 1 Guest are viewing this topic.

Offline lordamadeus

  • BeBot User
  • **
  • Posts: 45
  • Karma: +0/-0
loading gun, aiming at ubuntu
« 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 :)

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: loading gun, aiming at ubuntu
« Reply #1 on: November 16, 2010, 04:35:17 pm »
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.
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline lordamadeus

  • BeBot User
  • **
  • Posts: 45
  • Karma: +0/-0
Re: loading gun, aiming at ubuntu
« Reply #2 on: November 17, 2010, 01:38:10 am »
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 :)

Offline lordamadeus

  • BeBot User
  • **
  • Posts: 45
  • Karma: +0/-0
Re: loading gun, aiming at ubuntu
« Reply #3 on: November 17, 2010, 02:09:11 pm »
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

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: loading gun, aiming at ubuntu
« Reply #4 on: November 17, 2010, 05:06:32 pm »
"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?



Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline Khalem

  • BeBot Founder
  • Administrator
  • ********
  • Posts: 1169
  • Karma: +0/-0
    • http://www.ancarim.com
Re: loading gun, aiming at ubuntu
« Reply #5 on: November 17, 2010, 08:23:11 pm »
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
Code: [Select]
<?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.
BeBot Founder and Fixer Kingpin

Offline lordamadeus

  • BeBot User
  • **
  • Posts: 45
  • Karma: +0/-0
Re: loading gun, aiming at ubuntu
« Reply #6 on: November 18, 2010, 01:49:38 am »
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 :)

Offline lordamadeus

  • BeBot User
  • **
  • Posts: 45
  • Karma: +0/-0
Re: loading gun, aiming at ubuntu
« Reply #7 on: November 18, 2010, 05:02:05 pm »
back to ubuntu

mysqld refuses to start

im going freaking batty here :(

Offline lordamadeus

  • BeBot User
  • **
  • Posts: 45
  • Karma: +0/-0
Re: loading gun, aiming at ubuntu
« Reply #8 on: November 19, 2010, 01:33:25 am »
does bebot use "InnoDB"

Offline Khalem

  • BeBot Founder
  • Administrator
  • ********
  • Posts: 1169
  • Karma: +0/-0
    • http://www.ancarim.com
Re: loading gun, aiming at ubuntu
« Reply #9 on: November 19, 2010, 10:16:46 pm »
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.
BeBot Founder and Fixer Kingpin

Offline lordamadeus

  • BeBot User
  • **
  • Posts: 45
  • Karma: +0/-0
Re: loading gun, aiming at ubuntu
« Reply #10 on: November 20, 2010, 01:45:52 am »
http://208.98.29.146/index.php

looks a bit familiar :)

now y dont bebot work :P

Offline Khalem

  • BeBot Founder
  • Administrator
  • ********
  • Posts: 1169
  • Karma: +0/-0
    • http://www.ancarim.com
BeBot Founder and Fixer Kingpin

Offline Glarawyn

  • BeBot Hero
  • ******
  • Posts: 521
  • Karma: +0/-0
Re: loading gun, aiming at ubuntu
« Reply #12 on: December 07, 2010, 02:00:01 am »
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.


Offline lordamadeus

  • BeBot User
  • **
  • Posts: 45
  • Karma: +0/-0
Re: loading gun, aiming at ubuntu
« Reply #13 on: December 07, 2010, 11:22:01 am »
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 :)

Offline lordamadeus

  • BeBot User
  • **
  • Posts: 45
  • Karma: +0/-0
Re: loading gun, aiming at ubuntu
« Reply #14 on: December 07, 2010, 11:30:12 am »
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 :)

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 750
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal