LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
LinkBack Search this Thread
Old 09-30-2009, 02:27 AM   #1
saran_redhat
Member
 
Registered: May 2009
Location: chennai
Posts: 247

Rep: Reputation: 16
zabbix problem


Hai friends

I am successfully installed zabbix server. when i connect database it will only 127.0.0.1 and click testconnection its working. but i am not able to connect my database through my ipaddress. it gives like this error

* mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: Host '192.168.0.241' is not allowed to connect to this MySQL server[/var/www/html/zabbix/include/db.inc.php:56]
* Error connecting to database [Host '192.168.0.241' is not allowed to connect to this MySQL server]


please give some solution and how to activate sms service in zabbix . please give me some details its very useful for me.

Thanks for advance
 
Old 09-30-2009, 02:39 AM   #2
lutusp
Member
 
Registered: Sep 2009
Distribution: Fedora
Posts: 835

Rep: Reputation: 101Reputation: 101
Quote:
Originally Posted by saran_redhat View Post
Hai friends

I am successfully installed zabbix server. when i connect database it will only 127.0.0.1 and click testconnection its working. but i am not able to connect my database through my ipaddress. it gives like this error

* mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: Host '192.168.0.241' is not allowed to connect to this MySQL server[/var/www/html/zabbix/include/db.inc.php:56]
* Error connecting to database [Host '192.168.0.241' is not allowed to connect to this MySQL server]


please give some solution and how to activate sms service in zabbix . please give me some details its very useful for me.

Thanks for advance
You need to authorize MySQL access through all required hostname/IP/username combinations.

Google: Mysql Access Configuration
 
Old 09-30-2009, 02:49 AM   #3
SkyEye
Member
 
Registered: Sep 2005
Location: Sri Lanka
Distribution: Fedora (workstations), CentOS (servers), Arch, Mint, Ubuntu, and a few more.
Posts: 441

Rep: Reputation: 40
Have you created a new DBMS user for Zabbix? Whatever the case, when you grant privileges, you have to specify that the user is allowed to connect from any host.

Eg:
mysql> grant all privileges on zabbix.* to someusr@"%" identified by 'password';

If you use % it means any host.

Other than that your DBMS service should be bound to an IP address. Check your mysqld configuration file to do so.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
zabbix error!! hasan_sust Linux - Newbie 3 04-30-2009 07:12 AM
Zabbix Server M_C Linux - Server 1 01-26-2009 08:48 AM
Zabbix on pfsense sandeepthug Linux - Software 2 12-22-2008 05:53 AM
Zabbix mahmoud Linux - Software 3 03-17-2008 05:37 PM
Zabbix.... any experiences? alek66 Solaris / OpenSolaris 0 02-20-2008 07:24 AM


All times are GMT -5. The time now is 08:03 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration