Welcome, Guest. Please login or register.

Author Topic: Database error when initializing Nedi 1.0.9 on MySQL 5.5.38  (Read 4516 times)

tristanbob

  • Full Member
  • ***
  • Posts: 159
    • View Profile
Database error when initializing Nedi 1.0.9 on MySQL 5.5.38
« on: December 20, 2014, 01:30:44 AM »
Code: [Select]
tristanrhodes@nedi:/opt/nedi$ sudo ./nedi.pl -i

Initialize NeDi DB!!!
------------------------------------------------------------------------
mysql admin user: root
mysql admin pass: NotMyRealPassword
NeDi host (where the discovery runs on: mysql.mgmt.domain.com
DB Version      : 5.5.38-0ubuntu0.12.04.1-log
----------------------------------------------------------------------
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-109' at line 1 at ./inc/libdb.pm line 132, <STDIN> line 3.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-109' at line 1 at ./inc/libdb.pm line 132, <STDIN> line 3.
tristanrhodes@nedi:/opt/nedi$ sudo ./nedi.pl
DBI connect('dbname=nedi-109;host=mysql.mgmt.domain.com','nedi',...) failed: Access denied for user 'nedi'@'nedi.domain.com' to database 'nedi-109' at ./inc/libdb.pm line 46

Here are my relavent settings:

Code: [Select]
# Choose backend (mysql or Pg)
backend         mysql

# DB params
dbname          nedi-109
dbuser          nedi
dbpass          DatabaseUserPassword
dbhost          mysql.mgmt.domain.com
Please visit "Other"->"Invoices" on your NeDi installation to make an annual contribution and support Nedi!

tristanbob

  • Full Member
  • ***
  • Posts: 159
    • View Profile
Re: Database error when initializing Nedi 1.0.9 on MySQL 5.5.38
« Reply #1 on: January 13, 2015, 12:12:57 AM »
I believe there is some step in the initialization process that is hard-coded for a database called "nedi".

Has anyone successfully used a database with a different name in nedi.conf?

Tristan
Please visit "Other"->"Invoices" on your NeDi installation to make an annual contribution and support Nedi!

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2780
    • View Profile
    • NeDi
Re: Database error when initializing Nedi 1.0.9 on MySQL 5.5.38
« Reply #2 on: January 13, 2015, 03:52:38 PM »
Are you sure about that?

n14t:/var/nedi#ne -i root dbpa55

Initialize NeDi DB!!!
------------------------------------------------------------------------
DB Version      : 5.1.73
----------------------------------------------------------------------
Old DB 'neditest' dropped!
Creating 'neditest' for nedi@localhost:


Maybe it's picking up another config?
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

tristanbob

  • Full Member
  • ***
  • Posts: 159
    • View Profile
Re: Database error when initializing Nedi 1.0.9 on MySQL 5.5.38
« Reply #3 on: January 13, 2015, 07:41:45 PM »
I am not sure what I was running into.  Since you tested and it worked, you can consider this "unreproducible".  We are installed and running with a database called "nedi".

Thanks for testing it for me!

Tristan
Please visit "Other"->"Invoices" on your NeDi installation to make an annual contribution and support Nedi!

harry

  • Full Member
  • ***
  • Posts: 131
    • View Profile
Re: Database error when initializing Nedi 1.0.9 on MySQL 5.5.38
« Reply #4 on: January 19, 2015, 11:37:33 PM »
Hi
Try  "root" as user  and Password as "nediroot", let me know it this works? it worked for me. I have three server instance going on for my network. waiting for the new version. but as per Remo's last post I have to wait little more. ;) :P

I Love NeDi.

Cheers.