start...error

[sandwich_eater]

I installed and started MySQL on Mandriva 10.x and get an "Error" on
screen after a series of "." appears. Where to look for the log?

[Aggro]

sa************@hotmail.com wrote:

I installed and started MySQL on Mandriva 10.x and get an "Error" on
screen after a series of "." appears. Where to look for the log?

/var/log/mysql ?

[sandwich_eater]

Oh, I do not have that directory in /var/log. What can I do?

Aggro wrote:

sa************@hotmail.com wrote:

I installed and started MySQL on Mandriva 10.x and get an "Error" on
screen after a series of "." appears. Where to look for the log?

/var/log/mysql ?

[Aggro]

sa************@hotmail.com wrote:

Oh, I do not have that directory in /var/log. What can I do?

How did you install it? Did you use Mandriva package manager or did you
download it from MySQL website?

[Aggro]

sa************@hotmail.com wrote:

Oh, I do not have that directory in /var/log. What can I do?

Do you have any files there? Like /var/log/mysql.err or /var/log/mysql.log?

[sandwich_eater]

I downloaded and followed instruction file.
No mysql files in the var/log/ directory.

[Bill Karwin]

sa************@hotmail.com wrote:

I downloaded and followed instruction file.
No mysql files in the var/log/ directory.

Some MySQL RPM's are configured to put the log files under /var/lib/mysql.

The issue you described, a bunch of "." one per second, and then a
failure to start MySQL, is very similar to the installation issue I was
working on yesterday, on Redhat Enterprise Linux 4.

The solution in my case was found in the last user comment on this page:
http://dev.mysql.com/doc/mysql/en/linux-rpm.html

If you run a Linux server with SELinux enhancements, you cannot start
the MySQL service, or connect to a running MySQL instance. The security
enforcement of SELinux apparently prevents creations of the needed
runtime files.

To solve this, disable SELinux by running the following command as root:

# setenforce 0

It's possible that you can re-enable it after starting the MySQL
service, but I found that if I tried that, I couldn't make local
connections to databases with SELinux enabled.

# setenforce 1

I hope this is relevant to your situation. I know you said you are
using Mandriva Linux, not RHEL, but Mandriva also has some support for
SELinux.

Regards,
Bill K.

[Aggro]

sa************@hotmail.com wrote:

I downloaded and followed instruction file.
No mysql files in the var/log/ directory.

Since you don't seem to have skills to install it manually. Is there a
reason why you don't use package manager instead?

Anyway, it is quite hard for me to help without knowing what you have
done, in what condition your system currently is and what you have tried
to start the server. It would propably be hard even if your computer
would be in front of me. But personally, I have always installed MySQL
using the package manager and I have never had a single problem on any
distribution I have tried.

[sandwich_eater]

I was not aware that installing it manually was such a big deal, I mean
I just followed the commands in the install file. I am not experienced
at using Linux, I have installed a few things using ./configure etc.
I was not aware that going about an installation this way excluded
package management, I mean why does not the installation register
itself with the package manager?

My Linux install is quite fresh so it is unlikely there is anything
wrong with it.

OK, I try and download the package files for it instead.

[sandwich_eater]

BTW, I am using Mandriva, at this stage I don't know if there are any
suitable RPMs.

[sandwich_eater]

OK, I got RPM file and ran it with "rpm -i"
I got several errors reported the 1st 2 were...

Warning: Asked for 196608 thread stack, but got
126976
/usr/sbin/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13)

.... then at the end I get the same dots and "Error" as before.

[sandwich_eater]

I installed and started MySQL with rpm command, switch -i and get
various errors...
* "asked for 196608 thread stack and got 126976"
* "can't read dir of root/tmp/ Errorcode 13"
* same old "Error" appears on screen after a series of "."

[Aggro]

sa************@hotmail.com wrote:

I installed and started MySQL with rpm command, switch -i and get
various errors...
* "asked for 196608 thread stack and got 126976"
* "can't read dir of root/tmp/ Errorcode 13"
* same old "Error" appears on screen after a series of "."

I'm not sure if I know how to help you since I have never seen errors
like that. I'm running Ubuntu and this is what I did to install MySQL:

1. Open command line and login as root
2. Run these two commands:
apt-get update
apt-get install mysql-server

I think it asked few questions after that. Like do you want to start the
server automaticly on startup etc. But that is pretty much it. Since I
don't have experience in Mandriva I would guess that some Mandriva
related newsgroup would be much more of a help than I am to advice you
how to install it there.

[sandwich_eater]

I installed it OK with RPMs instead.