Bug#614320: Error when installing mysql-server-5.1/Error al instalar mysql-server-5.1

February 20th, 2011 - 07:10 pm ET by Flavio Emmanuel Gama Contreras | Report spam

Package: mysql-server

Version: 5.1

When I try to install mysql-server without arguments from an ordinary shell
prompt, start the process, but does not complete successfully.

#aptitude install mysql-server

then, the installl process start, but wen the configure process start says:

Configurando libmysqlclient16 (5.1.49-3) ...
Configurando libdbd-mysql-perl (4.016-1) ...
Configurando mysql-client-5.1 (5.1.49-3) ...
Configurando mysql-server-core-5.1 (5.1.49-3) ...
Configurando mysql-server-5.1 (5.1.49-3) ...
Stopping MySQL database server: mysqld.
110220 17:38:50 [Note] Plugin 'FEDERATED' is disabled.
110220 17:38:50 InnoDB: Started; log sequence number 0 44233
110220 17:38:50 InnoDB: Starting shutdown...
110220 17:38:56 InnoDB: Shutdown completed; log sequence number 0 44233
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error al procesar mysql-server-5.1 (--configure):
el subproceso instalado el script post-installation devolvió el código de
salida de error 1
configured to not write apport reports
dpkg: problemas de dependencias
impiden la configuración de mysql-server:
mysql-server depende de mysql-server-5.1; sin embargo:
El paquete `mysql-server-5.1' no está configurado todavía.
dpkg: error al procesar mysql-server (--configure):
problemas de dependencias - se deja sin configurar
configured to not write apport reports
Se encontraron errores al procesar:
mysql-server-5.1
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Un paquete no se pudo instalar. Intentado recuperarse:
Configurando mysql-server-5.1 (5.1.49-3) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error al procesar mysql-server-5.1 (--configure):
el subproceso instalado el script post-installation devolvió el código de
salida de error 1
dpkg: problemas de dependencias impiden la configuración de mysql-server:
mysql-server depende de mysql-server-5.1; sin embargo:
El paquete `mysql-server-5.1' no está configurado todavía.
dpkg: error al procesar mysql-server (--configure):
problemas de dependencias - se deja sin configurar
Se encontraron errores al procesar:
mysql-server-5.1
mysql-server

I have searched to solve the problem, but I have not been successful, some
website told me to comment out the line skip-bdb in / etc / mysql / my.cnf,
but there is no line.

I also tried to first install all the dependencies listed on the web but did
not work.

My my.cnf is as follows:

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/s...ables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently
parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
#
# Error logging goes to syslog due to
/etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for
replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

I'm using Debian GNU/Linux 6.0, kernel 2.6.32-5-686 #1 SMP Wed Jan 12
04:01:41 UTC 2011 i686 GNU/Linux, and libc6 2.11.2-10

Saludos

Flavio Emmanuel Gama Contreras

P.D. No lo olvides!!! si envías correos masivos, escribe las direcciones de
correo en el campo "CCO" (con copia oculta) y no en el campo "PARA", además
elimina todas las direcciones que ya aparezcan en el cuerpo del mensaje, de
ésta manera evitamos el SPAM y protegemos nuestra privacidad. Protegete a ti
y a tus amigos. No te toma más de dos minutos

Package: mysql-server Version: 5.1 When I try to install mysql-server without arguments from an ordinary shell prompt, start the process, but does not complete successfully. 

 #aptitude install mysql-server then, the installl process start, but wen the configure process start says: <div style="margin-left: 80px;">Configurando libmysqlclient16 (5.1.49-3) ... Configurando libdbd-mysql-perl (4.016-1) ... 

Configurando mysql-client-5.1 (5.1.49-3) ... Configurando mysql-server-core-5.1 (5.1.49-3) ... Configurando mysql-server-5.1 (5.1.49-3) ... Stopping MySQL database server: mysqld. 110220 17:38:50 [Note] Plugin 'FEDERATED' is disabled. 

110220 17:38:50 InnoDB: Started; log sequence number 0 44233 110220 17:38:50 InnoDB: Starting shutdown... 110220 17:38:56 InnoDB: Shutdown completed; log sequence number 0 44233 Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! 

invoke-rc.d: initscript mysql, action "start" failed. dpkg: error al procesar mysql-server-5.1 (--configure): el subproceso instalado el script post-installation devolvió el código de salida de error 1 

configured to not write apport reports dpkg: problemas de dependencias impiden la configuración de mysql-server: mysql-server depende de mysql-server-5.1; sin embargo: El paquete `mysql-server-5.1' no está configurado todavía. 

dpkg: error al procesar mysql-server (--configure): problemas de dependencias - se deja sin configurar configured to not write apport reports Se encontraron errores al procesar: 

mysql-server-5.1 mysql-server E: Sub-process /usr/bin/dpkg returned an error code (1) Un paquete no se pudo instalar. Intentado recuperarse: Configurando mysql-server-5.1 (5.1.49-3) ... Stopping MySQL database server: mysqld. 

Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! invoke-rc.d: initscript mysql, action "start" failed. dpkg: error al procesar mysql-server-5.1 (--configure): el subproceso instalado el script post-installation devolvió el código de salida de error 1 

dpkg: problemas de dependencias impiden la configuración de mysql-server: mysql-server depende de mysql-server-5.1; sin embargo: El paquete `mysql-server-5.1' no está configurado todavía. dpkg: error al procesar mysql-server (--configure): 

problemas de dependencias - se deja sin configurar Se encontraron errores al procesar: mysql-server-5.1 mysql-server </div> I have searched to solve the problem, but I have not been successful, some website told me to comment out the line skip-bdb in / etc / mysql / my.cnf, but there is no line. 

 I also tried to first install all the dependencies listed on the web but did not work. 

 My my.cnf is as follows: 

 <div style="margin-left: 80px;"># # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. 

# # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # # For explanations see 

# <a href="http://dev.mysql.com/doc/mysql/en/s...t;>http://dev.mysql.com/doc/mysql/en/server-system-variables.html</a> # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks/quotes 

# escpecially if they contain "#" chars... # Remember to edit /etc/mysql/debian.cnf when changing the socket location. [client] port = 3306 socket = /var/run/mysqld/mysqld.sock 
# Here is entries for some specific programs 
# The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 

 [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql 

tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. 

bind-address = 127.0.0.1 # # * Fine Tuning # key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed 

# the first time they are touched myisam-recover = BACKUP #max_connections = 100 #table_cache = 64 #thread_concurrency = 10 # # * Query Cache Configuration # query_cache_limit = 1M 

query_cache_size = 16M # # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. # As of 5.1 you can enable the log at runtime! 

#general_log_file = /var/log/mysql/mysql.log #general_log = 1 # # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf. # # Here you can see queries with especially long duration 

#log_slow_queries = /var/log/mysql/mysql-slow.log #long_query_time = 2 #log-queries-not-using-indexes # # The following can be used as easy to replay backup logs or for replication. # note: if you are setting up a replication slave, see README.Debian about 

# other settings you may need to change. #server-id = 1 #log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M #binlog_do_db = include_database_name 

#binlog_ignore_db = include_database_name # # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! # 

# * Security Features # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". # # ssl-ca=/etc/mysql/cacert.pem 

# ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition 

 [isamchk] key_buffer = 16M # # * IMPORTANT: Additional settings that can override those from this file! # The files must end with '.cnf', otherwise they'll be ignored. # !includedir /etc/mysql/conf.d/ 

</div> I'm using Debian GNU/Linux 6.0, kernel 2.6.32-5-686 #1 SMP Wed Jan 12 04:01:41 UTC 2011 i686 GNU/Linux, and libc6 2.11.2-10 -- Saludos Flavio Emmanuel Gama Contreras 

 P.D. No lo olvides!!! si envías correos masivos, escribe las direcciones de correo en el campo "CCO" (con copia oculta) y no en el campo "PARA", además elimina todas las direcciones que ya aparezcan en el cuerpo del mensaje, de ésta manera evitamos el SPAM y protegemos nuestra privacidad. Protegete a ti y a tus amigos. No te toma más de dos minutos 

To UNSUBSCRIBE, email to debian-bugs-dist-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org