how to connect MYSQL to BixDataServer

Submitted by kyoti on October 30, 2006 - 00:43.Support

I'v downloaded BixDataServer(the one with the built in database) and BixDataAgent on the same machine but in different drivers, I also downloaded the MySQL database and ODBC connector. The problem is when I open the BixDataDesktop it gives me the agent information but I where I can get the database with the data from, I had added the Mysql databse to the server should I create tables or do they created automatically

The built-in database is

Submitted by bixdata on October 30, 2006 - 10:16.

The built-in database is postgres,http://www.postgresql.org/,you can connect to postgres with odbc / java or .net in the same way as you can to mysql. The username and password for postgres is listed in the bixserver/data/sqlservers.xml file.

If you dont want to use postgres, and you want to use Mysql.
follow the following steps:

0. Download and install BixServer (without a DB / advanced use)
1. Download and install MySQL 5.0 (we recommend mysql-5.0.18-win32.zip)
2. Download and install MySQL Connector 3.51 (we recommend mysql-connector-odbc-3.51.12-win32.zip)
3. Connect to MySQL with the command line utilities or MySQL Administrator and create a database called bixdata
4. If BixServer and MySQL is not on the same machine, read the section on MySQL permissions
5. Start BixServer and connect using BixDesktop
6. Click the Database Setup button in the left pane
7. Add a database to BixServer by right-clicking on the blue area marked "New" and choosing "New MySQL Server"
8. A new item will have appeared in the Databases list under "New", select it
9. Change the settings so that they match the database you made in step 3 and update them by clicking "Apply"
10. If you want to see if it's working, click "Test server". If the test fails you should go back and check to make sure you entered everything correctly and that MySQL is running.
11. Restart BixServer to enable notification history

i've entered all correctly

Submitted by saffri on December 7, 2006 - 20:48.

i've entered all correctly as my server is newly install and my database is using root user w/out password....still it show

Error: (Request Storage/EditDB): Unable to connect to database

in the red box next to the help button

by the way....how to collect data from my other server...i already scan my network with ping and snmp enable...correctly enter snmp string but then what...

We recommend using the built

Submitted by bixdata on December 7, 2006 - 23:42.

We recommend using the built in database, and connecting to postgres from java or perl/python.

Only once you've got that working, do we recommend using your own database.