Welcome, Guest. Please login or register.

Author Topic: Upgrading to 1oh5  (Read 5134 times)

cmesser

  • Jr. Member
  • **
  • Posts: 80
    • View Profile
Upgrading to 1oh5
« on: January 11, 2010, 11:59:28 AM »
Now, after 1oh5 final is out, I wonder if there are some database changes.
Or can I update just by copying the new version into the existing directory?
Especially I want to keep the users.

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2777
    • View Profile
    • NeDi
Re: Upgrading to 1oh5
« Reply #1 on: January 12, 2010, 12:16:42 AM »
No changes in the users table, but minor adjustments in stock (added source varchar(32) ) and monitoring (added delay smallint(5) unsigned ) though...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

MLloyd

  • Guest
Re: Upgrading to 1oh5
« Reply #2 on: January 12, 2010, 10:18:22 AM »
Hi,

Does this mean if we manually add the source and delay fields to the relevant tables in the nedi database, we could just do a copy of the new version(1oh5) into the existing directory(1oh4).  Assuming that any configuration file settings are saved before hand and reapplied to the config files for the 1oh5?

Is it as straight forward as that?

Regards,
Michael

aurelien-93

  • Newbie
  • *
  • Posts: 48
    • View Profile
Re: Upgrading to 1oh5
« Reply #3 on: January 21, 2010, 03:21:54 PM »
when i execut ./nedi.pl -i, i have this message


DB, RRDs and configs files will be cleared, bail out if don't want this!
--------------------------------------------------------------------------
MySQL admin user: root
MySQL admin pass: *****
MySQL Version   : 5.0.51a-3ubuntu5.4
----------------------------------------------------------------------
DBD::mysql::db do failed: Error dropping database (can't rmdir './nedi', errno: 39) at ./inc/libdb-msq.pl line 30, <STDIN> line 2.
DBD::mysql::db do failed: Error dropping database (can't rmdir './nedi', errno: 39) at ./inc/libdb-msq.pl line 30, <STDIN> line 2.

have you an idea ???

thanks
« Last Edit: January 21, 2010, 04:38:35 PM by aurelien-93 »

rufer

  • Guest
Re: Upgrading to 1oh5
« Reply #4 on: January 21, 2010, 03:27:53 PM »
Probably a permission problem. You should change your root db password if it's the one you posted.

Greetings
Rufer

aurelien-93

  • Newbie
  • *
  • Posts: 48
    • View Profile
Re: Upgrading to 1oh5
« Reply #5 on: January 21, 2010, 04:53:19 PM »
I changed the password and I have the same problem when I run nedi.pl-i.
more after this command and the error message that I destroyed all the tables in the database.

oxo

  • Guest
Re: Upgrading to 1oh5
« Reply #6 on: January 22, 2010, 03:50:24 PM »
The code seems to indicate that if you can see "MySQL Version    :" (which your post shows that you could), then admin (root) user and pass are ok ...

Code: [Select]
#===================================================================
# Connect as admin, drop existing DB and create nedi db and user first
# Parameters:   $adminuser,$adminpass,$nedihost
# Global:       -
# Return:       -
#===================================================================
sub InitDB{

        $dbh = DBI->connect("DBI:mysql:mysql:$misc::dbhost", "$_[0]", "$_[1]", { RaiseError => 1, AutoCommit => 1});
        my $mysqlVer;
        my $sth = $dbh->prepare("SELECT VERSION()");
        $sth->execute();
        while ((my @f) = $sth->fetchrow) {
                $mysqlVer = $f[0];
        }
        print "MySQL Version    : $mysqlVer\n";
        print "----------------------------------------------------------------------\n";

However, it is certainly "something" to do with mysql, the mysql process was not allowed to remove the nedi db that exists in the file system: something rotten in the mysql installation ???
Google can't rmdir './nedi', errno: 39

Edit:
From the cmd line of your mysql server, you can try:
mysqladmin -u root -p drop nedi

Then do nedi init twice to see if you get errors

« Last Edit: January 23, 2010, 07:58:07 AM by oxo »