Print Page - Not able to connect Database

Title: Not able to connect Database
Post by: [email protected] on December 08, 2009, 02:55:46 PM

Hi,
Iam getting the below error when iam restarting the nxdbr

[root@localhost ~]# /usr/local/bin/nxdbmgr init /usr/local/share/netxms/sql/dbinit_mysql.sql
NetXMS Database Manager Version 0.2.31

Configuration file OK
Unable to connect to database netxms@localhost as netxms

and this is my netxmsd.conf

[root@localhost ~]# cat /etc/netxmsd.conf
#
# Sample configuration file for NetXMS server
#

#
# DBDriver
#
# Database driver to use
#
# UNIX example:
DBDriver = /usr/local/lib/libnxddr_mysql.so
#
# Windows example:
# DBDriver = mysql.ddr

#
# DBServer
#
# Database server (ODBC source name for ODBC driver)
#
# Example:
DBServer = localhost

#
# DBName
#
# Database name (not used by ODBC driver)
#
# Example:
DBName = netxms

#
# DBLogin
#
# Database user name
#
# Example:
DBLogin = netxms

#
# DBPassword
#
# Database user's password
#
# Example:
DBPassword = trx123

#
# LogFailedSQLQueries
#
# Controls logging of failed SQL queries.
# Possible values: "yes" (default) or "no".
#
# Example:
LogFailedSQLQueries = yes

#
# LogFile
#
# Server's log file. To write log to syslog (or Event Log on Windows),
# use {syslog} as file name.
#
# Examples:
LogFile = {syslog}
LogFile = /var/log/netxms

Can Some one please help me how to fix this

Thanks
Subbu

Title: Re: Not able to connect Database
Post by: Victor Kirhenshtein on December 09, 2009, 12:37:41 PM

Hi!

Try to connect to database with MySQL command line client:

mysql -h localhost -u netxms -p netxms

and check error messages.

Best regards,
Victor

Title: Re: Not able to connect Database
Post by: [email protected] on January 06, 2010, 05:51:21 PM

Hi ,
I followed the Procedure instructe below Iam getting the below error , Please help me

root@localhost ~]# mysql -h localhost -u netxms -p netxms

Enter password:
ERROR 1045 (28000): Access denied for user 'netxms'@'localhost' (using password: YES)
[root@localhost ~]# mysql -h localhost -u netxms -p netxms
Enter password:
ERROR 1045 (28000): Access denied for user 'netxms'@'localhost' (using password: YES)
[root@localhost ~]#

Thanks in Advance

Subbu
[/quote]

Title: Re: Not able to connect Database
Post by: Victor Kirhenshtein on January 07, 2010, 01:13:08 PM

Your database user netxms does not have access rights to database netxms. Try to grant required rights with the following MySQL query:

Code Select


GRANT ALL ON netxms.* to netxms@localhost;

Best regards,
Victor

Title: Re: Not able to connect Database
Post by: [email protected] on January 10, 2010, 12:19:03 PM

Thanks for the quick response..Its working now

Thanks
Subbu

NetXMS Support Forum

English Support => General Support => Topic started by: [email protected] on December 08, 2009, 02:55:46 PM