ICE 4.04 installation problems |
|
|
| Posted: 29 September 2011 11:23 AM |
[ Ignore ]
|
|
|
Newbie
Total Posts: 10
Joined 2009-06-08
|
Hello,
I am using CentOS 5.7, 64-bit. Downloaded ICE and tried installing it and got the following errors:
110929 11:17:42 mysqld_safe Starting mysqld daemon with databases from /ebs/infobright/data
110929 11:17: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.4-x86_64/bin/mysqld: Table 'mysql.plugin' doesn't exist
110929 11:17:42 [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/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: 800.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 24000.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110929 11:17:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
110929 11:17:42 mysqld_safe mysqld from pid file /ebs/infobright/data/ip-10-136-66-211.pid ended
110929 11:18:58 mysqld_safe Starting mysqld daemon with databases from /ebs/infobright/data
110929 11:18:58 [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.4-x86_64/bin/mysqld: Table 'mysql.plugin' doesn't exist
110929 11:18:58 [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/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: 800.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 24000.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110929 11:18:58 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
110929 11:18:58 mysqld_safe mysqld from pid file /ebs/infobright/data/ip-10-136-66-211.pid ended
I did as it suggested and tried to run mysql_upgrade and got the following:
[root@ip-10-136-66-211 bin]# /usr/local/infobright/bin/mysql_upgrade
Warning: /usr/local/infobright/bin/mysql_upgrade: unknown variable 'loose-local-infile=1'
Looking for 'mysql' as: /usr/local/infobright/bin/mysql
Looking for 'mysqlcheck' as: /usr/local/infobright/bin/mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql-ib.sock'
/usr/local/infobright/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql-ib.sock (2) when trying to connect
FATAL ERROR: Upgrade failed
Any advice would be appreciated… very stuck and no idea what to do.
|
|
|
|
|
|
| Posted: 29 September 2011 11:56 AM |
[ Ignore ]
[ # 1 ]
|
|
|
Administrator
Total Posts: 31
Joined 2011-06-20
|
Hi Patrick,
Please see thread http://www.infobright.org/forums/viewthread/2507/
Try also installing/starting nscd before installing Infobright.
Once installed, it is also recommended to run:
mysql_update—user=mysql—ldata=/usr/local/infobright/data—force
Thanks,
Steve Aldrich
|
|
|
|
|
|
| Posted: 29 September 2011 12:15 PM |
[ Ignore ]
[ # 2 ]
|
|
|
Newbie
Total Posts: 10
Joined 2009-06-08
|
Hi Steve,
- ncsd is already installed and started
- Your command appears formatted funny, and the command mysql_update is nowhere to be found in the /bin directory. The closest match is mysql_upgrade
I ran the following command:
[root@ip-10-136-66-211 bin]# ./mysql_upgrade --user=mysql --datadir=/ebs/infobright/data --force
Warning: ./mysql_upgrade: unknown variable 'loose-local-infile=1'
./mysql_upgrade: the '--datadir' option is always ignored
Looking for 'mysql' as: ./mysql
Looking for 'mysqlcheck' as: ./mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql-ib.sock'
./mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql-ib.sock (2) when trying to connect
FATAL ERROR: Upgrade failed
[root@ip-10-136-66-211 bin]# service nscd start
Starting nscd: /usr/sbin/nscd: already running
[FAILED]
|
|
|
|
|
|
| Posted: 29 September 2011 12:56 PM |
[ Ignore ]
[ # 3 ]
|
|
|
Administrator
Total Posts: 139
Joined 2008-08-18
|
Hi superdx,
ICE is available on the following platforms:
Windows Server 2008/2003
Red Hat Enterprise Linux 5
Debian ‘Lenny’
CentOS 5.2
The installation has been tested on the above platforms/OS, so there might be an issue on CentOS 5.7. Can you find one of the above mentioned platform/OS?
regards,
Kethees.
|
|
|
|
|
|
| Posted: 29 September 2011 12:57 PM |
[ Ignore ]
[ # 4 ]
|
|
|
Newbie
Total Posts: 10
Joined 2009-06-08
|
Sorry it is 5.2, don’t know why I typed 5.7
|
|
|
|
|
|
| Posted: 29 September 2011 01:02 PM |
[ Ignore ]
[ # 5 ]
|
|
|
Administrator
Total Posts: 139
Joined 2008-08-18
|
Hi,
Did you run the installation as root?
Can you attach the installation log /tmp/ib*install.log?
and the log files /usr/local/infobright/data/bh.err and /usr/local/infobright/data/brighthouse.log if they exist.
regards,
Kethees.
|
|
|
|
|
|
| Posted: 29 September 2011 01:06 PM |
[ Ignore ]
[ # 6 ]
|
|
|
Newbie
Total Posts: 10
Joined 2009-06-08
|
Hope this helps.
bh.err
110929 11:41:18 mysqld_safe Starting mysqld daemon with databases from /ebs/infobright/data
110929 11:41:18 [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.4-x86_64/bin/mysqld: Table 'mysql.plugin' doesn't exist
110929 11:41:18 [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/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: 800.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 24000.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110929 11:41:18 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
110929 11:41:18 mysqld_safe mysqld from pid file /ebs/infobright/data/ip-10-136-66-211.pid ended
110929 11:44:48 mysqld_safe The file /usr/local/infobright/libexec/mysqld
does not exist or is not executable. Please cd to the mysql installation
directory and restart this script from there as follows:
./bin/mysqld_safe&
See http://dev.mysql.com/doc/mysql/en/mysqld-safe.html for more information
110929 11:45:02 mysqld_safe Starting mysqld daemon with databases from /ebs/infobright/data
/usr/local/infobright/bin/mysqld: Table 'mysql.plugin' doesn't exist
110929 11:45:02 [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/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: 800.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 24000.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110929 11:45:02 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
110929 11:45:02 mysqld_safe mysqld from pid file /ebs/infobright/data/ip-10-136-66-211.pid ended
The install log:
09:07:59 Installing infobright 4.0.4-0 (x86_64)
09:07:59 The installer will generate /tmp/ib4.0.4-0-install.log install trace log.
09:07:59 [step: pre (4.0.4-0, 1=1)]
09:07:59 build type: static
09:07:59 GLIBC path is /lib64/libc.so.6, strings=/usr/bin/strings
09:08:05 [step: post (4.0.4-0), 1=1]
09:08:05 Install with RPM_INSTALL_PREFIX=/usr/local, current prefix=/usr/local/infobright, prefix_actual=/usr/local/infobright-4.0.4-x86_64
09:08:05 upgrade=
09:08:05 Config file /etc/my-ib.cnf created
09:08:05 sed -e 's+@BH_PORT@+5029+' -e 's+@BH_BASEDIR@+/usr/local/infobright-4.0.4-x86_64+' -e 's+@BH_SOCK@+/tmp/mysql-ib.sock+' -e 's+@BH_DATADIR@+/usr/local/infobright-4.0.4-x86_64/data+' < /usr/local/infobright-4.0.4-x86_64/support-files/my-ib-master.cnf.in > /etc/my-ib-master.cnf
09:08:05 sed -e 's+@BH_PORT@+5029+' -e 's+@BH_BASEDIR@+/usr/local/infobright-4.0.4-x86_64+' -e 's+@BH_SOCK@+/tmp/mysql-ib.sock+' -e 's+@BH_DATADIR@+/usr/local/infobright-4.0.4-x86_64/data+' < /usr/local/infobright-4.0.4-x86_64/support-files/my-ib-slave.cnf.in > /etc/my-ib-slave.cnf
09:08:05 Creating/Updating datadir and cachedir
09:08:05 Creating user mysql and group mysql
09:08:05 Installing default databases
09:08:06 scripts/mysql_install_db --defaults-file=/etc/my-ib.cnf --user=mysql --basedir=/usr/local/infobright-4.0.4-x86_64 --datadir=/usr/local/infobright-4.0.4-x86_64/data --cachedir=/usr/local/infobright-4.0.4-x86_64/cache --force
not ini exist
09:08:06 Setting optimal memory settings for infobright
09:08:06 System Physical memory: 35007(MB)
09:08:06 sed -e 's/\#[ ]*ServerMainHeapSize[ ]*=[ 0-9]*/ServerMainHeapSize=24000/' -e 's/\#[ ]*LoaderMainHeapSize[ ]*=[ 0-9]*/LoaderMainHeapSize=800/' < /usr/local/infobright-4.0.4-x86_64/data/brighthouse.ini > /usr/local/infobright-4.0.4-x86_64/data/brighthouse.ini.tmp
09:08:06 Infobright optimal ServerMainHeapSize is set to 24000(MB)
09:08:06 Infobright optimal LoaderMainHeapSize is set to 800(MB)
09:08:06 create_daemon>
09:08:06 cmd_sed=sed -e 's+@BH_CONF@+/etc/my-ib.cnf+' -e 's+@BH_USER@+mysql+' < /usr/local/infobright/support-files/mysql.server> /etc/init.d/mysqld-ib
09:08:06 <create_daemon done.
09:08:06 Infobright server installed into folder /usr/local/infobright
09:08:06 Installation log file /tmp/ib4.0.4-0-install.log
Skipping confman during installation..
09:08:06 --------------------------------------
09:08:06 To activate infobright server, please run ./postconfig.sh script from /usr/local/infobright-4.0.4-x86_64.
09:08:06 Example command: cd /usr/local/infobright-4.0.4-x86_64; ./postconfig.sh
brighthouse.log
2011-09-29 11:17:42 Brighthouse engine started.
2011-09-29 11:18:58 Brighthouse engine started.
2011-09-29 11:37:59 Brighthouse engine started.
2011-09-29 11:41:18 Brighthouse engine started.
2011-09-29 11:45:02 Brighthouse engine started.
|
|
|
|
|
|
| Posted: 29 September 2011 01:17 PM |
[ Ignore ]
[ # 7 ]
|
|
|
Administrator
Total Posts: 139
Joined 2008-08-18
|
Hi,
What is data directory? Can you attach /etc/my-ib.cnf file?
From the error message, it is using /ebs/infobright/data as the data directory but in the install log it’s set to /usr/local/infobright-4.0.4-x86_64/data. Did you change the data directory after the installation?
regards,
Kethees.
|
|
|
|
|
|
| Posted: 29 September 2011 01:20 PM |
[ Ignore ]
[ # 8 ]
|
|
|
Newbie
Total Posts: 10
Joined 2009-06-08
|
Yes, I changed it using postconfig.sh
Here is the permissions on /ebs/infobright, /ebs/infobright data:
[root@ip-10-136-66-211 infobright]# ls -al
total 12
drwxr-xr-x 3 root root 4096 Sep 29 13:12 .
drwxr-xr-x 5 root root 4096 Sep 29 13:12 ..
drwxr-xr-x 4 mysql mysql 4096 Sep 29 13:15 data
[root@ip-10-136-66-211 infobright]# cd data
[root@ip-10-136-66-211 data]# ls -al
total 32
drwxr-xr-x 4 mysql mysql 4096 Sep 29 13:15 .
drwxr-xr-x 3 root root 4096 Sep 29 13:12 ..
drwxrwx--x 2 mysql mysql 4096 Sep 29 13:15 BH_RSI_Repository
-rw-rw---- 1 mysql root 1038 Sep 29 13:15 bh.err
-rw-r--r-- 1 root root 1920 Sep 29 13:15 brighthouse.ini
-rw-rw---- 1 mysql mysql 1073 Sep 29 13:15 brighthouse.log
-rw-rw---- 1 mysql mysql 1 Sep 29 13:15 brighthouse.seq
drwxr-xr-x 5 mysql mysql 4096 Sep 29 11:07 data
-rw-rw---- 1 mysql mysql 0 Sep 29 13:15 rsi_dir.rsd
[root@ip-10-136-66-211 data]#
Here is the cnf file:
[root@ip-10-136-66-211 etc]# more my-ib.cnf
# Example Infobright config file (mysql server).
# In this file, you can use all long options that mysql supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql-ib.sock
loose-local-infile=1
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
basedir = /usr/local/infobright-4.0.4-x86_64
datadir = /ebs/infobright/data
log-error = /ebs/infobright/data/bh.err
log-output = FILE
#general_log=1
#general_log_file=path-of-datadir/general_query.log
#slow_query_log=1
#slow_query_log_file=path-of-datadir/slow_query.log
port = 3306
socket = /tmp/mysql-ib.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 500M
table_cache = 16
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 8M
net_buffer_length = 8K
thread_cache_size = 32
thread_stack = 512K
query_cache_size = 8M
query_cache_type=0
# Try number of CPU cores*4 for thread_concurrency
thread_concurrency = 8
#core-file
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
server-id=1
# log-bin=mysql-bin
default-storage-engine=brighthouse
collation_server=latin1_bin
character_set_server=latin1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 1M
write_buffer = 1M
[myisamchk]
key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 1M
write_buffer = 1M
[mysqlhotcopy]
interactive-timeout
[mysql-test]
host=local
user=root
port=3306
database=dk
# suite-timeout=60
testcase-timeout=3600
|
|
|
|
|
|
| Posted: 29 September 2011 01:40 PM |
[ Ignore ]
[ # 9 ]
|
|
|
Administrator
Total Posts: 139
Joined 2008-08-18
|
Hi,
Using the postconfig, did you move the data directory /usr/local/infobright-4.0.4-x86_64/data to /ebs/infobright/data? or you relocated to an existing data directory /ebs/infobright/data? i.e. is /ebs/infobright/data an old data directory?
If /usr/local/infobright-4.0.4-x86_64/data exists, can you change the data directory to this and see if you can start the server?
regards,
Kethees.
|
|
|
|
|
|
| Posted: 29 September 2011 01:43 PM |
[ Ignore ]
[ # 10 ]
|
|
|
Newbie
Total Posts: 10
Joined 2009-06-08
|
As requested, still not working:
[root@ip-10-136-66-211 infobright]# ./postconfig.sh
Infobright post configuration
--------------------------------------
Using postconfig you can:
--------------------------------------
(1) Move existing data directory to other location,
(2) Move existing cache directory to other location,
(3) Configure server socket,
(4) Configure server port,
(5) Relocate datadir path to an existing data directory.
Please type 'y' for option that you want or press ctrl+c for exit.
Current configuration:
--------------------------------------
Current config file: [/etc/my-ib.cnf]
Current brighthouse.ini file: [/ebs/infobright/data/brighthouse.ini]
Current datadir: [/ebs/infobright/data]
Current CacheFolder in brighthouse.ini file: [/usr/local/infobright/cache]
Current socket: [/tmp/mysql-ib.sock]
Current port: [3306]
--------------------------------------
(1) Do you want to copy current datadir [/ebs/infobright/data] to a new location? [y/n]:y
Give new datadir path (e.g. /opt/datadirnewpath/data):/usr/local/infobright-4.0.4-x86_64/data
(2) Option to change CacheFolder is disabled when option 1 is chosen!
(3) Do you want to change current socket [/tmp/mysql-ib.sock]? [y/n]:n
(4) Do you want to change current port [3306]? [y/n]:n
(5) Relocation is disabled when options 1-4 are chosen!
--------------------------------------
Datadir(/ebs/infobright/data) is going to be copied to /usr/local/infobright-4.0.4-x86_64/data
--------------------------------------
Please confirm to proceed? [y/n]:y
Copying /ebs/infobright/data to /usr/local/infobright-4.0.4-x86_64/data ...is done.
You can now remove/backup your old /ebs/infobright/data ...
Done!
[root@ip-10-136-66-211 infobright]# ./bin/mysqld_safe &
[1] 7927
[root@ip-10-136-66-211 infobright]# 110930 01:41:22 mysqld_safe Logging to '/usr/local/infobright-4.0.4-x86_64/data/bh.err'.
110930 01:41:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/infobright-4.0.4-x86_64/data
110930 01:41:22 mysqld_safe mysqld from pid file /usr/local/infobright-4.0.4-x86_64/data/ip-10-136-66-211.pid ended
[1]+ Done ./bin/mysqld_safe
[root@ip-10-136-66-211 infobright]# cd data
[root@ip-10-136-66-211 data]# ls
BH_RSI_Repository brighthouse.ini brighthouse.seq rsi_dir.rsd
bh.err brighthouse.log data updater.log
[root@ip-10-136-66-211 data]# more bh.err
110929 13:15:10 mysqld_safe Starting mysqld daemon with databases from /ebs/info
bright/data
/usr/local/infobright-4.0.4-x86_64/bin/mysqld: Table 'mysql.plugin' doesn't exis
t
110929 13:15:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
Loading configuration for Infobright instance ...
Option: AllowMySQLQueryPath, value: 0.
Option: AutoConfigure, value: 0.
Option: CacheFolder, value: /usr/local/infobright/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: 800.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 24000.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110929 13:15:10 [ERROR] Fatal error: Can't open and lock privilege tables: Table
'mysql.host' doesn't exist
110929 13:15:10 mysqld_safe mysqld from pid file /ebs/infobright/data/ip-10-136-
66-211.pid ended
110930 01:41:22 mysqld_safe Starting mysqld daemon with databases from /usr/loca
l/infobright-4.0.4-x86_64/data
/usr/local/infobright/bin/mysqld: Table 'mysql.plugin' doesn't exist
110930 1:41:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
Loading configuration for Infobright instance ...
Option: AllowMySQLQueryPath, value: 0.
Option: AutoConfigure, value: 0.
Option: CacheFolder, value: /usr/local/infobright/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: 800.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 24000.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110930 1:41:22 [ERROR] Fatal error: Can't open and lock privilege tables: Table
'mysql.host' doesn't exist
110930 01:41:22 mysqld_safe mysqld from pid file /usr/local/infobright-4.0.4-x86
_64/data/ip-10-136-66-211.pid ended
[root@ip-10-136-66-211 data]#
|
|
|
|
|
|
| Posted: 29 September 2011 02:02 PM |
[ Ignore ]
[ # 11 ]
|
|
|
Administrator
Total Posts: 139
Joined 2008-08-18
|
Hi,
It’s still not clear to me, whether the data directory /ebs/infobright/data was an old data directory or it was created by 4.0.4 and moved using the postconfig. Anyway, now it would have been overwriiten since you selected option (1) on postconfig, instead of option (5).
The actual problem is that some of the system tables missing. Not sure, why? It might be an installation bug.
Can you uninstall, remove the directory /usr/local/infobright-4.0.4-x86_64 and reinstall. This time start the server before making any changes to the data directory and see if it has the same problem.
regards,
Kethees.
|
|
|
|
|
|
| Posted: 29 September 2011 02:07 PM |
[ Ignore ]
[ # 12 ]
|
|
|
Newbie
Total Posts: 10
Joined 2009-06-08
|
As requested:
[root@ip-10-136-66-211 tmp]# rpm -e infobright-4.0.4-0
Uninstalling infobright 4.0.4-0
Shutting down infobright server...
Uninstaller does not remove data folder. Please remove it manually.
Symlink /usr/local/infobright removed.
Uninstallation of 4.0.4-0 completed.
[root@ip-10-136-66-211 tmp]# rm -rf /usr/local/infobright
[root@ip-10-136-66-211 tmp]# rpm -i infobright-4.0.4-0-x86_64-ice.rpm
Installing infobright 4.0.4-0 (x86_64)
The installer will generate /tmp/ib4.0.4-0-install.log install trace log.
Creating/Updating datadir and cachedir
Creating user mysql and group mysql
Infobright server installed into folder /usr/local/infobright
Installation log file /tmp/ib4.0.4-0-install.log
--------------------------------------
To activate infobright server, please run ./postconfig.sh script from /usr/local/infobright-4.0.4-x86_64.
Example command: cd /usr/local/infobright-4.0.4-x86_64; ./postconfig.sh
[root@ip-10-136-66-211 tmp]# cd /usr
[root@ip-10-136-66-211 usr]# cd local
[root@ip-10-136-66-211 local]# cd infobright-4.0.4-x86_64/
[root@ip-10-136-66-211 infobright-4.0.4-x86_64]# ./postconfig.sh
Infobright post configuration
--------------------------------------
Infobright server activated.
--------------------------------------
Register your copy of ICE and receive a free copy of the User Manual (a $50 value) as well as a copy of the Bloor Research Spotlight Report "What's Cool About Columns" which explains the differences and benefits of a columnar versus row database.
Registration will require opening an HTTP connection to Infobright, do you wish to register now? [Y/N]: y
Do you want to tell us a bit about yourself? We will try to send your information to our server. [Y/N]: n
Register now http://www.infobright.org/Downloads/ICE/.
[root@ip-10-136-66-211 infobright-4.0.4-x86_64]# ./postconfig.sh
Infobright post configuration
--------------------------------------
Using postconfig you can:
--------------------------------------
(1) Move existing data directory to other location,
(2) Move existing cache directory to other location,
(3) Configure server socket,
(4) Configure server port,
(5) Relocate datadir path to an existing data directory.
Please type 'y' for option that you want or press ctrl+c for exit.
Current configuration:
--------------------------------------
Current config file: [/etc/my-ib.cnf]
Current brighthouse.ini file: [/usr/local/infobright-4.0.4-x86_64/data/brighthouse.ini]
Current datadir: [/usr/local/infobright-4.0.4-x86_64/data]
Current CacheFolder in brighthouse.ini file: [/usr/local/infobright/cache]
Current socket: [/tmp/mysql-ib.sock]
Current port: [5029]
--------------------------------------
(1) Do you want to copy current datadir [/usr/local/infobright-4.0.4-x86_64/data] to a new location? [y/n]:n
(2) Do you want to move current CacheFolder [/usr/local/infobright/cache] to a new location? [y/n]:n
(3) Do you want to change current socket [/tmp/mysql-ib.sock]? [y/n]:n
(4) Do you want to change current port [5029]? [y/n]:n
(5) Do you want to relocate to an existing datadir? Current datadir is [/usr/local/infobright-4.0.4-x86_64/data]. [y/n]:n
--------------------------------------
--------------------------------------
No changes has been made.
--------------------------------------
[root@ip-10-136-66-211 infobright-4.0.4-x86_64]# ./bin/mysqld_safe &
[1] 8332
[root@ip-10-136-66-211 infobright-4.0.4-x86_64]# 110930 02:04:47 mysqld_safe Logging to '/usr/local/infobright-4.0.4-x86_64/data/bh.err'.
110930 02:04:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/infobright-4.0.4-x86_64/data
110930 02:04:48 mysqld_safe mysqld from pid file /usr/local/infobright-4.0.4-x86_64/data/ip-10-136-66-211.pid ended
[1]+ Done ./bin/mysqld_safe
[root@ip-10-136-66-211 infobright-4.0.4-x86_64]# cd data
[root@ip-10-136-66-211 data]# more bh.err
110929 13:15:10 mysqld_safe Starting mysqld daemon with databases from /ebs/info
bright/data
/usr/local/infobright-4.0.4-x86_64/bin/mysqld: Table 'mysql.plugin' doesn't exis
t
110929 13:15:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
Loading configuration for Infobright instance ...
Option: AllowMySQLQueryPath, value: 0.
Option: AutoConfigure, value: 0.
Option: CacheFolder, value: /usr/local/infobright/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: 800.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 24000.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110929 13:15:10 [ERROR] Fatal error: Can't open and lock privilege tables: Table
'mysql.host' doesn't exist
110929 13:15:10 mysqld_safe mysqld from pid file /ebs/infobright/data/ip-10-136-
66-211.pid ended
110930 01:41:22 mysqld_safe Starting mysqld daemon with databases from /usr/loca
l/infobright-4.0.4-x86_64/data
/usr/local/infobright/bin/mysqld: Table 'mysql.plugin' doesn't exist
110930 1:41:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
Loading configuration for Infobright instance ...
Option: AllowMySQLQueryPath, value: 0.
Option: AutoConfigure, value: 0.
Option: CacheFolder, value: /usr/local/infobright/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: 800.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 24000.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110930 1:41:22 [ERROR] Fatal error: Can't open and lock privilege tables: Table
'mysql.host' doesn't exist
110930 01:41:22 mysqld_safe mysqld from pid file /usr/local/infobright-4.0.4-x86
_64/data/ip-10-136-66-211.pid ended
110930 02:04:48 mysqld_safe Starting mysqld daemon with databases from /usr/loca
l/infobright-4.0.4-x86_64/data
/usr/local/infobright-4.0.4-x86_64/bin/mysqld: Table 'mysql.plugin' doesn't exis
t
110930 2:04:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
Loading configuration for Infobright instance ...
Option: AllowMySQLQueryPath, value: 0.
Option: AutoConfigure, value: 0.
Option: CacheFolder, value: /usr/local/infobright/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: 800.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 24000.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110930 2:04:48 [ERROR] Fatal error: Can't open and lock privilege tables: Table
'mysql.host' doesn't exist
110930 02:04:48 mysqld_safe mysqld from pid file /usr/local/infobright-4.0.4-x86
_64/data/ip-10-136-66-211.pid ended
[root@ip-10-136-66-211 data]#
|
|
|
|
|
|
| Posted: 29 September 2011 03:28 PM |
[ Ignore ]
[ # 13 ]
|
|
|
Administrator
Total Posts: 139
Joined 2008-08-18
|
Hi,
You may want to try this one more time because the step “rm -rf /usr/local/infobright” wouldn’t have removed the directory/files since /usr/local/infobright is a soft link and would have been removed upon uninstallation.
You have to issue:
cd /usr/local
rm -rf infobright-4.0.4-x86_64
Also, after the install and before moving the data directory, try to start the server and see if it starts.
The other option is that, if you have another instance then you can just copy the system tables (/usr/local/infobright-4.0.4-x86_64/data/mysql/*).
regards,
Kethees.
|
|
|
|
|
|
| Posted: 29 September 2011 03:40 PM |
[ Ignore ]
[ # 14 ]
|
|
|
Newbie
Total Posts: 10
Joined 2009-06-08
|
Finally - that did the trick. It starts successfully now.
However, when I use postconfig.sh to move the directory, then Infobright now fails to start.
We cannot install Infobright on the default directory, there isn’t enough space on that device.
Please advise now on how I can safely move the data directory to another path…
|
|
|
|
|
|
| Posted: 29 September 2011 04:15 PM |
[ Ignore ]
[ # 15 ]
|
|
|
Administrator
Total Posts: 139
Joined 2008-08-18
|
Hi,
I wasn’t able to reproduce the postconfig problem.
To resolve your issue, instead of executing the postconfig:
- you can move the data directory to your new location
- change the ownership to mysql
- edit /etc/my-ib.cnf and update the new path for the parameter datadir (optionally update log-error)
regards,
Kethees.
|
|
|
|
|
