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 -- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
