Re: MySQL installieren
Hallo, danke für die Tipps. Ich habe den Server jetzt so eingestellt
damit er die stable Pakete holt und so auch mal gleich die letzten
Sicherheits updates runtergeladen und installiert.
Da der Server laufen soll und ich keine experimente eingehen will gehe
ich davon aus das stable die richtige Wahl ist?
Was mich bei der Sache stutzig macht ist das ich es nicht schaffe den
mysql-server-5.0 zum laufen zu bringen.
Da ich eigentlich meist Suse auf meinen Kisten und mit debian noch zu
wenig Erfahrung habe irritiert es mich das ich in einem Stabel Paket,
das neben einem Apache2 und wenigen Modulen dazu und sonst nur emacs und
iptraf auf der Kiste habe den mysql nicht zum laufen bringe.
Ich habe also mit aptitude die 3 Pakete installiert mysql-server-5.0,
mysql-client-5.0 mysql-common.
Bzw. wenn ich in aptitude eine paket auswähle werden die abhängigen
automatisch mit ausgewählt und dann auch mit installiert.
aptitude 0.4.4
Will use 89.7MB of disk space DL Size:
34.5MB
--\ Packages being automatically installed to satisfy dependencies
piA libdbd-mysql-perl
+324kB <none>
3.0008-1
ciA libmysqlclient15off
+3990kB <none>
5.0.32-7et
piA mysql-client-5.0
+16.9MB <none>
5.0.32-7et
ciA mysql-common
+135kB <none>
5.0.32-7et
piA mysql-server-5.0
+68.2MB <none>
5.0.32-7et
--\ Packages to be installed
pi mysql-client
+73.7kB <none>
5.0.32-7et
pi mysql-server
+81.9kB <none>
5.0.32-7et
Jetzt lädt er ca 80MB runter und entpakt diese - installiert sie und
versucht den mysql server zu starten. Bricht dann aber wegen
abhängigkeitsproblemen ab, lädt nochmal kurz eine paar lib´s nach und
versucht erneut den mysql server zu starten. Leider ohne Erfolg
Hier mal der Auszug aus der syslog:
Jul 14 07:38:09 debian mysqld_safe[16109]: PLEASE REMEMBER TO SET A
PASSWORD FOR THE MySQL root USER !
Jul 14 07:38:09 debian mysqld_safe[16109]: To do so, start the server,
then issue the following commands:
Jul 14 07:38:09 debian mysqld_safe[16109]: /usr/bin/mysqladmin -u root
password 'new-password'
Jul 14 07:38:09 debian mysqld_safe[16109]: /usr/bin/mysqladmin -u root
-h debian password 'new-password'
Jul 14 07:38:09 debian mysqld_safe[16109]: See the manual for more
instructions.
Jul 14 07:38:09 debian mysqld_safe[16109]:
Jul 14 07:38:09 debian mysqld_safe[16109]: Please report any problems
with the /usr/bin/mysqlbug script!
Jul 14 07:38:09 debian mysqld_safe[16109]:
Jul 14 07:38:09 debian mysqld_safe[16109]: The latest information about
MySQL is available on the web at
Jul 14 07:38:09 debian mysqld_safe[16109]: http://www.mysql.com
Jul 14 07:38:09 debian mysqld_safe[16109]: Support MySQL by buying
support/licenses at http://shop.mysql.com
Jul 14 07:38:10 debian mysqld_safe[16257]: started
Jul 14 07:38:10 debian mysqld[16260]: InnoDB: The first specified data
file ./ibdata1 did not exist:
Jul 14 07:38:10 debian mysqld[16260]: InnoDB: a new database to be created!
Jul 14 07:38:10 debian mysqld[16260]: 070714 7:38:10 InnoDB: Setting
file ./ibdata1 size to 10 MB
Jul 14 07:38:10 debian mysqld[16260]: InnoDB: Database physically writes
the file full: wait...
Jul 14 07:38:10 debian mysqld[16260]: 070714 7:38:10 InnoDB: Log file
./ib_logfile0 did not exist: new to be created
Jul 14 07:38:10 debian mysqld[16260]: InnoDB: Setting log file
./ib_logfile0 size to 5 MB
Jul 14 07:38:10 debian mysqld[16260]: InnoDB: Database physically writes
the file full: wait...
Jul 14 07:38:10 debian mysqld[16260]: 070714 7:38:10 InnoDB: Log file
./ib_logfile1 did not exist: new to be created
Jul 14 07:38:10 debian mysqld[16260]: InnoDB: Setting log file
./ib_logfile1 size to 5 MB
Jul 14 07:38:10 debian mysqld[16260]: InnoDB: Database physically writes
the file full: wait...
Jul 14 07:38:10 debian mysqld[16260]: InnoDB: Doublewrite buffer not
found: creating new
Jul 14 07:38:10 debian mysqld[16260]: InnoDB: Doublewrite buffer created
Jul 14 07:38:10 debian mysqld[16260]: InnoDB: Creating foreign key
constraint system tables
Jul 14 07:38:10 debian mysqld[16260]: InnoDB: Foreign key constraint
system tables created
Jul 14 07:38:10 debian mysqld[16260]: 070714 7:38:10 InnoDB: Started;
log sequence number 0 0
Jul 14 07:38:10 debian mysqld[16260]: 070714 7:38:10 [ERROR] Can't
start server: Bind on TCP/IP port: Cannot assign requested address
Jul 14 07:38:10 debian mysqld[16260]: 070714 7:38:10 [ERROR] Do you
already have another mysqld server running on port: 3306 ?
Jul 14 07:38:10 debian mysqld[16260]: 070714 7:38:10 [ERROR] Aborting
Jul 14 07:38:10 debian mysqld[16260]:
Jul 14 07:38:10 debian mysqld[16260]: 070714 7:38:10 InnoDB: Starting
shutdown...
Jul 14 07:38:12 debian mysqld[16260]: 070714 7:38:12 InnoDB: Shutdown
completed; log sequence number 0 43655
Jul 14 07:38:12 debian mysqld[16260]: 070714 7:38:12 [Note]
/usr/sbin/mysqld: Shutdown complete
Jul 14 07:38:12 debian mysqld[16260]:
Jul 14 07:38:12 debian mysqld_safe[16299]: ended
Jul 14 07:38:24 debian /etc/init.d/mysql[16488]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 14 07:38:24 debian /etc/init.d/mysql[16488]: ^G/usr/bin/mysqladmin:
connect to server at 'localhost' failed
Jul 14 07:38:24 debian /etc/init.d/mysql[16488]: error: 'Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul 14 07:38:24 debian /etc/init.d/mysql[16488]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul 14 07:38:24 debian /etc/init.d/mysql[16488]:
Jul 14 07:38:25 debian mysqld_safe[16556]: PLEASE REMEMBER TO SET A
PASSWORD FOR THE MySQL root USER !
Jul 14 07:38:25 debian mysqld_safe[16556]: To do so, start the server,
then issue the following commands:
Jul 14 07:38:25 debian mysqld_safe[16556]: /usr/bin/mysqladmin -u root
password 'new-password'
Jul 14 07:38:25 debian mysqld_safe[16556]: /usr/bin/mysqladmin -u root
-h debian password 'new-password'
Jul 14 07:38:25 debian mysqld_safe[16556]: See the manual for more
instructions.
Jul 14 07:38:25 debian mysqld_safe[16556]:
Jul 14 07:38:25 debian mysqld_safe[16556]: NOTE: If you are upgrading
from a MySQL <= 3.22.10 you should run
Jul 14 07:38:25 debian mysqld_safe[16556]: the
/usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
Jul 14 07:38:25 debian mysqld_safe[16556]: able to use the new GRANT
command!
Jul 14 07:38:25 debian mysqld_safe[16556]:
Jul 14 07:38:25 debian mysqld_safe[16556]: Please report any problems
with the /usr/bin/mysqlbug script!
Jul 14 07:38:25 debian mysqld_safe[16556]:
Jul 14 07:38:25 debian mysqld_safe[16556]: The latest information about
MySQL is available on the web at
Jul 14 07:38:25 debian mysqld_safe[16556]: http://www.mysql.com
Jul 14 07:38:25 debian mysqld_safe[16556]: Support MySQL by buying
support/licenses at http://shop.mysql.com
Jul 14 07:38:25 debian mysqld_safe[16706]: started
Jul 14 07:38:25 debian mysqld[16709]: 070714 7:38:25 InnoDB: Started;
log sequence number 0 43655
Jul 14 07:38:25 debian mysqld[16709]: 070714 7:38:25 [ERROR] Can't
start server: Bind on TCP/IP port: Cannot assign requested address
Jul 14 07:38:25 debian mysqld[16709]: 070714 7:38:25 [ERROR] Do you
already have another mysqld server running on port: 3306 ?
Jul 14 07:38:25 debian mysqld[16709]: 070714 7:38:25 [ERROR] Aborting
Jul 14 07:38:25 debian mysqld[16709]:
Jul 14 07:38:25 debian mysqld[16709]: 070714 7:38:25 InnoDB: Starting
shutdown...
Jul 14 07:38:27 debian mysqld[16709]: 070714 7:38:27 InnoDB: Shutdown
completed; log sequence number 0 43655
Jul 14 07:38:27 debian mysqld[16709]: 070714 7:38:27 [Note]
/usr/sbin/mysqld: Shutdown complete
Jul 14 07:38:27 debian mysqld[16709]:
Jul 14 07:38:27 debian mysqld_safe[16749]: ended
Jul 14 07:38:39 debian /etc/init.d/mysql[16938]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 14 07:38:39 debian /etc/init.d/mysql[16938]: ^G/usr/bin/mysqladmin:
connect to server at 'localhost' failed
Jul 14 07:38:39 debian /etc/init.d/mysql[16938]: error: 'Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul 14 07:38:39 debian /etc/init.d/mysql[16938]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul 14 07:38:39 debian /etc/init.d/mysql[16938]:
Und auch das was aptitude beim Installieren ausgiebt:
(Reading database ... 29948 files and directories currently installed.)
Removing mysql-server ...
Removing mysql-server-5.0 ...
Stopping MySQL database server: mysqld.
Purging configuration files for mysql-server-5.0 ...
Removing mysql-client-5.0 ...
(Reading database ... 28344 files and directories currently installed.)
Removing libdbd-mysql-perl ...
Removing libmysqlclient15off ...
Removing mysql-common ...
Press return to continue.
Preconfiguring packages ...
Selecting previously deselected package mysql-common.
(Reading database ... 28297 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.0.32-7etch1_all.deb) ...
Selecting previously deselected package libmysqlclient15off.
Unpacking libmysqlclient15off (from
.../libmysqlclient15off_5.0.32-7etch1_i386.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from
.../libdbd-mysql-perl_3.0008-1_i386.deb) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from
.../mysql-client-5.0_5.0.32-7etch1_i386.deb) ...
Setting up mysql-common (5.0.32-7etch1) ...
Selecting previously deselected package mysql-server-5.0.
(Reading database ... 28394 files and directories currently installed.)
Unpacking mysql-server-5.0 (from
.../mysql-server-5.0_5.0.32-7etch1_i386.deb) ...
Selecting previously deselected package mysql-client.
Unpacking mysql-client (from .../mysql-client_5.0.32-7etch1_all.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.0.32-7etch1_all.deb) ...
Setting up libmysqlclient15off (5.0.32-7etch1) ...
Setting up libdbd-mysql-perl (3.0008-1) ...
Setting up mysql-client-5.0 (5.0.32-7etch1) ...
Setting up mysql-server-5.0 (5.0.32-7etch1) ...
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 mysql-client (5.0.32-7etch1) ...
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
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:
Setting up mysql-server-5.0 (5.0.32-7etch1) ...
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
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
Press return to continue.
Sorry für die Lange Liste
Kann mir jemand helfen?
Besten Dank
Christian
Sebastian Dellit schrieb:
Hoppa Christian und Leser und Leserinnen,
am Samstag, 14. Juli 2007 um 11:25 meinte Christian Leicht u. a.:
Was sollte denn in der source.list stehen?
Wenn du *nur* ein stable la etch haben möchtest:
#
# CD-Rom
# deb cdrom:[Debian GNU/Linux testing _Etch_ - Official Snapshot amd64 Binary-1 (20061111)]/ etch main
#deb cdrom:[Debian GNU/Linux testing _Etch_ - Official Snapshot amd64 Binary-1 (20061111)]/ etch main
# stable
deb http://ftp.de.debian.org/debian/ stable main
deb-src http://ftp.de.debian.org/debian/ stable main
deb http://security.debian.org/ stable/updates main
deb-src http://security.debian.org/ stable/updates main
wenn du verschiedene Bereiche mit einschließen möchtest, dann:
#
# CD-Rom
# deb cdrom:[Debian GNU/Linux testing _Etch_ - Official Snapshot amd64 Binary-1 (20061111)]/ etch main
#deb cdrom:[Debian GNU/Linux testing _Etch_ - Official Snapshot amd64 Binary-1 (20061111)]/ etch main
# stable
deb http://ftp.de.debian.org/debian/ stable main
deb-src http://ftp.de.debian.org/debian/ stable main
deb http://security.debian.org/ stable/updates main
deb-src http://security.debian.org/ stable/updates main
# testing
deb http://ftp.de.debian.org/debian/ testing main
deb-src http://ftp.de.debian.org/debian/ testing main
deb http://security.debian.org/ testing/updates main
deb-src http://security.debian.org/ testing/updates main
# unstable
deb http://ftp.de.debian.org/debian/ unstable main
deb-src http://ftp.de.debian.org/debian/ unstable main
#experimental
deb http://ftp.de.debian.org/debian/ experimental main
deb-src http://ftp.de.debian.org/debian/ experimental main
Wobei du dann noch einen Eintrag in der apt.conf haben solltest, der
da wie folgt lautet:
APT::Default-Release "stable"
Mit Variante zwei kannst du beim installieren auch auf andere Zweige
ausweichen, z. B. mit:
aptitude -t ttesting install paket
So würdest du das gewünschte Paket nicht von stable, sondern von
testing installieren.
Vermutlich eignet sich bei stable jedoch eher ein backport.
Reply to: