BeBot - An Anarchy Online and Age Of Conan chat automaton

General => Helpful posts => Topic started by: Glarawyn on April 27, 2006, 11:42:44 pm

Title: MySQL n00b help.
Post by: Glarawyn on April 27, 2006, 11:42:44 pm
I may regret this at a later date, but here's a guide to help you get MySQL up and running on your Windows machine so you can run BeBot.

First, you'll need MySQL. Download the Windows Essentials package from MySQL.com (http://dev.mysql.com/downloads/mysql/5.0.html). This is a MSI based installer. If it doesn't work for you, go to Microsoft Update (http://update.microsoft.com) to install the latest Windows Installer.

The installer is simple.

Phase 1: MySQL Installer
1. Click Next.
2. Select Typical, Click Next.
3. Click Install.
4. Select Skip Sign-Up, Click Next.
5. Check Configure MySQL Server Now, Click Finish.

Now you should be in the MySQL Server Instance Configuration Wizzard.

Phase 2: MySQL Server Instance Configuration Wizzard.
1. Click Next.
2. Select Detailed Configuration, Click Next.
3. Select Developer Machine, Click Next.
4. Select Multifunctional Database, Click Next.
5. Select C: and Installation Path, Click Next.
6. Select Decision Support, Click Next.
7. Check Enable TCP/IP Networking and Enable Strict Mode, Click Next.
8. Select Standard Character Set, Click Next.
9. Check Install As Windows Servers, Check Launch the MySQL Server automatically, Check Include Bin Directory in Windows PATH, Click Next.
10. Enter and confim your root password. Write down your root password and do not loose it!!! Do not check Enable root access from remote machines. Click Next.
11. Click Execute.
12. Click Finish. Reboot your computer.

At this point, you have MySQL installed and configured, but you haven't yet created a MySQL database.

Phase 3: Logging into MySQL
1. Open a command prompt. (Start > Run > CMD, Click OK)
2. In the command prompt, enter the command mysql -u root -p
3. Enter your root password (You did write it down so you wouldn't forget it right?)

You should now have a MySQL prompt that looks like: mysql>

Phase 4: Create a Database and Database User for BeBot
1. Type CREATE DATABASE databasename; (replace databasename with the name of the database you wish to create)
2. Press Enter/Return.
3. CREATE USER username@localhost; (Change username to the username you want, keep @localhost)
4. Press Enter/Return.
5. SET PASSWORD FOR username@localhost = PASSWORD('newpassword'); (Change username and newpassword to your selected username and password, again keep @localhost)
6. Press Enter/Return.
7. Type GRANT ALL on databasename.* TO username@localhost; (Again, change username, keep @localhost)
8. Press Enter/Return.
9. Type quit then Enter/Return to exit the MySQL Monitor.

Phase 5: Import items.sql to your database
IMPORTANT: This only applies for BeBot version older than 0.2.4
1. In the cmd.exe window, enter the command:
mysql -u username -p databasename < c:\bebot\items.sql
Change username and databasename to the names you selected in Phase 5. (You don't need @localhost)
2. Press Enter/Return.

Phase 6: Configure BeBot
1. Edit MySQL.conf, add the values you selected.
    $dbase = "databasename";
    $user = "username";
    $pass = "newpassword";
    $server = "localhost";
2. Edit Bot.conf following the instructions in INSTALL_GUILDBOT.txt or INSTALL_RAIDBOT.txt.
3. Run start.bat.

That's it, you're off and running.

Backing Up and Restoring your Database
It's reccomended that you backup your database. If the worst happens, you can easily recover. And the command to do so is simple:
mysqldump -u username -p --databases databasename --add-drop-table -a -f  > filename.sql

To restore a database dump:
mysql -u username -p databasename < filename.sql

Other Helpful Tools
MySQL Administrator (http://dev.mysql.com/downloads/administrator/1.1.html) GUI MySQL Admin Tool.
MySQL Query Browser (http://dev.mysql.com/downloads/query-browser/1.1.html) GUI Query Tool.
MySQL Documentation (http://dev.mysql.com/doc/) The documentation, duh.
Title: Re: MySQL n00b help.
Post by: Dice on April 28, 2006, 03:22:18 am
Awsome guide. Good work, Glarawyn. :)

I just want to add that when you install MySQL on a old windows OS, like 98, MySQL cannot be run as a service, ie: the option to install it as a service is greyed out in the installer. In this case you need to run mysqld.exe from the ./bin directory manually or 'autostart' it.

...well, at least that's what I had to do. Me <- MySQL n00b too. ;D
Title: Re: MySQL n00b help.
Post by: Wolfbiter on April 28, 2006, 11:25:04 am
http://www.phpmyadmin.net/

It's a GUI for administrating mysql databases, and it's great.
Title: Re: MySQL n00b help.
Post by: Xenixa on May 12, 2006, 11:58:19 am
Prefer SQLyog myself. :)

http://www.webyog.com/sqlyog/index_sqlyogfree.php
Title: Re: MySQL n00b help.
Post by: blofeld on August 03, 2006, 01:21:46 pm
Probably me being dumb somewhere but I followed all your steps up to rebooting the computer and using the password at the command prompt.

I can type in create database *name (name can be anything) but I can never actually create a database.  Doesn't matter what I do, I've checked the Mysql folder and nothing is showing up there.

After 4 reinstalls I'm ready to pitch this and live without a bot.

Hope you can help.
Title: Re: MySQL n00b help.
Post by: Pharexys on August 03, 2006, 03:33:08 pm
Probably me being dumb somewhere but I followed all your steps up to rebooting the computer and using the password at the command prompt.

I can type in create database *name (name can be anything) but I can never actually create a database.  Doesn't matter what I do, I've checked the Mysql folder and nothing is showing up there.

After 4 reinstalls I'm ready to pitch this and live without a bot.

Hope you can help.

Here you can find a nicely guide to install php + apache + mysql, mostly mysql will interest you i guess.

http://mpcon.org/apacheguide/mysql.php

Also please remember that, you have to open mysql promt cmd from start -> all prgs -> mysql.
Then enter the password you set for root, in mysql instalation.
Then type: create database <name of database>;
(remove < and >)
note: you have to put ; at end of evry line in mysql cmd promt.
Title: Re: MySQL n00b help.
Post by: blofeld on August 04, 2006, 12:45:27 am
Bah, told you i was dumb  :-[

Added the ; on the lines and got bot running

Still have problems but i'll take that to different thread

Thanks for help
Title: Re: MySQL n00b help.
Post by: Skidrow on November 19, 2009, 12:43:00 pm
Thankyou thankyou thankyou Pharexys when i read ; i took it here it end so i never tried to add that when i tried to make the database.
Title: Re: MySQL n00b help.
Post by: belatu on January 18, 2010, 11:13:10 pm
the only thing i can get is this





        Your operating system is detected as 32bit

===================================================

MySQL ERROR(# 1) on query: Cannot connect to the database server at localhost as
 user belatucadros!
Se produjo un error durante el intento de conexi¾n ya que la parte conectada no
respondi¾ adecuadamente tras un periodo de tiempo, o bien se produjo un error en
 la conexi¾n establecida ya que el host conectado no ha podido responder.
-----------------------------------------------------------------------------

o please help me!!  :o :o :o :o :o

what can i do ??? ???
Title: Re: MySQL n00b help.
Post by: belatu on January 19, 2010, 03:48:10 pm
another error :( :( :( :( :( :(

         v.0.6.6 - PHP 5.3.1

                 OS: Windows_NT

        Your operating system is detected as 32bit

===================================================

MySQL ERROR(# 1) on query: Cannot connect to the database server at localhost as
 user belatucadros!
Access denied for user 'belatucadros'@'localhost' (using password: YES)
Title: Re: MySQL n00b help.
Post by: belatu on January 19, 2010, 05:06:27 pm
it seems that it was a problem of ; missess ; ; ; ;

anyway the servers are down

i will try later

Title: Re: MySQL n00b help.
Post by: Arawacian on March 07, 2010, 02:00:44 pm
Think I found the solution to an issue on windows 7, I am not completely noob, but I almost broke my skull over the fact that I couldnt get the bot started . It had the famous standard problem connecting to MYsql
Code: [Select]
MySQL ERROR(# 1) on query: Cannot connect to the database server at localhost as
 user xxxxxxxx!
Access denied for user 'xxxxxxxxxx'@'localhost' (using password: YES)
So thinking i made a mistake in either DB creation or user addition I checked.... and checked... and uninstalled.... reinstalled... and checked and still not working...

AT work now i realize and found additional evidence that in windows 7 the line for 127.0.0.1 localhost is not included in your hosts file anymore...

Gonna check when I get home if this was the issue.

uncommenting the 127.0.0.1 localhost line in the hosts file resolves the issue for win 7
Title: Re: MySQL n00b help.
Post by: dragonjr on October 05, 2010, 01:18:24 am
would i have to make that change for vista?
Title: Re: MySQL n00b help.
Post by: TBK on October 05, 2010, 11:28:54 pm
would i have to make that change for vista?

Windows key + R, type "%windir%\system32\drivers\etc\hosts", open the file in notepad

Then uncomment the two lines, so you end up with the same result as displayed below.
Code: [Select]
# localhost name resolution is handled within DNS itself.
127.0.0.1       localhost
::1             localhost
Title: Re: MySQL n00b help.
Post by: Killaah on November 11, 2010, 12:56:33 am
Hi guys,

Just trying to setup bebot for my guild in AOC. Everything appears to be fine but im stuck on this error.

[10-Nov-2010 23:15:41] PHP Warning:  mysql_connect(): [2002] A connection attempt failed because the connected party did not  (trying to connect via tcp://localhost:3306) in C:\guildbot\Sources\MySQL.php on line 129
[10-Nov-2010 23:15:41] PHP Warning:  mysql_connect(): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 in C:\guildbot\Sources\MySQL.php on line 129

ANy suggestions?

Cheers in advance
Title: Re: MySQL n00b help.
Post by: slipster1012 on August 02, 2011, 09:01:23 pm
I have the same problem, just started learning about AO bots since yesterday.

Can anyone throw a noob a bone please ?   ;D
Title: Re: MySQL n00b help.
Post by: Ankou on December 07, 2011, 09:18:40 am
unknow dimension crom

any idea?
Title: Re: MySQL n00b help.
Post by: Getrix on December 07, 2011, 10:12:41 am
I feel bad today :/

Any idea?
Title: Re: MySQL n00b help.
Post by: Ankou on December 07, 2011, 10:17:20 am
Crom run better...
Title: Re: MySQL n00b help.
Post by: Getrix on December 07, 2011, 02:17:54 pm
My point was that you should give better info about your problem then just 3 words if you want any help...
Title: Re: MySQL n00b help.
Post by: Ankou on December 07, 2011, 03:11:27 pm
ok... I have find a new bebot/sources files and now the bot run more or less.
when i use the startdebugbot i have:

Hfabot [LOGIN] [STATUS]   connecting to server aoc-eu-um.live.ageofconan.com:7000
Hfabot [LOGIN] [STATUS]  Authenticating XXXXXXX
Read error: EOF
AOChat:

C:\bebot>pause
Appuyez sur une touche pour continuer...
-----------------------------------------------------------------------------------------------

and in all the dos i have the same Warning message:

Warning: strtotime<>: It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the dat_default_timezone
_set<> function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected
Europe/Paris for '1.0/no DST' instead in C:\bebot\sources\Bot.php on line 1849


But in the line 1849 i dont find nothing like this and I think I have the good hour in my PC.

Can you help me?
Title: Re: MySQL n00b help.
Post by: grey on December 07, 2011, 03:35:55 pm
Find your correct time zone identifier here:
http://www.php.net/manual/en/timezones.php

Then edit your "date.timezone" settings in php.ini or "date_default_timezone_set" in "BeBot/Main.php".
Title: Re: MySQL n00b help.
Post by: Ankou on December 07, 2011, 04:34:31 pm
i do not find these lines.
in any of this php.ini or main.ini.
Title: Re: MySQL n00b help.
Post by: Ankou on December 07, 2011, 09:47:19 pm
hace install all my bebot file, and use
http://bebot.shadowrealm.org/wiki/installation#phase_4create_a_database_and_database_user_for_bebot
to know what to do.

now i have a new message using startbot:

Hfabot.MySQL.conf and MySQL.conf Does not Exist
 What do you want to do?
(r=Retry, n=new, q=quit)
Select:

and using startbotdebug:

===================================================

    _/_/_/              _/_/_/                _/

   _/    _/    _/_/    _/    _/    _/_/    _/_/_/_/

  _/_/_/    _/_/_/_/  _/_/_/    _/    _/    _/

 _/    _/  _/        _/    _/  _/    _/    _/

_/_/_/      _/_/_/  _/_/_/      _/_/        _/_/

         An Anarchy Online Chat Automaton

                     And

          An Age of Conan Chat Automaton

         v.0.6.8 - PHP 5.3.8

                 OS: Windows_NT

        Your operating system is detected as 32bit

===================================================

Curl not available

Warning: include(conf/MySQL.conf): failed to open stream: No such file or direct
ory in C:\bebot\Sources\MySQL.php on line 62

Warning: include(): Failed opening 'conf/MySQL.conf' for inclusion (include_path
='.;C:\php\pear') in C:\bebot\Sources\MySQL.php on line 62

Warning: mysql_connect(): Access denied for user ''@'localhost' (using password:
 NO) in C:\bebot\Sources\MySQL.php on line 129
MySQL ERROR(# 1) on query: Cannot connect to the database server at  as user !
Access denied for user ''@'localhost' (using password: NO)
C:\bebot>pause
Appuyez sur une touche pour continuer...
Title: Re: MySQL n00b help.
Post by: Getrix on December 07, 2011, 10:10:41 pm
Read what the error messages are telling you.....

Quote
Hfabot.MySQL.conf and MySQL.conf Does not Exist
 What do you want to do?

Quote
Warning: include(conf/MySQL.conf): failed to open stream: No such file or directory in C:\bebot\Sources\MySQL.php on line 62

Title: Re: MySQL n00b help.
Post by: Ankou on December 08, 2011, 11:39:28 pm
have read the msg. but i have the bot conf in the conf file.
after it i have reinstall the conf file and have a new probleme...


===================================================

    _/_/_/              _/_/_/                _/

   _/    _/    _/_/    _/    _/    _/_/    _/_/_/_/

  _/_/_/    _/_/_/_/  _/_/_/    _/    _/    _/

 _/    _/  _/        _/    _/  _/    _/    _/

_/_/_/      _/_/_/  _/_/_/      _/_/        _/_/

          An Age of Conan Chat Automaton

             v.0.5.3.Hyborian - PHP 5.3.8

===================================================

MySQL database connection test successfull
Creating MySQL class!

Warning: Missing argument 2 for AOChat::AOChat(), called in C:\bebot-hyborian\Ma
in.php on line 163 and defined in C:\bebot-hyborian\Sources\AOChat.php on line 1
90
Creating AOChat class!
Creating main Bot class!
Hfabot [MAIN]   [DIR]   Loading main functions of the bot
Hfabot [MAIN]   [LOAD]  00_BotError.php
Hfabot [MAIN]   [LOAD]  01_BasePassiveModule.php
Hfabot [MAIN]   [LOAD]  02_BaseActiveModule.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [MAIN]   [LOAD]  03_Security.php
Hfabot [CORE]   [ERROR] Module 'access_control' does not exist or is not loaded.

Hfabot [ERROR]  [access_control]        Undefined function create(all, maintenan
ce, OWNER)!

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [MAIN]   [LOAD]  05_Maintenance.php
Hfabot [MAIN]   [LOAD]  06_Preferences.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [SETTINGS]       [LOAD]  Loaded settings from database.
Hfabot [MAIN]   [LOAD]  06_Settings.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [MAIN]   [LOAD]  09_AccessControl.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [MAIN]   [LOAD]  10_Roster.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [MAIN]   [LOAD]  11_FlexibleSecurity.php
Hfabot [MAIN]   [LOAD]  12_ConfigMagik.php
Hfabot [MAIN]   [LOAD]  14_Tools.php
Hfabot [MAIN]   [LOAD]  15_AOChatWrapper.php
Hfabot [MAIN]   [LOAD]  15_BotHelp.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [MAIN]   [LOAD]  15_ChatQueue.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [MAIN]   [LOAD]  15_Colors.php
Hfabot [MAIN]   [LOAD]  15_CommandAlias.php
Hfabot [MAIN]   [LOAD]  15_Log.php
Hfabot [MAIN]   [LOAD]  15_Notify.php
Hfabot [MAIN]   [LOAD]  15_OnlineDB.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [SETTINGS]       [SAVED] Set SchemaVersion for module Timer to 1
Hfabot [MAIN]   [LOAD]  15_Timer_Core.php

Hfabot [CORE]   [DIR]   Loading core-modules

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [CORE]   [LOAD]  Alts.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [CORE]   [LOAD]  BotStatistics.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [CORE]   [LOAD]  Buddy_Queue.php
Hfabot [CORE]   [LOAD]  FunFilters.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [CORE]   [LOAD]  Logon_Notifies.php
Hfabot [CORE]   [LOAD]  ModuleCatcher.php
Hfabot [CORE]   [LOAD]  PlayerNotes.php
Hfabot [CORE]   [LOAD]  Professions.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [CORE]   [LOAD]  ShortCuts.php
Hfabot [CORE]   [LOAD]  Statistics.php
Hfabot [CORE]   [LOAD]  StringFilter.php
Hfabot [CORE]   [LOAD]  Time.php
Hfabot [CORE]   [LOAD]  User.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [CORE]   [LOAD]  Whois.php

Hfabot [CORE-CUSTOM]    [DIR]   Loading additional core-modules in directory cus
tom/core/

Hfabot [MOD]    [DIR]   Loading modules
Hfabot [MOD]    [LOAD]  About.php
Hfabot [MOD]    [LOAD]  AccessControlUI.php
Hfabot [MOD]    [LOAD]  AFK.php
Hfabot [MOD]    [LOAD]  AltsUI.php
'Hfabot [MOD]   [LOAD]  Autouseradd.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [MOD]    [LOAD]  BanManagerUI.php
Hfabot [MOD]    [LOAD]  Bid.php
Hfabot [SETTINGS]       [SAVED] table_version for module Blacklist set to 2 as d
atatype int
Hfabot [BLACKLIST]      [UPDATE]        Blacklist table update complete.

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [MOD]    [LOAD]  Blacklist.php
Hfabot [MOD]    [LOAD]  Calc.php
Hfabot [MOD]    [LOAD]  Chuck.php
Hfabot [MOD]    [LOAD]  City.php
Hfabot [MOD]    [LOAD]  ColorConfigUI.php
Hfabot [MOD]    [LOAD]  CommandAliasUI.php
Hfabot [SETTINGS]       [UPDATE]        Set longdesc for setting [Countdown][Cha
nnel] to in which channel should a countdown be shown? in the channel of origin,
 or in both gc and pgmsg?
Hfabot [SETTINGS]       [UPDATE]        Set defaultoptions for setting [Countdow
n][Channel] to both;gc;pgmsg;origin
Hfabot [MOD]    [LOAD]  Countdown.php
Hfabot [MOD]    [LOAD]  Craftclasses.php
Hfabot [MOD]    [LOAD]  FlexibleSecurityUI.php
'Hfabot [MOD]   [LOAD]  Gemcutting.php
Hfabot [SETTINGS]       [SAVED] connected for module irc set to FALSE as datatyp
e bool
Hfabot [SETTINGS]       [UPDATE]        Set longdesc for setting [Irc][AnnounceW
hat] to which events should be announced to irc? none, only  buddies logging on,
 only joins to the chatgroup or both?
Hfabot [SETTINGS]       [UPDATE]        Set defaultoptions for setting [Irc][Ann
ounceWhat] to none;buddies;joins;both
Hfabot [MOD]    [LOAD]  IRC.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [MOD]    [LOAD]  Is.php
'Hfabot [MOD]   [LOAD]  Items.php
Hfabot [MOD]    [LOAD]  Logon.php
Hfabot [MOD]    [LOAD]  Loot.php
Hfabot [MOD]    [LOAD]  Mail.php
Hfabot [MOD]    [LOAD]  MassMsg.php
Hfabot [MOD]    [LOAD]  ModulesControlUI.php
Hfabot [MOD]    [LOAD]  News.php
Hfabot [MOD]    [LOAD]  Notify.php
Hfabot [MOD]    [LOAD]  nroll.php
Hfabot [MOD]    [LOAD]  OnlineCount.php
Hfabot [MOD]    [LOAD]  OnlineDisplay.php
Hfabot [MOD]    [LOAD]  Ping.php
Hfabot [MOD]    [LOAD]  PlayerNotesUI.php
Hfabot [MOD]    [LOAD]  Points.php
Hfabot [MOD]    [LOAD]  PreferencesUI.php
Hfabot [MOD]    [LOAD]  Quotes.php
Hfabot [MOD]    [LOAD]  Raffle.php
Hfabot [MOD]    [LOAD]  Raid.php
Hfabot [MOD]    [LOAD]  Rally.php
Hfabot [MOD]    [LOAD]  Roll.php

Warning: strtotime(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/Paris' for '1.0/no DST' instead in C:\bebot-hyborian\Sources\Bot.php on l
ine 1694
Hfabot [MOD]    [LOAD]  Roster.php
Hfabot [MOD]    [LOAD]  Rules.php
Hfabot [MOD]    [LOAD]  Say.php
Hfabot [MOD]    [LOAD]  SettingsUI.php
Hfabot [MOD]    [LOAD]  ShortCutsUI.php
Hfabot [MOD]    [LOAD]  Shutdown.php
Hfabot [MOD]    [LOAD]  StringFilterUI.php
Hfabot [MOD]    [LOAD]  TimerRelay.php
Hfabot [MOD]    [LOAD]  TimerUI.php
Hfabot [MOD]    [LOAD]  Whois.php

Hfabot [MOD-CUSTOM]     [DIR]   Loading additional modules in directory custom/m
odules/


Hfabot [LOGIN]  [STATUS]        Connecting
Hfabot [LOGIN]  [STATUS]        Authenticating
Read error: EOF
AOChat:

C:\bebot-hyborian>pause
Appuyez sur une touche pour continuer...


i have read the messages about the line 1694 and no found nothing like message said.
Title: Re: MySQL n00b help.
Post by: Yite on December 09, 2011, 12:19:10 am
Hey :)

You are using the wrong version (a very old one)
Quote
v.0.5.3.Hyborian - PHP 5.3.8

* Clear all you have
* Download 0.6.8 here: https://launchpad.net/bebot/+download
* Unzip this file
* Replace the file sources\AOChat.php with the one I sent you
* Download PHP for windows here: http://windows.php.net/download/
* Follow the instructions here: http://bebot.link/wiki/installation
* Run the bot by typing: php StartBot.php
* Report any errors here :)

(I just ran through all these steps myself to run one of my test bots from my windows machine instead of from my ubuntu box and can verify they work, only ran into an issue where it wanted the php extensions in c:\php so created c:\php and put the php_curl.dll php_mbstring.dll php_mysql.dll php_sockets.dll from the php zip file in it)

Title: Re: MySQL n00b help.
Post by: Ankou on December 09, 2011, 08:53:17 pm
Thank You Yite!!!! For your time in and out game, the bot finally run :)
Title: Re: MySQL n00b help.
Post by: Aesgaard on June 22, 2012, 02:05:14 am
I just have to say, I love this guide :)
Title: Re: MySQL n00b help.
Post by: Qcbcal50 on October 11, 2012, 05:38:20 pm
Hi there
Another gimp hehe.
Bot runs fine, however, what settngs do i need to change, and to what, running org bot and a raid bot, to fix :
1: Raid bot dont spam org bot
2: Raid bot holds all org members as *members* so they can logg on to raidbot.
3: Alts have same rank on both bots.
4: enable wave counter in city raid

I have more questions, but wana go slow :)
Title: Re: MySQL n00b help.
Post by: Shelly on October 12, 2012, 02:48:30 am
Hi there
Another gimp hehe.
Bot runs fine, however, what settngs do i need to change, and to what, running org bot and a raid bot, to fix :
1: Raid bot dont spam org bot
log in as your <orgbot> and /ignore <raidbot>
2: Raid bot holds all org members as *members* so they can logg on to raidbot.
make sure your raidbot is a member of your org. then look at the /tell raidbot !security
3: Alts have same rank on both bots.
See item 2 :)
4: enable wave counter in city raid
/tell orgbot !AlienAttack
and look at the settings.
I have more questions, but wana go slow :)

Hope this helps :)

Shelly
Title: Re: MySQL n00b help.
Post by: Qcbcal50 on October 12, 2012, 07:13:48 pm
didnt work to ignor raidbot, might be some issues on that bot setup, working on it.
testing the rest atm :)
Thx for help anyway :)
I will ask more hehe
Title: Re: MySQL n00b help.
Post by: Qcbcal50 on October 12, 2012, 08:19:13 pm
/tell orgbot !AlienAttack didnt work either, have no clue why.
Title: Re: MySQL n00b help.
Post by: Shelly on October 14, 2012, 02:38:34 am
/tell orgbot !AlienAttack didnt work either, have no clue why.
You probably do not have the module I wrote installed. :)

Have a look at: http://bebot.link/ao-0-6-x-customunofficial-modules/city-alien-attack-wave-mod/msg16504/#msg16504 (http://bebot.link/ao-0-6-x-customunofficial-modules/city-alien-attack-wave-mod/msg16504/#msg16504)
Title: Re: MySQL n00b help.
Post by: Vetiver on May 26, 2013, 12:39:32 am
I am trying to set up MySQL, and I am getting this message when I try to configure it.

mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: NO)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:81 - Attempting to Add New MySQL Users
mysql-server-5.6-win32:100 - Unable to add New Users. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.

Then it finishes, but tells me the configuration failed.  I tried turning the firewall off, no luck...  I am not sure where the security settings it is trying to update are.  Any suggestions?
Title: Re: MySQL n00b help.
Post by: dragonjr on May 26, 2013, 02:25:20 am
look at reply #11 it sounds like the issue you are having just and idea though
Title: Re: MySQL n00b help.
Post by: Shelly on May 26, 2013, 11:52:57 pm
I am trying to set up MySQL, and I am getting this message when I try to configure it.

[snip]

mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: NO)

[snip]

mysql-server-5.6-win32:100 - Unable to add New Users. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.

Then it finishes, but tells me the configuration failed.  I tried turning the firewall off, no luck...  I am not sure where the security settings it is trying to update are.  Any suggestions?

You did not setup MySQL correctly. The application cannot log into the server (not a firewall issue there). The password you set for user root is not matching -or- you forgot to allow from localhost in the MySQL user permissions.

Shelly
Title: Re: MySQL n00b help.
Post by: Vetiver on May 28, 2013, 05:56:59 pm
Thanks, Shelly!  Any idea where I need to look to add that root user?  I *thought* I  had set up root, but not sure now.  I did something with a root user, and made sure to write down the password, but...  I gather that is not the same as root @ localhost?  Where do I allow localhost?
Title: Re: MySQL n00b help.
Post by: Shelly on May 29, 2013, 02:44:38 am
Not wanting to overwhelm you with *all* the details ^_^ here are a couple good to know links to get you going.

This link --> MySQL Documentation & Help (http://dev.mysql.com/doc/index-topic.html) <-- has a wealth of information about what to do to setup MySQL.

I suggest --> MyPhpAdmin (http://www.phpmyadmin.net/home_page/index.php) <-- as a tool to help you administer your MySQL installation. :)
Title: Re: MySQL n00b help.
Post by: dragonjr on April 10, 2014, 04:02:17 am
ok i had to re-install the bot and i havent had to play with the files in a long time and i thought i did everything right but im getting a error


Code: [Select]
Fatal error: Call-time pass-by-reference has been removed in C:\bebot\Main.php o
n line 298

Fatal error: Call-time pass-by-reference has been removed in C:\bebot\Main.php o
n line 298

Fatal error: Call-time pass-by-reference has been removed in C:\bebot\Main.php o
n line 298

Fatal error: Call-time pass-by-reference has been removed in C:\bebot\Main.php o
n line 298

Fatal error: Call-time pass-by-reference has been removed in C:\bebot\Main.php o
n line 298

Fatal error: Call-time pass-by-reference has been removed in C:\bebot\Main.php o
n line 298

Fatal error: Call-time pass-by-reference has been removed in C:\bebot\Main.php o
n line 298
 
what am i doing wrong ?
any help would be grate thanks
Title: Re: MySQL n00b help.
Post by: Tyrence on April 18, 2014, 09:32:40 am
I'm guessing you moved the bot to a new server or similar?  The problem is that the version of Bebot you are running (or one of the modules) is designed for an older version of PHP than you are running.

First thing would be to try with the latest version of Bebot.  If that doesn't work then you need to install an older version of PHP (and make sure Bebot uses that older version).  I am not familiar enough with Bebot to say which version you should use, but probably PHP 5.3 or 5.2.
Title: Re: MySQL n00b help.
Post by: twig on February 28, 2015, 12:22:05 am
Ok i'm getting this:

Fatal error:  Call-time pass-by-reference has been removed in C:\Bebot\Main.php on line 298

any suggestions?

I followed these instructions http://bebot.link/wiki/installation.
Title: Re: MySQL n00b help.
Post by: twig on February 28, 2015, 04:55:09 am
ok got the Main.php fixed now a new issue.

Bot configuration is outdated or corrupted.
Please check it's contents against the template.

Any suggestions?
SimplePortal 2.3.7 © 2008-2024, SimplePortal