next »

[cmesser]

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]

No changes in the users table, but minor adjustments in stock (added source varchar(32) ) and monitoring (added delay smallint(5) unsigned ) though...

[MLloyd]

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]

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

[rufer]

Probably a permission problem. You should change your root db password if it's the one you posted.

Greetings
Rufer

[aurelien-93]

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]

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:

#===================================================================
# 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