Welcome, Guest. Please login or register.

Author Topic: nedi.pl script fails @ mysal login but my mysql login works.  (Read 898 times)

jbruyet

  • Newbie
  • *
  • Posts: 13
    • View Profile
nedi.pl script fails @ mysal login but my mysql login works.
« on: October 06, 2017, 07:01:15 PM »
Hey all, when I run the nedi.pl script my mysql login fails:

Code: [Select]
jobee@NeDi:/opt/nedi$ ./nedi.pl -i

Initialize NeDi DB!!!
------------------------------------------------------------------------
mysql admin user: root
mysql admin pass: Pass123
DBI connect('dbname=mysql;host=localhost','root',...) failed: Access denied for user 'root'@'localhost' at ./inc/libdb.pm line 37.
jobee@NeDi:/opt/nedi$

I can log in to mysql using the same credentials, create a new user, grant that user all privileges and flush privileges. But even using THAT user for the nedi.pl script fails although the error is a little different:

Code: [Select]
Initialize NeDi DB!!!
------------------------------------------------------------------------
mysql admin user: jobee
mysql admin pass:
DB Version      : 10.0.31-MariaDB-0ubuntu0.16.04.2
----------------------------------------------------------------------
Old DB 'nedi' dropped!
Creating 'nedi' for nedi@localhost:
DBD::mysql::db do failed: Access denied for user 'jobee'@'localhost' to database 'nedi' at ./inc/libdb.pm line 135, <STDIN> line 2.
DBD::mysql::db do failed: Access denied for user 'jobee'@'localhost' to database 'nedi' at ./inc/libdb.pm line 135, <STDIN> line 2.
jobee@NeDi:/opt/nedi$ ./nedi.pl -i

Any ideas, suggestions or recommendations on what is going on here? I've wiped and reinstalled three times now thinking maybe I missed a step somewhere but not that I can tell. I'm using the instructions on this page https://help.ubuntu.com/community/NediHowTo. Is there a step missing here that will fix my problem?

Thanks,

Joe B


« Last Edit: October 06, 2017, 07:09:43 PM by jbruyet »

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2542
    • View Profile
    • NeDi
Re: nedi.pl script fails @ mysal login but my mysql login works.
« Reply #1 on: October 06, 2017, 07:49:14 PM »
More recent Debian/Ubuntu systems changed how root access behaves. Try initialize as root. I bet you won't even need DB password then...

Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

jbruyet

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: nedi.pl script fails @ mysal login but my mysql login works.
« Reply #2 on: October 06, 2017, 08:48:20 PM »
I tried that too. No joy:

Code: [Select]
jobee@NeDi:/opt/nedi$ ./nedi.pl -i

Initialize NeDi DB!!!
------------------------------------------------------------------------
mysql admin user: root
mysql admin pass:
DBI connect('dbname=mysql;host=localhost','root',...) failed: Access denied for user 'root'@'localhost' at ./inc/libdb.pm line 37.
jobee@NeDi:/opt/nedi$

This is Ubuntu 16.04.3 LTS. Should I try it with a different version of Ubuntu? Or a different distribution?

Thanks,

Joe B

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2542
    • View Profile
    • NeDi
Re: nedi.pl script fails @ mysal login but my mysql login works.
« Reply #3 on: October 07, 2017, 10:22:07 PM »
I meant become root first (sudo) and then try again. Should work, even without DB password...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

jbruyet

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: nedi.pl script fails @ mysal login but my mysql login works.
« Reply #4 on: October 09, 2017, 04:23:55 PM »
OOOOHHHHHHH!!!!!!

Yep, it just initialized without any errors. Thanks for you help and your patience!

Thanks,

Joe B