Joinutility seperatorLogin utility separator Infobright.com
Loading
Home  > Infobright Blog

Infobright Blog

08
Nov

Common steps for debugging connection issue

craigtrombly's photo
by craigtrombly     Thu, Nov 08, 2012

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

Infobright   Comments (48)

Infobright     Tags:

I haven’t gotten these issues with my website about custom essay writing services   . But I will save these steps for future usage in case it occurs.

Author: tinalovely101
Date: 05/25/13

Your guide is very simple. I think everyone will apply it. african mango diet

Author: hotmit
Date: 05/25/13

Your post is very useful. I will apply it when I need debug connection issue. hcg diet

Author: hotmit
Date: 05/25/13

cerrajero en ibiza 24 horas Nuestros cerrajeros en ibiza 24 Horas dan servicio a Ibiza, San José, Santa Eularia, San Juan, San Antonio, Santa Gertrudis, San Jordi, Las Salinas, San Agustín, San Rafael, Santa Inés, San Mateo, San Miguel, San Carlos y San Lorenzo.

Author: tinalovely101
Date: 05/24/13

servicio tecnico lg valencia is the same ways for business and other ways also.

Author: tinalovely101
Date: 05/24/13

I must debug connection issue for my web about green coffee bean extract

Author: hotmit
Date: 05/24/13

Thanks for sharing this with us. Very useful and easy to do this. antler velvet

Author: hotmit
Date: 05/24/13

Your instructions are very specific and precise. I think people will perform saffron extract benefits

Author: hotmit
Date: 05/24/13

best stand mixer can give the best ideas for the debugging and things like this.

Author: tinalovely101
Date: 05/23/13

Thanks for sharing this tips. I will apply this steps for acheter des kamas par audiotel

Author: hotmit
Date: 05/23/13

istanbul airport taxi will have all things for the updated database.

Author: tinalovely101
Date: 05/23/13

I’m so enjoyable when reading your post. Thank you for sharing.  pull ralph lauren pas cher

Author: hotmit
Date: 05/23/13

I’m always interested in open source development, my job pretty much related to it, thanks for useful article.  Ralph lauren pas cher

Author: hotmit
Date: 05/23/13

I will apply this steps if my wireless surround sound system have connectivity fault.

Author: hotmit
Date: 05/23/13

I was surprised with the amount of high quality information contained in this post. You’ve done a great job providing solid value and keeping the readers engaged at the same time.
ad agency melbourne fl

Author: tightlineprod
Date: 05/21/13

I am very interested in open source development in the field of web design and other applications, thanks for your interesting article. credit repair companies

Author: hotmit
Date: 05/20/13

I am very interested in the development of the open source, it makes my job programming interface developed and made ​​more user friendly.game of thrones mega

Author: hotmit
Date: 05/20/13

I will apply common steps for debugging connection issue for testosterone cypionate

Author: hotmit233
Date: 05/20/13

Thanks for sharing common steps for debugging connection issue with compression shorts

Author: hotmit233
Date: 05/20/13

green coffee weight loss Dr Oz can be done with the connection and the debugging.

Author: tinalovely101
Date: 05/20/13

I will try your tips later because I’m busy preparing manchester wedding cars

Author: hotmit233
Date: 05/17/13

download root explorer apk will have the same solutions with how to debug every error.

Author: tinalovely101
Date: 05/17/13

I was successful in applying your advice for affordable life insurance for seniors. Thanks.

Author: hotmit233
Date: 05/17/13

I have followed the steps you guide but my waterproof tv still error

Author: hotmit233
Date: 05/17/13

Thanks for sharing this tips. I will aplly it for Minecraft PC Download

Author: hotmit233
Date: 05/17/13

I will apply common steps for debugging connection issue for Get Backlinks

Author: hotmit233
Date: 05/16/13

and bunches of uppercase letters, and see a lot of good information, greatly expanded by the left of right arrows.custom jerseys

Author: dailaolaa
Date: 05/16/13

It gives the same ways for how to solve the bugs in db for patchwork fabrics

Author: tinalovely101
Date: 05/16/13

I think I will test these things for my websites since bugs can happen on websites.
free ceus for social workers
psychologist continuing education
social worker ceu online

Author: tinalovely101
Date: 05/15/13

It is good to apply for the ways to solve the debugging on ballroom dancing toronto

Author: tinalovely101
Date: 05/15/13

You should also prepare for a large storage. So you can keep the whole data in there. Ayo Ikutan Kontes Humor JOKES.WEB.ID | Saatnya Total Action

Author: andylisa
Date: 05/13/13

I will use the database for my website since it is good for management.
best baby swing to buy

Author: tinalovely101
Date: 05/13/13

Great tutorials as always by administrator. Keep up the good work
GFA Solutions

Author: bokislo1
Date: 05/10/13

Your content is very useful. Thank you so much for providing plenty of useful content… payment gateway

Author: charadam150
Date: 05/08/13

How can I get this coding for my websites since I have some problems with it, and it is about http://www.unitedfinances.com

Author: tinalovely101
Date: 05/08/13

Thank you for sharing the tutorial. This is quite unique and i have personally executed the commands and they have worked well.
Essay help from professional writers.

Author: Careson Brown
Date: 04/02/13

Careful information about the Rowebeck design. I love very much this design that I’ve used more then 2 years. I am pleased to know about your FlipFlyBlue online shop. Thanks and build-up more smile brazilian hair\hair weave

Author: bocaishuaige
Date: 03/20/13

Even if you’re a kind of a dummy in design and nothing helps, find some cheap writing service to work out.

Author: EMichael
Date: 03/18/13

Two words: good design.  Simple and clean design and with a good attention to details, flash photos on the front of homepage make the whole page active.
http://www.dreamqualitywatch.com

Author: keneddy
Date: 03/08/13

Very detailed and straight to the point. I addressed and fix exactly what I needed to, so thanks for putting this out here. air conditioning melbourne fl

Author: tightlineprod
Date: 02/17/13

Hi,This is a good post, indeed a great job…Design

Author: Design
Date: 01/15/13

nice post to read.
THE NEXT GENERATION

Author: ashutoshkushwaha
Date: 01/15/13

123

Author: vannirobben123
Date: 01/10/13

This looks to be a very helpful blog entry.

Is it a typo that caused my user name to appear on the first line 5 after “type mysql-ib -u”?

Author: Alan Musnikow
Date: 11/17/12
Please login or register to post a comment.