jekillen wrote:
On Apr 28, 2006, at 6:10 PM, Duane Whitty wrote:
jekillen wrote:
On Apr 28, 2006, at 5:38 PM, Gerard Seibert wrote:
jekillen wrote:
Hello:
I have had a problem with installing MySQL 5.0.18 on a FreeBSD v 6.0
installation
where everything seems to compile and install correctly but the
server
crashes
immediately on start up with permission to create/write it's .pid
file
denied.
Then the screen saver daemon refuses to start in X windows with a
permission denied
error. It originally worked fine. But at some point recently the
screen
saver quit working.
When I went to Gnome preferences and tried to set the screen saver
I was
informed that the screen saver daemon wasn't running. When I tried to
have it
start I was presented with the permission denied error and to
check the
$path
variable.
I tried installing MySQL twice, each time with the same problem.
As I understand it, permissions in Unix are part of the file system
format.
The only possible link between MySQL and the screen saver daemon,
possibly, is the
mysql user needed to run mysqld.
Could I have a corrupted file system in such a way as to cause
permission problems?
thanks in advance.
JK
Are you starting MySQL with the script in /usr/local/etc/rc.d/ upon
bootup?
--
Gerard Seibert
[EMAIL PROTECTED]
Boy that was fast, I just posted this message a moment ago...
No I was just testing it using the mysqld_safe --user=mysql & approach.
Hi,
As you don't mention it explicitly, did you run "mysql_install_db
--user=mysql" ?
yes....well come to think of it I only ran mysql_install_db without
the --user part
I believe. I'll redo it an see what happens.
thanks
I know the first time I installed MySQL I neglected to do so. As
well, do you also
have a mysql user and a mysql group defined?
yes, but I'm confused, why would the mysql user need a shell and login
password.
No password means that any one could log into the system as the mysql
user
but how would mysqld switch to the mysql user if it has a password.
I did this on another machine running the same version of FreeBSD and
was successful.
So far MySQL runs fine on it. I don't recall exactly what I did
differently.
Would this have a bearing on the screen saver daemon? Or is that
another issue?
Best Regards,
Duane Whitty
--
[EMAIL PROTECTED]
MySQL user does not need and should not have a login shell.
the entry in the password and group file should be set-up
automatically for you when you install MySQL.
The method I used to install MySQL was to use the ports
system via portupgrade. Then run mysql_install_db --user=mysql
This sets a lot of things up for you.
As I believe another poster has mentioned you will want to delete
everything under /var/db/mysql/
Also do a chown mysql:mysql /var/db/mysql
Read the chapters in the MySQL manual regarding post-install
tasks under UNIX and securing the initial MySQL accounts.
Hope this helps,
Duane Whitty
--
[EMAIL PROTECTED]
_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
