Hi

I am trying to install version infobright-3.3.0-i686 on my fedora FC12 machine, and i keep getting the following error.
any ideas will be helpfull,
thank you
Nadav.

script output:

Creating user mysql… /usr/sbin/useradd mysql
useradd: user ‘mysql’ already exists
Failed on /usr/sbin/useradd mysql [ignored]
Installing default databases…
Installing all prepared tables
100124 9:44:51 [ERROR] Fatal error: Can’t change to run as user ‘mysql’ ;  Please check that the user exists!

100124 9:44:51 [ERROR] Aborting

100124 9:44:51 [Note] /home/nadav/Downloads/infobright-3.3.0-i686/bin/mysqld: Shutdown complete

Installation of system tables failed!

Examine the logs in /home/nadav/Downloads/infobright-3.3.0-i686/data for more information.
Failed on: scripts/mysql_install_db —defaults-file=/etc/my-ib.cnf —user=mysql —basedir=/home/nadav/Downloads/infobright-3.3.0-i686 —datadir=/home/nadav/Downloads/infobright-3.3.0-i686/data —cachedir=/home/nadav/Downloads/infobright-3.3.0-i686/cache
Rolling back the installation due to unexpected failure…
Installation failed! Please investigate the error messages.

Looks like you are installing inside homedir (/home/nadav). Do not install inside home dir. User mysql may not be able to work on that folder.
Try some other place (outside of /home, /root etc). better place is /usr/local/

cheers

the same error when i install form /usr/local

Installing default databases…
Warning: /usr/local/infobright-3.3.0-i686/data/brighthouse.ini moved to /usr/local/infobright-3.3.0-i686/data/brighthouse.ini_old.
Installing all prepared tables
100124 17:11:13 [ERROR] Fatal error: Can’t change to run as user ‘mysql’ ;  Please check that the user exists!

100124 17:11:13 [ERROR] Aborting

100124 17:11:13 [Note] /usr/local/infobright-3.3.0-i686/bin/mysqld: Shutdown complete

Installation of system tables failed!

Examine the logs in /usr/local/infobright-3.3.0-i686/data for more information.
Failed on: scripts/mysql_install_db —defaults-file=/etc/my-ib.cnf —user=mysql —basedir=/usr/local/infobright-3.3.0-i686 —datadir=/usr/local/infobright-3.3.0-i686/data —cachedir=/usr/local/infobright-3.3.0-i686/cache
Rolling back the installation due to unexpected failure…
Installation failed! Please investigate the error messages.

nadav - 24 January 2010 11:15 AM

the same error when i install form /usr/local

I have the same issue on Fedora 12 but I see here that Fedora 9 is the highest level currently supported. 

Are there plans to support more current releases of Fedora?

This may be obvious, but are you installing as root?

Geoffrey

yes

Fedora Core 12 - http://fedoraproject.org/ - only takes a few minutes to install in a virtual image.  Perhaps Infobright’s Platform Engineering team can give it a try with ICE.

I think I got Infobright to install on Fedora 12. The bug looks like it might be related to this MySQL bug: http://bugs.mysql.com/bug.php?id=4408
discussed here:
http://forums.mysql.com/read.php?11,83400,83400#msg-83400

My solution (based on this: http://forums.mysql.com/read.php?11,83400,91927#msg-91927 ) was to edit the install-infobright.sh script and change line 619 to add the “sudo -u mysql” like this:

cmd_sed=“sudo -u mysql scripts/mysql_install_db\\
—defaults-file=$my_conf\\
—user=$user\\
—basedir=$PREFIX\\
—datadir=”$bh_datadir”\
—cachedir=$bh_cachedir”

The caveat is that the mysql user has to have write permissions on the location where Infobright is trying to install (and so the mysql user must exists already). a simple

useradd mysql

and

chown -R mysql:mysql

covers that.

I don’t know if there are any other hidden gotchas form installing this way, but at least now I can evaluate Infobright!

Oh, and since the version of MySQL can’t change to the mysql user, the server must be started as the mysql user, like this:

sudo -u mysql bin/mysqld_safe—defaults-file=/etc/my-ib.cnf—user=mysql

Thanks for digging into the problem and finding the fix. We will look at this issue.

In case I run

sudo -u mysql bin/mysqld_safe—defaults-file=/etc/my-ib.cnf—user=mysql

do I have full featured IB service running?

Thanks,
Andriy

@andrijz, yes,if you run
sudo -u mysql bin/mysqld_safe—defaults-file=/etc/my-ib.cnf—user=mysql
will get featured IB service.