Re: permissions dilemma

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
gerard@xxxxxxxxxxxxx
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
--
duane@xxxxxxxxxxxxxx
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
--
duane@xxxxxxxxxxxxxx
_______________________________________________
freebsd-questions@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: permissions dilemma
    ... immediately on start up with permission to create/write it's .pid file ... informed that the screen saver daemon wasn't running. ... I tried installing MySQL twice, each time with the same problem. ...
    (freebsd-questions)
  • Re: permissions dilemma
    ... immediately on start up with permission to create/write it's .pid file ... informed that the screen saver daemon wasn't running. ... I tried installing MySQL twice, each time with the same problem. ...
    (freebsd-questions)
  • Re: Error Installing mysql on Fedora2
    ... installing mysql was the mistake! ... >earlier in todays messages, there was one discussing mysql and getting ... >Open SELinux Service Protection ...
    (Fedora)
  • RE: Installing Mysql on 9.0
    ... Did you start the server? ... Subject: Installing Mysql on 9.0 ... -- redhat-list mailing list unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe ...
    (RedHat)
  • Re: permissions dilemma
    ... immediately on start up with permission to create/write it's .pid ... informed that the screen saver daemon wasn't running. ... I tried installing MySQL twice, each time with the same problem. ...
    (freebsd-questions)