Your message dated Fri, 22 Feb 2013 16:32:58 +0100
with message-id <51278faa.6030...@cyconet.org>
and subject line Re: Bug#701188: ipplan: Lost connection to MySQL server at
'reading initial communication packet', system error: 111 during initial config
via web IF (debconf mysql)
has caused the Debian Bug report #701188,
regarding ipplan: Lost connection to MySQL server at 'reading initial
communication packet', system error: 111 during initial config via web IF
(debconf mysql)
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
701188: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=701188
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: ipplan
Version: 4.92a-2
Severity: grave
Justification: renders package unusable
New install: Configured mysql via debconf ok but needed to amend
/etc/ipplan.apache.conf to re-enable aliases to /usr/share/ipplan before the
ipplan web page could be accessed, contrary to instructions in
/usr/share/doc/ipplan/README.Debian which says that the alias has been disabled
only to prevent it from affecting every virtual host.
As mysql was configured via debconf skipped to step 2, as per instuctions.
Details in /etc/ipplan/local_conf.php appeared to be correct but web page login
required user 'admin' & pw 'admin' which don't appear to be documented anywhere.
Then when trying to display the sql to apply to the mysql db to complete the
installation I got the "Lost connection to MySQL server at 'reading initial
communication packet', system error: 111" error message.
mysql server running ok for other packages i.e. nagios & cacti.
Unable to complete installation, therefore package unusable.
I suspect that the problem is due to ambiguities and omissions in the
instructions detailed in /usr/share/ipplan/README.Debian file e.g. step 2)
"...and maybe the username..." How is anyone to know whether this needs to be
modified or not because no criterion is given?
-- System Information:
Debian Release: 6.0.7
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'proposed-updates'), (500,
'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.32-5-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages ipplan depends on:
ii apache2 2.2.16-6+squeeze10 Apache HTTP Server metapackage
ii apache2-mpm-prefork [ 2.2.16-6+squeeze10 Apache HTTP Server - traditional n
ii debconf [debconf-2.0] 1.5.36.1 Debian configuration management sy
ii libapache2-mod-php5 5.3.3-7+squeeze14 server-side, HTML-embedded scripti
ii libphp-adodb 5.10-1 The ADOdb database abstraction lay
ii libphp-phplayersmenu 3.2.0rc-3 hierarchical menu system class for
ii libphp-phpmailer 5.1-1 full featured email transfer class
ii mysql-client 5.1.66-0+squeeze1 MySQL database client (metapackage
ii mysql-client-5.1 [mys 5.1.66-0+squeeze1 MySQL database client binaries
ii php5 5.3.3-7+squeeze14 server-side, HTML-embedded scripti
ii php5-mysql 5.3.3-7+squeeze14 MySQL module for php5
ii postgresql-client 8.4.16-0squeeze1 front-end programs for PostgreSQL
ii postgresql-client-8.4 8.4.16-0squeeze1 front-end programs for PostgreSQL
ii ucf 3.0025+nmu1 Update Configuration File: preserv
ii wwwconfig-common 0.2.1 Debian web auto configuration
Versions of packages ipplan recommends:
ii mysql-server 5.1.66-0+squeeze1 MySQL database server (metapackage
ii mysql-server-5.1 [mysq 5.1.66-0+squeeze1 MySQL database server binaries and
ii php5-snmp 5.3.3-7+squeeze14 SNMP module for php5
ii postgresql 8.4.16-0squeeze1 object-relational SQL database (su
Versions of packages ipplan suggests:
ii nmap 5.00-3 The Network Mapper
-- Configuration Files:
/etc/ipplan/apache.conf changed:
Alias /ipplan/menus /usr/share/php/libphp-phplayersmenu
Alias /ipplan /usr/share/ipplan
<Directory /usr/share/ipplan>
Options FollowSymLinks
AllowOverride Limit Options FileInfo
</Directory>
-- debconf information:
ipplan/mysql/dbpass: (password omitted)
ipplan/mysql/dbadmpass: (password omitted)
* ipplan/mysql/dbadmin: root
ipplan/purge: true
ipplan/mysql/dbname: ipplan
ipplan/mysql/configure: true
ipplan/restart-webserver: false
ipplan/webserver_type: apache2
* ipplan/mysql/dbuser: ipplan
* ipplan/mysql/dbserver: 192.168.20.151
--- End Message ---
--- Begin Message ---
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Dear ... aehm ... lee,
many thanks for taking time writing this bug report.
Am 22.02.2013 15:36, schrieb l...@northarbour.com:
> New install: Configured mysql via debconf ok but needed to amend
> /etc/ipplan.apache.conf to re-enable aliases to /usr/share/ipplan
> before the ipplan web page could be accessed, contrary to
> instructions in /usr/share/doc/ipplan/README.Debian which says that
> the alias has been disabled only to prevent it from affecting every
> virtual host.
Sorry, I don't really understand the issue.
You could edit /etc/ipplan/apache.conf or write your own apache vhost
configuration. Anyways ... if you just remove the comments before the
Alias-lines in /etc/ipplan/apache.conf the ipplan installation will be
accessible via all vhosts hosting this apache installation, as stated
in the documentation.
> As mysql was configured via debconf skipped to step 2, as per
> instuctions. Details in /etc/ipplan/local_conf.php appeared to be
> correct but web page login required user 'admin' & pw 'admin' which
> don't appear to be documented anywhere.
Hmm ... let me guess it can be found in /usr/share/ipplan/config.php?
Regarding documentation ...
# head -6 /etc/ipplan/local_conf.php
<?php
// This file is intended to overwrite system settings by the user
// Please make your config changes in THIS file
// The following settings was taken from your old config and you should
// consider to keep only lines differing from /usr/share/ipplan/config.php
> Then when trying to display the sql to apply to the mysql db to
> complete the installation I got the "Lost connection to MySQL
> server at 'reading initial communication packet', system error:
> 111" error message.
>
> mysql server running ok for other packages i.e. nagios & cacti.
Could it be, that you need to set your MySQL credentials for ipplan
somehow, needn't you?
This settings are usually stored in /etc/ipplan/db.php and maybe if
you don't have such a file you can create one by something like:
[ -f /etc/ipplan/db.php ] || grep DBF /usr/share/ipplan/config.php | \
head -5 >> /etc/ipplan/db.php
Anyways .. I'm not recommending to use ipplan anymore, as the package
is not available in wheezy and there is a RFA[1] open since long time.
But maybe you decide to take over the maintenance?
If there can't be found a new maintainer I will orphan the package
short after wheezy was released and thus this package will be removed
even from unstable.
Cheers, Jan.
[1] http://bugs.debian.org/647269
- --
Never write mail to <w...@spamfalle.info>, you have been warned!
- -----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GIT d-- s+: a C+++ UL++++ P+ L+++ E--- W+++ N+++ o++ K++ w--- O M V-
PS PE Y++
PGP++ t-- 5 X R tv- b+ DI D+ G++ e++ h---- r+++ y++++
- ------END GEEK CODE BLOCK------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iD8DBQFRJ4+q9u6Dud+QFyQRAiDRAJ9X2KMqL8rxg7VOLohZ5W2fXzQfMQCfWilR
Xp20Nhnw7jqR7b568YcY3/o=
=skHD
-----END PGP SIGNATURE-----
--- End Message ---
