-
Notifications
You must be signed in to change notification settings - Fork 144
preparing_the_environment
Phase 2 focusses on creating the environment necesary to run B3. Things like creating a database on the MySQL server, gathering important data from the gameserver, generating config files and stuff like that. You will probably have to do this only once.
- Create a database in MySQL for B3 to use. Create a user that has full permissions on this database for B3.\
<note tip>You could also do this by running the script b3/docs/b3-db.sql on MySQL, but don't forget to edit the password in that file first.</note>
To do so, either use:
-
phpmyadmin: http://www.phpmyadmin.net if you have it installed
-
MySQL Gui Tools:http://dev.mysql.com/downloads/gui-tools/5.0.html
-
or, if you have a Linux system, run the following commands :
<note shell>mysql -u root -p<mysql password>b3-db.sql</note>
- On the database you just created, import the b3.sql file located in b3/docs/ to create the tables and insert the initial values in your database.
<note tip>This step solves the errorERROR Query failed -<class '_mysql_exceptions.ProgrammingError'>: (1146, "Table 'urt.groups' doesn't exist")that you might find in your b3.log file</note>
To do so, either use:
-
phpmyadmin: http://www.phpmyadmin.net if you have it installed. Select your database and click on 'Import'.
-
MySQL Gui Tools:http://dev.mysql.com/downloads/gui-tools/5.0.html
-
or, if you have a Linux system, run the following commands :
<note shell>mysql -u root -p<mysql password>b3 b3.sql</note>
B3 main config file is called b3.xml by default. If you run the bot straight away, it will detect you did not properly setup the main config file and will walk through a config wizard where each setting is prompted with a short description.
If you don't want to use the config wizard you can also configure the main b3.xml config file using the manual config method or use our online Config Generator.
<note important>When choosing the manual config method please make sure you are using a proper xml-editor to make sure the xml syntax is correct!\ We suggest you use Notepad++ with its XML plugin</note>
Take me to the next page: Phase 3: Running B3