Hello, I’ve installed infobright CE as a trial from the debian package on Ubuntu 10.10 (I’m also running mysql on the same machine).

When i try to execute the IB init script it times out to a red *. The results of the /data/bh.err log are:

Any guidance would be appreciated.

Thank you.

Following links may help:

http://www.infobright.org/Forums/viewthread/2464/
http://www.infobright.org/forums/viewthread/1809/

thanks

Thank you Mahib. I actually already saw those.

The first one indicates to run the following command but this is not correct:

mysql_update—user=mysql—ldata=/usr/local/infobright/data—force

The command is truncated and I believe refers to mysql_upgrade not update, which can only be run if MySQL is running.

The second article I used during install to get Infobright to install.

The problem I’m having now is that the daemon won’t start.

Shot in the dark: are you starting it using sudo?

Thanks,

Jeff

You can try mysqld command

/usr/local/infobright-4.0.3-x86_64/bin/mysqld—defaults-file=/etc/my-ib.cnf -uroot —console

I think there is permission issue on data folder. If so, then try chown to current user and group to that folder and rerun.

I’ve been executing:

/etc/init.d/mysqld-ib start

as root. But I get the same result when using sudo:

sudo /etc/init.d/mysqld-ib start
Starting MySQL
........ *

I still get the following:

110816 16:52:42 mysqld_safe Starting mysqld daemon with databases from /usr/local/infobright-4.0.3-x86_64/data
110816 16:52:42 [Warning] options—log-slow-admin-statements,—log-queries-not-using-indexes and—log-slow-slave-statements have no effect if—log_slow_queries is not set
/usr/local/infobright-4.0.3-x86_64/bin/mysqld: Table ‘mysql.plugin’ doesn’t exist
110816 16:52:42 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/local/infobright-4.0.3-x86_64/bin/mysqld: Unable to open /usr/local/infobright-4.0.3-x86_64/data/brighthouse.log
110816 16:52:42 [ERROR] Plugin ‘BRIGHTHOUSE’ init function returned error.
110816 16:52:42 [ERROR] Plugin ‘BRIGHTHOUSE’ registration as a STORAGE ENGINE failed.
110816 16:52:42 [ERROR] Unknown/unsupported table type: brighthouse
110816 16:52:42 [ERROR] Aborting

110816 16:52:42 [Note] /usr/local/infobright-4.0.3-x86_64/bin/mysqld: Shutdown complete

110816 16:52:42 mysqld_safe mysqld from pid file /usr/local/infobright-4.0.3-x86_64/data/analytics.pid ended

/usr/local/infobright-4.0.3-x86_64/bin/mysqld—defaults-file=/etc/my-ib.cnf -uroot —console

Result:

-bash: /usr/local/infobright-4.0.3-x86_64/bin/mysqld—defaults-file=/etc/my-ib.cnf: No such file or directory

I think the forum is jamming together the command. I do have an /etc/my-ib.cnf file. Can you post the command again with the “code” tag?

I just did this to try to see if this is what you were trying to tell me to do:

Hi

The command you tried is correct.

What is the output? As said earlier I think there is permission issue on the data folder. What is the permission on data folder?

Try these commands:

However Ubuntu 10.10 is not supported platform. I see there is different issue with our binary on my Ubuntu 10.04 box.
We support older version of Ubuntu (Ubuntu 8.04).

Results:

/usr/local/infobright-4.0.3-x86_64/bin/mysqld—defaults-file=/etc/my-ib.cnf -uroot —console
/usr/local/infobright-4.0.3-x86_64/bin/mysqld: Table ‘mysql.plugin’ doesn’t exist
110817 12:05:13 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
Loading configuration for Infobright instance ...
Option: AllowMySQLQueryPath, value: 0.
Option: AutoConfigure, value: 0.
Option: CacheFolder, value: /usr/local/infobright-4.0.3-x86_64/cache.
Option: ControlMessages, value: 0.
Option: InternalMessages, value: 0.
Option: KNFolder, value: BH_RSI_Repository.
Option: KNLevel, value: 99.
Option: LicenseFile, value: <unknown>.
Option: LoaderMainHeapSize, value: 320.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 600.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110817 12:05:13 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist

-rw-rw—— 1 mysql root 11294 2011-08-16 17:02 bh.err
drwxrwx—x 2 root root 4096 2011-08-16 14:39 BH_RSI_Repository
-rw-rw—— 1 root root 1904 2011-08-16 14:26 brighthouse.ini
-rw-rw—— 1 root root   406 2011-08-17 12:05 brighthouse.log
-rw-rw—— 1 root root   1 2011-08-16 14:39 brighthouse.seq
drwxr-xr-x 2 root root 4096 2011-08-16 14:26 mysql
-rw-rw—— 1 root root   0 2011-08-16 14:39 rsi_dir.rsd
drwxr-xr-x 2 root root 4096 2011-08-16 14:26 sys_infobright
drwxr-xr-x 2 root root 4096 2011-08-16 14:26 test
-rw-rw—— 1 root root   920 2011-08-17 12:05 updater.log

-rwxr-xr-x 1 root root 14024688 2011-06-15 13:43 /usr/local/infobright-4.0.3-x86_64/bin/updater

-rwxr-xr-x 1 root root 2141 2011-08-16 14:37 /etc/my-ib.cnf

Ok i’m confused now. I did a dpkg -r infobright and then a dpkg -i infobright***.deb for the third time and it miraculously works now…odd.

that is what I get, could anyone help?
/usr/local/infobright/bin/mysqld: Table ‘mysql.plugin’ doesn’t exist
120214 17:30:47 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
Loading configuration for Infobright instance ...
Option: AllowMySQLQueryPath, value: 0.
Option: AutoConfigure, value: 0.
Option: CacheFolder, value: /usr/local/infobright-4.0.5-x86_64/cache.
Option: ControlMessages, value: 0.
Option: InternalMessages, value: 0.
Option: KNFolder, value: BH_RSI_Repository.
Option: KNLevel, value: 99.
Option: LicenseFile, value: <unknown>.
Option: LoaderMainHeapSize, value: 320.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 600.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
120214 17:30:47 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist

Hi all.

Don’t install Infobright 4.05 from inside of a SCREEN session, it fails starting the service so far… Don’t know wy. Hope it helps. Good Luck.