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
-
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.
-
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
-
http://www.phpmyadmin.net/
It's a GUI for administrating mysql databases, and it's great.
-
Prefer SQLyog myself. :)
http://www.webyog.com/sqlyog/index_sqlyogfree.php
-
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.
-
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.
-
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
-
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.
-
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 ??? ???
-
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)
-
it seems that it was a problem of ; missess ; ; ; ;
anyway the servers are down
i will try later
-
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
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
-
would i have to make that change for vista?
-
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.
# localhost name resolution is handled within DNS itself.
127.0.0.1 localhost
::1 localhost
-
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
-
I have the same problem, just started learning about AO bots since yesterday.
Can anyone throw a noob a bone please ? ;D
-
unknow dimension crom
any idea?
-
I feel bad today :/
Any idea?
-
Crom run better...
-
My point was that you should give better info about your problem then just 3 words if you want any help...
-
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?
-
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".
-
i do not find these lines.
in any of this php.ini or main.ini.
-
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...
-
Read what the error messages are telling you.....
Hfabot.MySQL.conf and MySQL.conf Does not Exist
What do you want to do?
Warning: include(conf/MySQL.conf): failed to open stream: No such file or directory in C:\bebot\Sources\MySQL.php on line 62
-
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.
-
Hey :)
You are using the wrong version (a very old one)
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)
-
Thank You Yite!!!! For your time in and out game, the bot finally run :)
-
I just have to say, I love this guide :)
-
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 :)
-
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
-
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
-
/tell orgbot !AlienAttack didnt work either, have no clue why.
-
/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)
-
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?
-
look at reply #11 it sounds like the issue you are having just and idea though
-
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
-
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?
-
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. :)
-
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
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
-
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.
-
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.
-
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?