[debian-mysql] Bug#444107: [Fwd: RE: unable to install mysql (lamp) (post-installation script returned error exit status 1)]

Mon Oct 1 20:16:06 UTC 2007

also :
i forgot to mention that no process acsisng the mysql tcp port

acerium:/var/log# less syslog
acerium:/var/log# cat syslog|grep 18:3
Sep 29 18:34:27 acerium mysqld_safe[16477]: PLEASE REMEMBER TO SET A
PASSWORD FOR THE MySQL root USER !
Sep 29 18:34:27 acerium mysqld_safe[16477]: To do so, start the
server, then issue the following commands:
Sep 29 18:34:27 acerium mysqld_safe[16477]: /usr/bin/mysqladmin -u
root password 'new-password'
Sep 29 18:34:27 acerium mysqld_safe[16477]: /usr/bin/mysqladmin -u
root -h acerium password 'new-password'
Sep 29 18:34:27 acerium mysqld_safe[16477]: See the manual for more
instructions.
Sep 29 18:34:27 acerium mysqld_safe[16477]: Please report any problems
with the /usr/bin/mysqlbug script!
Sep 29 18:34:27 acerium mysqld_safe[16477]:
Sep 29 18:34:27 acerium mysqld_safe[16477]: The latest information
about MySQL is available on the web at
Sep 29 18:34:27 acerium mysqld_safe[16477]: http://www.mysql.com
Sep 29 18:34:27 acerium mysqld_safe[16477]: Support MySQL by buying
support/licenses at http://shop.mysql.com
Sep 29 18:34:28 acerium mysqld_safe[16542]: ERROR: 1046  No database
selected
Sep 29 18:34:28 acerium mysqld_safe[16542]: 070929 18:34:28 [ERROR]
Aborting
Sep 29 18:34:28 acerium mysqld_safe[16542]:
Sep 29 18:34:28 acerium mysqld_safe[16542]: 070929 18:34:28 [Note]
/usr/sbin/mysqld: Shutdown complete
Sep 29 18:34:28 acerium mysqld_safe[16542]:
Sep 29 18:34:28 acerium mysqld_safe[16625]: started
Sep 29 18:34:28 acerium mysqld[16628]: InnoDB: The first specified
data file ./ibdata1 did not exist:
Sep 29 18:34:28 acerium mysqld[16628]: InnoDB: a new database to be
created!
Sep 29 18:34:28 acerium mysqld[16628]: 070929 18:34:28  InnoDB:
Setting file ./ibdata1 size to 10 MB
Sep 29 18:34:28 acerium mysqld[16628]: InnoDB: Database physically
writes the file full: wait...
Sep 29 18:34:29 acerium mysqld[16628]: 070929 18:34:29  InnoDB: Log
file ./ib_logfile0 did not exist: new to be created
Sep 29 18:34:29 acerium mysqld[16628]: InnoDB: Setting log file
./ib_logfile0 size to 5 MB
Sep 29 18:34:29 acerium mysqld[16628]: InnoDB: Database physically
writes the file full: wait...
Sep 29 18:34:29 acerium mysqld[16628]: 070929 18:34:29  InnoDB: Log
file ./ib_logfile1 did not exist: new to be created
Sep 29 18:34:29 acerium mysqld[16628]: InnoDB: Setting log file
./ib_logfile1 size to 5 MB
Sep 29 18:34:29 acerium mysqld[16628]: InnoDB: Database physically
writes the file full: wait...
Sep 29 18:34:29 acerium mysqld[16628]: InnoDB: Doublewrite buffer not
found: creating new
Sep 29 18:34:30 acerium mysqld[16628]: InnoDB: Doublewrite buffer created
Sep 29 18:34:30 acerium mysqld[16628]: InnoDB: Creating foreign key
constraint system tables
Sep 29 18:34:30 acerium mysqld[16628]: InnoDB: Foreign key constraint
system tables created
Sep 29 18:34:30 acerium mysqld[16628]: 070929 18:34:30  InnoDB:
Started; log sequence number 0 0
Sep 29 18:34:30 acerium mysqld[16628]: 070929 18:34:30 [ERROR] Can't
start server: Bind on TCP/IP port: Cannot assign requested address
Sep 29 18:34:30 acerium mysqld[16628]: 070929 18:34:30 [ERROR] Do you
already have another mysqld server running on port: 3306 ?
Sep 29 18:34:30 acerium mysqld[16628]: 070929 18:34:30 [ERROR] Aborting
Sep 29 18:34:30 acerium mysqld[16628]:
Sep 29 18:34:30 acerium mysqld[16628]: 070929 18:34:30  InnoDB:
Starting shutdown...
Sep 29 18:34:32 acerium mysqld[16628]: 070929 18:34:32  InnoDB:
Shutdown completed; log sequence number 0 43655
Sep 29 18:34:32 acerium mysqld[16628]: 070929 18:34:32 [Note]
/usr/sbin/mysqld: Shutdown complete
Sep 29 18:34:32 acerium mysqld[16628]:
Sep 29 18:34:32 acerium mysqld_safe[16688]: ended
Sep 29 18:34:42 acerium /etc/init.d/mysql[16856]: 0 processes alive
and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping'
resulted in
Sep 29 18:34:42 acerium /etc/init.d/mysql[16856]:
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 29 18:34:42 acerium /etc/init.d/mysql[16856]: error: 'Can't
connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)'
Sep 29 18:34:42 acerium /etc/init.d/mysql[16856]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 29 18:34:42 acerium /etc/init.d/mysql[16856]:

package: mysql-server

version: 5.0.45-1

Hello,...

debian lenny lest update (29.9.2007 12:00 GMT).

when working on this howto :
http://linux.justinhartman.com/Setting_up_a_LAMP_Server

i did :

apt-get update

apt-get install apache2 php5 libapache2-mod-php5 mysql-server
mysql-client php5-mysql phpmyadmin

acerium:/# apt-get install apache2 php5 libapache2-mod-php5
mysql-server mysql-client php5-mysql phpmyadmin
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer
required:
  apache-common
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
  libmcrypt4 php5-common php5-mcrypt
Suggested packages:
  php-pear libmcrypt-dev mcrypt
Recommended packages:
  php5-gd php4-gd
The following packages will be REMOVED:
  libapache2-mod-php4
The following NEW packages will be installed:
  apache2 libapache2-mod-php5 libmcrypt4 mysql-client mysql-server php5
  php5-common php5-mcrypt php5-mysql phpmyadmin
0 upgraded, 10 newly installed, 1 to remove and 305 not upgraded.
1 not fully installed or removed.
Need to get 5948kB/6086kB of archives.
After unpacking 14.9MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 http://mirror.isoc.org.il testing/main php5-common 5.2.3-1+b1
[234kB]
Get:2 http://mirror.isoc.org.il testing/main libapache2-mod-php5
5.2.3-1+b1 [2663kB]
Get:3 http://mirror.isoc.org.il testing/main libmcrypt4 2.5.7-5 [86.7kB]
Get:4 http://mirror.isoc.org.il testing/main php5 5.2.3-1 [1034B]
Get:5 http://mirror.isoc.org.il testing/main php5-mcrypt 5.2.3-1+b1
[13.8kB]
Get:6 http://mirror.isoc.org.il testing/main php5-mysql 5.2.3-1+b1
[73.4kB]
Get:7 http://mirror.isoc.org.il testing/main phpmyadmin 4:2.11.0-1
[2875kB]
Fetched 5948kB in 44s (134kB/s)
Preconfiguring packages ...
(Reading database ... 197242 files and directories currently installed.)
Removing libapache2-mod-php4 ...
Module php4 does not exist!
Selecting previously deselected package apache2.
(Reading database ... 197239 files and directories currently installed.)
Unpacking apache2 (from .../apache2_2.2.4-3_all.deb) ...
Selecting previously deselected package php5-common.
Unpacking php5-common (from .../php5-common_5.2.3-1+b1_amd64.deb) ...
Selecting previously deselected package libapache2-mod-php5.
Unpacking libapache2-mod-php5 (from
.../libapache2-mod-php5_5.2.3-1+b1_amd64.deb) ...
Selecting previously deselected package libmcrypt4.
Unpacking libmcrypt4 (from .../libmcrypt4_2.5.7-5_amd64.deb) ...
Selecting previously deselected package mysql-client.
Unpacking mysql-client (from .../mysql-client_5.0.45-1_all.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.0.45-1_all.deb) ...
Stopping MySQL database server: mysqld.
Selecting previously deselected package php5.
Unpacking php5 (from .../archives/php5_5.2.3-1_all.deb) ...
Selecting previously deselected package php5-mcrypt.
Unpacking php5-mcrypt (from .../php5-mcrypt_5.2.3-1+b1_amd64.deb) ...
Selecting previously deselected package php5-mysql.
Unpacking php5-mysql (from .../php5-mysql_5.2.3-1+b1_amd64.deb) ...
Selecting previously deselected package phpmyadmin.
Unpacking phpmyadmin (from .../phpmyadmin_4%3a2.11.0-1_all.deb) ...
Setting up mysql-server-5.0 (5.0.45-1) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
 subprocess post-installation script returned error exit status 1
Setting up apache2 (2.2.4-3) ...
Setting up php5-common (5.2.3-1+b1) ...
Setting up libapache2-mod-php5 (5.2.3-1+b1) ...
Replacing config file /etc/php5/apache2/php.ini with new version

Setting up libmcrypt4 (2.5.7-5) ...

Setting up mysql-client (5.0.45-1) ...
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.0; however:
  Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Setting up php5 (5.2.3-1) ...
Setting up php5-mcrypt (5.2.3-1+b1) ...

Setting up php5-mysql (5.2.3-1+b1) ...

Setting up phpmyadmin (4:2.11.0-1) ...
Reloading web server config: apache2invoke-rc.d: unknown initscript,
/etc/init.d/apache not found.
invoke-rc.d: unknown initscript, /etc/init.d/apache-ssl not found.
invoke-rc.d: unknown initscript, /etc/init.d/apache-perl not found.

Errors were encountered while processing:
 mysql-server-5.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

I don't if it is a bug or iam doing some thing wrong ...

ok i tried running it manualy :
acerium:/# /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

dpkg-reconfigure mysql-server
/usr/sbin/dpkg-reconfigure: mysql-server is broken or not fully installed

apt-get install mysql-server
.
.
.
.

Starting MySQL database server: mysqld . . . . .dpkg: error processing
mysql-server-5.0 (--configure):
 subprocess post-installation script killed by signal (Interrupt)
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.0; however:
  Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):

ok install mysql-server-5.0 ?

acerium:/# apt-get install mysql-server-5.0
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server-5.0 is already the newest version.
mysql-server-5.0 set to manual installed.
0 upgraded, 0 newly installed, 0 to remove and 305 not upgraded.
2 not fully installed or removed.
Need to get 0B of archives.
After unpacking 0B of additional disk space will be used.
Setting up mysql-server-5.0 (5.0.45-1) ...
Stopping MySQL database server: mysqld.

invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
 subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.0; however:
  Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.0
 mysql-server

wtf ?

acerium:/# apt-cache policy mysql-server
mysql-server:
  Installed: 5.0.45-1
  Candidate: 5.0.45-1
  Version table:
 *** 5.0.45-1 0
        500 http://mirror.isoc.org.il testing/main Packages
        100 /var/lib/dpkg/status
acerium:/# apt-cache policy mysql-server-5.0
mysql-server-5.0:
  Installed: 5.0.45-1
  Candidate: 5.0.45-1
  Version table:
 *** 5.0.45-1 0
        500 http://mirror.isoc.org.il testing/main Packages
        100 /var/lib/dpkg/status

-- 
--
Could you at least use man ?
    Jabka Atu (aka mha13/Mashrom Head) || bsh83.blogspot.com
--