Infobright Blog

It has been a little while since I have had the time to sit and write again and I can admit that I quite miss it. From a community standpoint, myself and the intern team have been really busy with getting the new websites in place. We also have alot plans for some really awesome projects being planned with some other open source companies like Akiban, as well as some Social Media contests. Recently though, I have been handling a fair amount of requests dealing with common issues, ranging from simple connections to permission issues. As a general rule, approaching these issues, there is a common few steps that are taken to help eliminate where the issue lies.

On Unix/Linux:

1. From prompt type 'sudo su'
2. Enter your password if prompted
3. type /etc/init.d/mysqld-ib start
4. If a process is already running, it will let you know
5. type mysql-ib -u{username}
6. Once the mysql prompt is up, start at Step 4 below.

On windows:

1. Open a command prompt by right clicking and use 'Run as Administrator'
2. type 'sc start infobright' (no apostrophes) to determine if infobright is running. If Infobright is running, you will get an error indicating that.
3. In explorer, navigate to the Infobright installation and double click Infobright-client.bat , which may also be in your Start >> Programs >> Infobright
4. At the mysql prompt type "SHOW GRANTS FOR CURRENT_USER;"
   
   mysql> show grants for current_user;
   +---------------------------------------------------------------------+
   | Grants for root@localhost |
   +---------------------------------------------------------------------+
   | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
   +---------------------------------------------------------------------+
   1 row in set (0.00 sec)
   
   mysql>
5. IF your user can ONLY access the Infobright instance from certain locations (i.e. localhost, 127.0.0.1 ), it will show that here.
    
   mysql> show grants for current_user;
   +---------------------------------------------------------------------+
   | Grants for root@localhost |
   +---------------------------------------------------------------------+
   | GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION |
   +---------------------------------------------------------------------+
   1 row in set (0.00 sec)
   
   mysql>
6. IF it shows a percentage sign, then your permissions are for any location to the instance. Notice the difference in localhost and %
7. to add remote access type :
   mysql> GRANT ALL ON *.* TO 'root'@'%';
8. Now if you are unable to get in, there must be a firewall on this machine blocking the requests in.

This is a very common issue because a default installation of Infobright only allows the root user access to the instance from the machine itself. Granting the remote access is very common usage, though not suggested for the root user becuase it is not good practice to allow root access except from the machine itself, as a security protocol. Stay tuned next week for some more exciting news concerning the Infobright Community....