How-to Lighttpd, PHP, MySQL and Eaccelerator

[cichy]

Here u go

admin:$1$$iqVIP5rhCc3jLzr8y0h.P/:0:0:root:/usr/local/root:/bin/sh
nobody:x:99:99:nobody:/:/sbin/nologin

[wpte]

Here u go

admin:$1$$iqVIP5rhCc3jLzr8y0h.P/:0:0:root:/usr/local/root:/bin/sh
nobody:x:99:99:nobody:/:/sbin/nologin

ok... should be good.
but what if you change everything on that line to admin?
since I have the line:

admin:####:0:0:admin:/:/sbin/nologin

and... mysql starts under that

[cichy]

Hmm i'm now getting this

 221 ?        S      0:00     46   194  3921    88  0.2 /opt/sbin/lighttpd -f /opt/etc/lighttpd/lighttpd.conf
  222 ?        Ss     0:00   1099  3285 34410     4  0.0  \_ /opt/bin/php-fcgi
  236 ?        S      0:00      1  3285 34438     4  0.0  |   \_ /opt/bin/php-fcgi
  224 ?        Ss     0:00   1099  3285 34410     4  0.0  \_ /opt/bin/php-fcgi
  239 ?        S      0:00    239  3285 34446  1264  4.1  |   \_ /opt/bin/php-fcgi
  225 ?        Ss     0:00   1099  3285 34410     4  0.0  \_ /opt/bin/php-fcgi
  238 ?        S      0:00    262  3285 34446   128  0.4  |   \_ /opt/bin/php-fcgi
  226 ?        Ss     0:00   1099  3285 34410    12  0.0  \_ /opt/bin/php-fcgi
  237 ?        S      0:00    312  3285 34458   116  0.3      \_ /opt/bin/php-fcgi
  232 ?        S      0:00     25   578  6957  4400 14.5 /opt/bin/transmission-daemon -g /tmp/harddisk/transmission/config
  233 ?        S      0:00      1   578  6957  4400 14.5  \_ /opt/bin/transmission-daemon -g /tmp/harddisk/transmission/config
  234 ?        S     28:11    350   578  6957  4400 14.5      \_ /opt/bin/transmission-daemon -g /tmp/harddisk/transmission/config
  490 pts/0    S      0:00    103   717  1390   456  1.5 /bin/sh /opt/bin/mysqld_safe --datadir=/opt/var/lib/mysql --pid-file=/opt/var/lib/mysql/router.pid
  523 pts/0    S      0:00    598  3107  4236  2568  8.5  \_ /opt/libexec/mysqld --basedir=/opt --datadir=/opt/var/lib/mysql --user=root --pid-file=/opt/var/lib/m
  526 pts/0    S      0:00      0  3107  4236  2568  8.5      \_ /opt/libexec/mysqld --basedir=/opt --datadir=/opt/var/lib/mysql --user=root --pid-file=/opt/var/l
  527 pts/0    S      0:00      2  3107  4236  2568  8.5          \_ /opt/libexec/mysqld --basedir=/opt --datadir=/opt/var/lib/mysql --user=root --pid-file=/opt/v
  668 pts/0    S      0:00    103   717  1390   456  1.5 /bin/sh /opt/bin/mysqld_safe --datadir=/opt/var/lib/mysql --pid-file=/opt/var/lib/mysql/router.pid
  701 pts/0    S      0:00    598  3107  4236  2568  8.5  \_ /opt/libexec/mysqld --basedir=/opt --datadir=/opt/var/lib/mysql --user=root --pid-file=/opt/var/lib/m
  702 pts/0    S      0:00      0  3107  4236  2568  8.5      \_ /opt/libexec/mysqld --basedir=/opt --datadir=/opt/var/lib/mysql --user=root --pid-file=/opt/var/l
  703 pts/0    S      0:00      2  3107  4236  2568  8.5          \_ /opt/libexec/mysqld --basedir=/opt --datadir=/opt/var/lib/mysql --user=root --pid-file=/opt/v

and i don't know is this good or what

[wpte]

seems like you're running mysql two times here
btw, I see you switched to root again? or what's happening

this is mine:

7963 ? S 0:00 /bin/sh /opt/bin/mysqld_safe --datadir=/opt/var/lib/mysql --pid-file=/opt/var/lib/mysql/wpte.kicks-ass.net.pid
7996 ? S 0:00 \_ /opt/libexec/mysqld --basedir=/opt --datadir=/opt/var/lib/mysql --user=admin --pid-file=/opt/var/lib/mysql/wpte.kicks-ass.net.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
7997 ? S 0:00 \_ /opt/libexec/mysqld --basedir=/opt --datadir=/opt/var/lib/mysql --user=admin --pid-file=/opt/var/lib/mysql/wpte.kicks-ass.net.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
7998 ? S 0:00 \_ /opt/libexec/mysqld --basedir=/opt --datadir=/opt/var/lib/mysql --user=admin --pid-file=/opt/var/lib/mysql/wpte.kicks-ass.net.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock

so looks quite good I guess

[cichy]

I've been diggin out some facts about my.cnf and as i understand it's global config file, if you set password there it's inherited by all running mysql servers. Concerning 2 running processes i don't know why it's happening I've looked here, here and here. The databes is run by non-root user (mysql) maybe this would be better way to create such user and run whole server on this account?

[wpte]

I've been diggin out some facts about my.cnf and as i understand it's global config file, if you set password there it's inherited by all running mysql servers. Concerning 2 running processes i don't know why it's happening I've looked here, here and here. The databes is run by non-root user (mysql) maybe this would be better way to create such user and run whole server on this account?

yes true, mysql on normal servers with linux distros like ubuntu run on the mysql account.
you can try to create a mysql user and try to get it started...
in the end, mysql should run just fine when the password is set.

[cichy]

But what could be the reason of two instances of mysql?