List:General Discussion« Previous MessageNext Message »
From:Carlos Andrade Date:April 2 2010 10:24pm
Subject:[Mysql-server-5.0]Missing socket files and denied acess to root user
View as plain text  
Hello MySQL Community,

I'm new around, and I'm a new mysql user. I use mysql mostly together with
Moodle to support many courses on a public university in Brazil (UFBA).

Recently, I was trying to use Reverse Engineering on Workbench to catch a
relationship diagram for moodle, and so I've attempted to make foreign keys
there on. For that, I need to make mysql logs be saved as tables instead of
file.

This is where my trouble started.

According to a windows user, he could do that on my.ini , and I didn't find
that on Ubuntu 9.04, so I've tried to run a command I found on Mysql
Reference manual, 5.1. located on (
http://dev.mysql.com/doc/refman/5.1/en/log-tables.html).

So I attempted something like #mysql -u"mydbrootid" -p"mydbrootpass"
--log-output=TABLE

After that and other few tempts trying that, suddently my root was not able
to acess mysql anymore.

I tried to delete, move, reinstall and everything you can imagine but it
just seems I made things worse, so I tried to purge every mysql file from my
PC, together with php5-mysql and apache2.

After that I installed apache2, and then tried to install by aptitude
mysql-server-5.0

In this point, i'm stucked, I get the following error while on the
mysql-server-5.0 install process:

root@midgard:/etc/init.d# apt-get install mysql-server-5.0
Lendo listas de pacotes... Pronto
Construindo árvore de dependências
Lendo informação de estado... Pronto
Os pacotes extra a seguir serão instalados:
  libdbd-mysql-perl libdbi-perl libhtml-template-perl libnet-daemon-perl
libplrpc-perl mysql-client-5.0 mysql-server-core-5.0
Pacotes sugeridos:
  dbishell libipc-sharedcache-perl mysql-doc-5.0 tinyca mailx
Os NOVOS pacotes a seguir serão instalados:
  libdbd-mysql-perl libdbi-perl libhtml-template-perl libnet-daemon-perl
libplrpc-perl mysql-client-5.0 mysql-server-5.0 mysql-server-core-5.0
0 pacotes atualizados, 8 pacotes novos instalados, 0 a serem removidos e 0
não atualizados.
É preciso baixar 874kB/35,9MB de arquivos.
Depois desta operação, 110MB adicionais de espaço em disco
serão usados.
Você quer continuar [S/n]? S
Obter:1 http://br.archive.ubuntu.com jaunty/main libnet-daemon-perl 0.43-1
[46,9kB]
Obter:2 http://br.archive.ubuntu.com jaunty/main libplrpc-perl 0.2020-1
[36,0kB]
Obter:3 http://br.archive.ubuntu.com jaunty/main libdbi-perl 1.607-1 [791kB]
Baixados 874kB em 10s (83,6kB/s)


Pré-configurando pacotes ...
Selecionando pacote previamente não selecionado libnet-daemon-perl.
(Lendo banco de dados ... 185830 arquivos e diretórios atualmente
instalados).
Desempacotando libnet-daemon-perl (de .../libnet-daemon-perl_0.43-1_all.deb)
...
Selecionando pacote previamente não selecionado libplrpc-perl.
Desempacotando libplrpc-perl (de .../libplrpc-perl_0.2020-1_all.deb) ...
Selecionando pacote previamente não selecionado libdbi-perl.
Desempacotando libdbi-perl (de .../libdbi-perl_1.607-1_i386.deb) ...
Selecionando pacote previamente não selecionado libdbd-mysql-perl.
Desempacotando libdbd-mysql-perl (de .../libdbd-mysql-perl_4.008-1_i386.deb)
...
Selecionando pacote previamente não selecionado mysql-client-5.0.
Desempacotando mysql-client-5.0 (de
.../mysql-client-5.0_5.1.30really5.0.75-0ubuntu10.3_i386.deb) ...
Selecionando pacote previamente não selecionado mysql-server-core-5.0.
Desempacotando mysql-server-core-5.0 (de
.../mysql-server-core-5.0_5.1.30really5.0.75-0ubuntu10.3_i386.deb) ...
Selecionando pacote previamente não selecionado mysql-server-5.0.
Desempacotando mysql-server-5.0 (de
.../mysql-server-5.0_5.1.30really5.0.75-0ubuntu10.3_i386.deb) ...
Selecionando pacote previamente não selecionado libhtml-template-perl.
Desempacotando libhtml-template-perl (de
.../libhtml-template-perl_2.9-1_all.deb) ...
Processando gatilhos para man-db ...
Configurando libnet-daemon-perl (0.43-1) ...
Configurando libplrpc-perl (0.2020-1) ...
Configurando libdbi-perl (1.607-1) ...
Configurando libdbd-mysql-perl (4.008-1) ...
Configurando mysql-client-5.0 (5.1.30really5.0.75-0ubuntu10.3) ...
Configurando mysql-server-core-5.0 (5.1.30really5.0.75-0ubuntu10.3) ...
Configurando mysql-server-5.0 (5.1.30really5.0.75-0ubuntu10.3) ...
 * Stopping MySQL database server mysqld

                 [ OK ]
100402 17:36:21 [ERROR] /usr/sbin/mysqld: Can't find file:
'./mysql/user.frm' (errno: 13)
100402 17:36:21 [ERROR] /usr/sbin/mysqld: Can't find file:
'./mysql/user.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/user.frm' (errno: 13)


100402 17:36:21 [ERROR] Aborting

100402 17:36:21 [Note] /usr/sbin/mysqld: Shutdown complete

 * Reloading AppArmor profiles ...

                 [ OK ]
 * /etc/init.d/mysql: WARNING: /etc/mysql/my.cnf cannot be read. See
README.Debian.gz
 * Starting MySQL database server mysqld

                 [fail]
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: erro processando mysql-server-5.0 (--configure):
 sub-processo post-installation script retornou estado de saída de erro 1
Configurando libhtml-template-perl (2.9-1) ...
Erros foram encontrados durante o processamento de:
 mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@midgard:/etc/init.d#

Which makes me believe that my socket file is gone when I went removing
files, and no matter how I try to install it it wont come back. Same goes
for the my.cnf file.

Does anyone have any clue to work this around? I couldn't find on google.

Hope I did not post on the wrong list.

Thank you,

Carlos Andrade

Thread
[Mysql-server-5.0]Missing socket files and denied acess to root userCarlos Andrade3 Apr
  • Re: [Mysql-server-5.0]Missing socket files and denied acess to root userCarlos Andrade3 Apr