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....

An infographic is a good way to explain something in a very visual way. As many of you know, we do a number of things to help people make sense of the crazy database world. Here is an infographic on Big Data that helps explain row vs column vs NoSQL. Be sure to click the right arrows to see more info. Take a look!

if you have been following Infobright for any period of time, you know that we are big proponents of using the right database for the right use case. That's why we spend time and effort helping educate our prospects and community members about different technologies and which use cases they are best suited for. Recently Jeff Kibler, our SE extraordinaire and former community manager, downloaded and tested MongoDB and has written a new white paper about using MongoDB with Infobright. You can download it from our white paper page: http://support.infobright.com/Support/Resource-Library/Whitepapers/ (scroll down a bit to the Infobright Technical White Papers and you'll see it).

If you haven't already read the white paper "The Emerging Database Landscape" which discusses row, columnar, and NoSQL databases you can download it here: http://www.infobright.com/land/emerging_database_landscape/