To determine cause of trouble, I've reinstalled mysql-server and opsview first, restarted them, but it hasn't help. I've reinstalled perl and it's dbi library packages after that.

 17.07.09, 13:21, "Ton Voon" <[email protected]>:
Thanks for the info.
Your email below says:
ii  mysql-server-5.0             5.0.51a-3ubuntu5.4           MySQL database server binaries
Your original email says:
appserv:~$ sudo /etc/init.d/mysql status
* /usr/bin/mysqladmin  Ver 8.41 Distrib 5.0.51a, for debian-linux-gnu on x86_64
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.0.51a-3ubuntu5.1-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 4 min 58 sec
Note the different server version.
When we build packages for a distribution, we build to the latest stable OS packages. My guess is that Opsview was using our custom built version of DBI (well, DBD::mysql really) which was built against 5.0.51a-3ubuntu5.4 while you only had 5.0.51a-3ubuntu5.1 installed. I don't know the differences between these mysql versions, but I'm guessing there's some connectivity difference and that is the root cause.
Maybe Nick can confirm on his system.
We'll have a think about what we can do about this. 
Ton

On 17 Jul 2009, at 10:07, Spoofov Spoof wrote:

It is ubuntu-8.04.1-server-amd64

# uname -r -m
2.6.24-19-server x86_64

# cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=8.04
DISTRIB_CODENAME=hardy
DISTRIB_DESCRIPTION="Ubuntu 8.04.1"

# dpkg -l libdbi-perl
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-f/Unpacked/Failed-cfg/Half-inst/t-aWait/T-pend
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name                         Version                      Description
+++-============================-============================-========================================================================
ii  libdbi-perl                  1.601-1                      Perl5 database interface by Tim Bunce

# dpkg -l opsview\*
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-f/Unpacked/Failed-cfg/Half-inst/t-aWait/T-pend
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name                         Version                      Description
+++-============================-============================-========================================================================
ii  opsview                      3.1.0.2553-1hardy1           Opsview Metapackage
ii  opsview-base                 3.1.0.2553-1hardy1           Main component for Opsview
ii  opsview-core                 3.1.0.2553-1hardy1           The core component of Opsview
ii  opsview-perl                 3.1.0.180-1hardy1            Perl modules for Opsview
ii  opsview-reports              2.2.2.248-1hardy1            The reports for Opsview
ii  opsview-web                  3.1.0.2553-1hardy1           Web component for Opsview

r...@appserv:~# dpkg -l mysql\*
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-f/Unpacked/Failed-cfg/Half-inst/t-aWait/T-pend
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name                         Version                      Description
+++-============================-============================-========================================================================
un  mysql-client                                        (no description available)
un  mysql-client-4.1                                    (no description available)
ii  mysql-client-5.0             5.0.51a-3ubuntu5.4           MySQL database client binaries
ii  mysql-common                 5.0.51a-3ubuntu5.4           MySQL database common files
un  mysql-community-client-5.0                          (no description available)
un  mysql-community-server-5.0                          (no description available)
un  mysql-doc-5.0                                       (no description available)
un  mysql-enterprise-client-5.0                         (no description available)
un  mysql-enterprise-server-5.0                         (no description available)
pn  mysql-server                                        (no description available)
un  mysql-server-4.1                                    (no description available)
ii  mysql-server-5.0             5.0.51a-3ubuntu5.4           MySQL database server binaries



17.07.09, 12:27, "Ton Voon" <[email protected]>:

On 17 Jul 2009, at 09:03, Spoofov Spoof wrote:
Solved.
Removing libdbi-perl, perl meta-package and reinstalling opsview  
helps.
Glad you solved it.
This suggests there is some strange interaction between the system  
level perl DBI and the one that we ship in opsview-perl.
Which version of ubuntu is this? Can I have the output of /etc/
debian_release, uname -a and dpkg -l libdbi-perl
Which version of Opsview? dpkg -l opsview\*
Which levels of Mysql? dpkg -l mysql\*
Also, if the problem is perl-dbi related, this may not be the same  
cause as Nick's disconnects and reconnects.
Ton
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users

Ton Voon
Product Architect



Opsera Limited | Unit 69 Suttons Business Park
Reading | Berkshire | RG6 1AZ | UK

Phone:   
+44 (0) 845 057 7887
Mobile
:   +44 (0) 7931 365796
Skype:   tonvoon     Email:   [email protected]

www.opsera.com
This e-mail is confidential, intended only for the named recipient(s) above and may contain information that is privileged and confidential. If you receive this message in error, or are not the named recipient(s), please notify the sender at the phone number above, do not copy this message, do not disclose its contents to anyone, and delete this e-mail message from your computer. Although Opsera routinely screens for viruses, addressees should scan this e-mail and any attachments for viruses. Opsera makes no representation or warranty as to the absence of viruses in this e-mail or any attachments. Opsera Limited is registered in the UK under Company Number 5396532. Our registered office is Gorse View, Horsell Rise, Woking, Surrey, GU21 4RB.
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users

Reply via email to