Bix Server Cannot connect to database
I have followed all the instructions and the bixserver seems to run ok, but I cannot log the information becasue the database is not working. I get this when I ./runserver.sh
[root@Cel104 bixdata]# ./runserver.sh
BixServer version 2.6; Copyright 2004 - 2006 (http://www.bixdata.com)
Community edition, host limit of 30 hosts
Using data path: /root/bixdata/bixserver/data/
Public Key Signature A81779A1982BDBEC42576544DEE9F16C4865CBC3
DB Layer :: No database driver found. You may be missing a required library for this database type. [-1]
sqllib :: Warning: Unable to initialize database connection 0; skipping
BixServer :: Please wait while the database server starts...
Authentication disabled
Own default port 7071
Auto enumerating interfaces
Found Interface 127.0.0.1
Creating listener on 127.0.0.1:7071
Found Interface 209.67.253.74
Creating listener on 209.67.253.74:7071
Any suggestions?
Thanks,
Celeste
I installed BixServer-2.6-linux-1-DB.tar.gz SO I think that is the one with the database?
THe machine is - well of course the server would be down at this particular moment (attacked this morning) so I don;t have the specifics. It is a linux machine - I think Fedora?
I was trying to follow the instructions on the setup page telling me how to connect to a database. The machine has mysql on it already and in use, but it won't connect to that either "To setup MySQL with BixServer follow the following steps:
Download and install MySQL 5.0 (we recommend mysql-5.0.18-win32.zip)
Download and install MySQL Connector 3.51 (we recommend mysql-connector-odbc-3.51.12-win32.zip)
Connect to MySQL with the command line utilities or MySQL Administrator and create a database called bixdata
If BixServer and MySQL is not on the same machine, read the section on MySQL permissions
Start BixServer and connect using BixDesktop
Click the Database Setup button in the left pane
Add a database to BixServer by right-clicking on the blue area marked "New" and choosing "New MySQL Server"
A new item will have appeared in the Databases list under "New", select it
Change the settings so that they match the database you made in step 3 and update them by clicking "Apply"
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.
Restart BixServer to enable notification history "
I am having a problem becasue I am logging in with root to start the bixserver?? "BixServer-DB has no special installation instructions. The only difference is that you cannot run it with root privileges on Unix-type systems for security reasons. All features of BixServer work on an unprivileged account." If so how do I create another user?
Is there any better documentation on how to use this thing??
There is no setup needed for the DB edition, the steps about MYSQL is just needed for advance use.
Heres what you should do
As ROOT, execute the following commands:
adduser bixuser
passwd bixuser
su - bixuser
wget http://bixdata.com:/files/BixServer-2.6-linux-1-DB.tar.gz
tar -zxvf BixServer-2.6-linux-1-DB.tar.gz
cd bixdata/
./runserver.sh
We've updated the install instructions. Hope this helps
Did you install the advance use Server, or the one that includes a Database?
Which platform are you running, and if you are connecting to your own db, which DB?
Try the DB version, its pretty easy to get up and running with that.
J