Welcome, Guest. Please login or register.

Author Topic: Nedi under RHEL 4 installation failure  (Read 11398 times)

sword2100

  • Guest
Nedi under RHEL 4 installation failure
« on: February 23, 2009, 01:50:10 PM »
Hi,

i would like to install nedi on my RHEL 4.
I've just installed all needed modules.

I try to install nedi with "./nedi.pl -i" these error displays

Code: [Select]
Old DB nedi dropped!
Creating nedi for nedi@localhost
Transactions not supported by database at /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/DBI.pm line 690, <STDIN> line 2.

I didn't find out what's the real problem now is.

Thanks
Paul

rufer

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #1 on: February 24, 2009, 09:12:27 AM »
I have Nedi running on RHEL 4 (using MySQL backend). Not all Perl modules are in the Redhat repositories (install with up2date), so you have to install them manually using PPM. --> Please verify that you have all needed modules/dependencies installed.

Greetings
Rufer

PS: Installation notes from Nedi 1.0.RC2. Note that the database is on another host in my case. If you need it local, you also need mysql-server

#Nedi RC2 Install
#Redhat Enterprise Linux 4

#unzip to /opt/nedi

#nedi backend
up2date -i net-snmp-perl
up2date -i perl-DBI
up2date -i perl-DBD-MySQL
perl -MCPAN -e shell
 install Net::Telnet::Cisco

#rrd
up2date -i freetype-devel
up2date -i libpng-devel
up2date -i libart_lgpl-devel
up2date -i tcl-devel
#download rrd source, unzip
./configure
make
make install
ln -s /usr/local/rrdtool-1.2.15/bin/rrdcgi /usr/bin/rrdcgi
ln -s /usr/local/rrdtool-1.2.15/bin/rrdtool /usr/bin/rrdtool
ln -s /usr/local/rrdtool-1.2.15/bin/rrdupdate /usr/bin/rrdupdate


#nedi frontend
up2date -i php-gd php-snmp
ln -s /opt/nedi/nedi.conf /etc/nedi.conf
#configure apache as needed (commands not listed here)
chkconfig httpd on

#create non privileged user, change rights and run nedi with that user (commands not listed here)
#change permissions for html files, such that Apache can read them
cd /opt/nedi/html
chown -R apache log
chgrp -R apache log
« Last Edit: February 24, 2009, 09:21:47 AM by rufer »

sword2100

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #2 on: February 24, 2009, 09:20:32 AM »
Hi,

ok i will check it again.
I installed all modules with cpan and cpan shows me that all modules are installed.

gumba

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #3 on: February 24, 2009, 10:42:50 AM »
This rather looks like some database issue. Is the mysql user 'nedi' allowed to create databases on your host?

sword2100

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #4 on: February 24, 2009, 11:01:49 AM »
cpan tells me that all needed modules are installed

Code: [Select]
cpan[1]> m Net::SNMP
CPAN: Storable loaded ok (v2.13)
Going to read /root/.cpan/Metadata
  Database was generated on Tue, 24 Feb 2009 00:26:52 GMT
Module id = Net::SNMP
    DESCRIPTION  Object oriented interface to SNMP
    CPAN_USERID  DTOWN (David M. Town <dtown@cpan.org>)
    CPAN_VERSION v5.2.0
    CPAN_FILE    D/DT/DTOWN/Net-SNMP-5.2.0.tar.gz
    UPLOAD_DATE  2005-10-20
    DSLIP_STATUS MdpOp (mature,developer,perl,object-oriented,Standard-Perl)
    MANPAGE      Net::SNMP - Object oriented interface to SNMP
    INST_FILE    /usr/lib/perl5/site_perl/5.8.5/Net/SNMP.pm
    INST_VERSION v5.2.0


                                                                                                                                                                                                               cpan[2]> m Net::Telnet::Cisco
Module id = Net::Telnet::Cisco
    DESCRIPTION  Automate telnet sessions w/ routers&switches
    CPAN_USERID  JOSHUA (Joshua Keroes <joshua@cpan.org>)
    CPAN_VERSION 1.10
    CPAN_FILE    J/JO/JOSHUA/Net-Telnet-Cisco-1.10.tar.gz
    UPLOAD_DATE  2002-06-18
    DSLIP_STATUS RmpOp (released,mailing-list,perl,object-oriented,Standard-Perl)
    MANPAGE      Net::Telnet::Cisco - interact with a Cisco router
    INST_FILE    /usr/lib/perl5/site_perl/5.8.5/Net/Telnet/Cisco.pm
    INST_VERSION 1.10


                                                                                                                                                                                                               cpan[3]> m Algorithm::Diff
Module id = Algorithm::Diff
    DESCRIPTION  Diff (also Longest Common Subsequence)
    CPAN_USERID  ANDREWC (Andrew Chadwick <and-x-rewc@pi-y-ffle.org.z>)
    CPAN_VERSION 1.1902
    CPAN_FILE    T/TY/TYEMQ/Algorithm-Diff-1.1902.tar.gz
    UPLOAD_DATE  2006-07-31
    DSLIP_STATUS Rdpfp (released,developer,perl,functions,Standard-Perl)
    MANPAGE      Algorithm::Diff - Compute `intelligent' differences between two files / lists
    INST_FILE    /usr/lib/perl5/site_perl/5.8.5/Algorithm/Diff.pm
    INST_VERSION 1.1902


                                                                                                                                                                                                               cpan[4]> m DBI
Module id = DBI
    DESCRIPTION  Generic Database Interface (see DBD modules)
    CPAN_USERID  TIMB (Tim Bunce <Tim.Bunce@pobox.com>)
    CPAN_VERSION 1.607
    CPAN_FILE    T/TI/TIMB/DBI-1.607.tar.gz
    UPLOAD_DATE  2008-07-22
    DSLIP_STATUS MmcOp (mature,mailing-list,C,object-oriented,Standard-Perl)
    MANPAGE      DBI - Database independent interface for Perl
    INST_FILE    /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/DBI.pm
    INST_VERSION 1.607


                                                                                                                                                                                                               cpan[5]> m DBD::mysql
CPAN: LWP::UserAgent loaded ok (v5.823)
CPAN: Time::HiRes loaded ok (v1.86)
CPAN: YAML loaded ok (v0.68)
Fetching with LWP:
  ftp://ftp.fu-berlin.de/unix/languages/perl/authors/id/C/CA/CAPTTOFU/CHECKSUMS
Module id = DBD::mysql
    DESCRIPTION  MySQL driver for DBI
    CPAN_USERID  CAPTTOFU (Patrick Galbraith <patg@patg.net>)
    CPAN_VERSION 4.010
    CPAN_FILE    C/CA/CAPTTOFU/DBD-mysql-4.010.tar.gz
    UPLOAD_DATE  2008-10-24
    DSLIP_STATUS RmcO? (released,mailing-list,C,object-oriented,)
    MANPAGE      DBD::mysql - MySQL driver for the Perl5 Database Interface (DBI)
    INST_FILE    /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/DBD/mysql.pm
    INST_VERSION 3.0002


                                                                                                                                                                                                               cpan[6]> m LWP
Fetching with LWP:
  ftp://ftp.fu-berlin.de/unix/languages/perl/authors/id/G/GA/GAAS/CHECKSUMS
Module id = LWP
    DESCRIPTION  Libwww-perl
    CPAN_USERID  LWWWP (The libwww-perl mailing list <libwww@perl.org>)
    CPAN_VERSION 5.825
    CPAN_FILE    G/GA/GAAS/libwww-perl-5.825.tar.gz
    UPLOAD_DATE  2009-02-16
    DSLIP_STATUS RmpO? (released,mailing-list,perl,object-oriented,)
    MANPAGE      LWP - The World-Wide Web library for Perl
    INST_FILE    /usr/lib/perl5/site_perl/5.8.5/LWP.pm
    INST_VERSION 5.823


                                                                                                                                                                                                               cpan[7]> m Net::SSH::Perl
Fetching with LWP:
  ftp://ftp.fu-berlin.de/unix/languages/perl/authors/id/T/TU/TURNSTEP/CHECKSUMS
Module id = Net::SSH::Perl
    DESCRIPTION  Perl client Interface to SSH
    CPAN_USERID  DBROBINS (David Robins <dbrobins@cpan.org>)
    CPAN_VERSION 1.34
    CPAN_FILE    T/TU/TURNSTEP/Net-SSH-Perl-1.34.tar.gz
    UPLOAD_DATE  2009-02-02
    DSLIP_STATUS bdpOp (beta,developer,perl,object-oriented,Standard-Perl)
    MANPAGE      Net::SSH::Perl - Perl client Interface to SSH
    INST_FILE    /usr/lib/perl5/site_perl/5.8.5/Net/SSH/Perl.pm
    INST_VERSION 1.34


I try it to install with root rights, with root right it have to work or not  ???

Code: [Select]
./nedi.pl -i

MySQL DB will be dropped and re-initialized, bail out if don't want this!
-------------------------------------------------------------------------
MySQL admin user: root
MySQL admin pass: password
MySQL Version   : 4.1.22
----------------------------------------------------------------------
Old DB nedi dropped!
Creating nedi for nedi@localhost
Transactions not supported by database at /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/DBI.pm line 690, <STDIN> line 2.

The script create the database nedi and the needed user, but thats all

gumba

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #5 on: February 24, 2009, 11:16:50 AM »
Can you log into mysql with the nedi user created by the install script? If so, do you see the nedi database then?

sword2100

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #6 on: February 24, 2009, 12:30:38 PM »
nedi user have the rights

Code: [Select]

mysql -u nedi -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1044 to server version: 4.1.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use nedi;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql>
mysql> show databases;

+----------+
| Database |
+----------+
| .....  |
| mysql    |
| .....|
| nedi     |
| .....|
+----------+
5 rows in set (0.00 sec)

mysql>



gumba

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #7 on: February 24, 2009, 12:58:57 PM »
Could you maybe post the output of
Code: [Select]
select * from mysql.db where user = 'nedi';

sword2100

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #8 on: February 24, 2009, 01:07:17 PM »
   
I despair slowly, so I configure full rights for user nedi

Code: [Select]
mysql> select * from mysql.db where user = 'nedi';
+-----------+------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
| Host      | Db   | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv |
+-----------+------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
| localhost | nedi | nedi | Y           | Y           | Y           | Y           | Y           | Y         | Y          | Y               | Y          | Y          | Y                     | Y                |
+-----------+------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
1 row in set (0.00 sec)

rufer

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #9 on: February 24, 2009, 01:21:30 PM »
OK, you seem to be on the right trace.
As far as I remember, I created the database user and granted him all rights on the nedi database.

mysql> show databases;
--------------
show databases
--------------

+--------------------+
| Database           |
+--------------------+
| information_schema |
| nedi               |
+--------------------+
2 rows in set (0.00 sec)


I see you use a very old MySQL, not sure if that will cause problems. I use 5.0.x

Greetings
Rufer

gumba

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #10 on: February 24, 2009, 01:35:37 PM »
I see you use a very old MySQL, not sure if that will cause problems. I use 5.0.x

Good point... if possible I would suggest upgrading to MySQL 5.

sword2100

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #11 on: February 27, 2009, 08:22:02 PM »
The update to MySQL 5 is not so easy to my current system.

Nevertheless thank you all for your help.

 :)

rufer

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #12 on: March 02, 2009, 08:22:03 AM »
For a test, you could just put the database on another host?

Greetings
Rufer

sword2100

  • Guest
Re: Nedi under RHEL 4 installation failure
« Reply #13 on: March 02, 2009, 08:28:38 AM »
Good morning,

yesterday i've installed an test system.
With MySQL 5 it seems to work.

So when i want to use nedi i have to upgrade to MySQL 5