How-to Lighttpd, PHP, MySQL and Eaccelerator

**cichy** · 28-07-2009, 12:01

Hello
Gr8 tutorial but i'm getting errors while trying to connect to mysql

Code:

/opt/bin/mysqladmin -u admin password '********'
/opt/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'admin'@'localhost' (using password: YES)'
[admin@router root]$ mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[admin@router init.d]$ /opt/bin/mysqladmin -u root -p '********'
Enter password:
/opt/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

and my config of my.cnf

Code:

# The following options will be passed to all MySQL clients
[client]
password        = ********
port            = 3306
socket          = /tmp/mysql.sock


# The MySQL server
[mysqld]
user            = admin
datadir         = /opt/var/lib/mysql
port            = 3306
socket          = /tmp/mysql.sock

[mysql.server]
user=root

As you can see i was trying to connect to mysql wit admin and root username and it didn't help. What could be wrong?

**wpte** · 28-07-2009, 19:04

Oh, seems I've made a mistake

try to change

[mysql.server]
user=root

into:

[mysql.server]
user=admin

does that work?

otherwise you might try these commands as well to rebuild the database:

rm -R /opt/var/lib/mysql/mysql
mkdir /opt/var/lib/mysql/mysql
/opt/bin/mysql_install_db

**cichy** · 28-07-2009, 19:18

Hello,
I've already tried to change

Code:

[mysql.server]
user=root

into admin but this didn't helped

Also when i'm trying to execute

Code:

ipkg install optware-devel buildroot

at the end of downloading i get an error about wget (it can't be used to download package to ipkg temp folder)

I'll try to install the database once again after i'm thru with recoverying my files from hdd after moving opt partition (was to small when i wanted to install optware-devel buildroot, alhough it had 512MB).

**wpte** · 28-07-2009, 19:27

uhm... have you restarted the mysql server after the config change?

and when installing the build packages...
if you install wget-ssl manually like this:

ipkg install wget-ssl

and then install the build enviroment

I'm sorry to see that the mysql server is a bit of a trouble. I couldn't have tested it out myself on the router. I did test it on ubuntu which seemed to work out right

**cichy** · 28-07-2009, 19:55

Hmm i've restarted whole router just to make sure

If i recall You didn't mentioned about manual installation of wget-ssl. Also there's new version of eaccelerator (http://bart.eaccelerator.net/source/....6-rc1.tar.bz2) will it work with all other components (i've checked folder structure and they're different in 0.9.5.3 & 0.9.6):>

**wpte** · 28-07-2009, 21:48

Originally Posted by cichy

Hmm i've restarted whole router just to make sure

If i recall You didn't mentioned about manual installation of wget-ssl. Also there's new version of eaccelerator (http://bart.eaccelerator.net/source/....6-rc1.tar.bz2) will it work with all other components (i've checked folder structure and they're different in 0.9.5.3 & 0.9.6):>

It'll probably work

btw, can you confirm the mysql server works now? then I'll know what parts I need to update in the how-to

No, I indeed dindn't mentioned manual installation of wget-ssl.
The problem is, that usually wget is installed, and it doesnt work together with wget-ssl.
wget-ssl is inculed in the building eviroment tho

**freakazoid87** · 22-11-2009, 08:55

hei man...

found solution (think you should include it in tutorial)

http://www.mattgibson.ca/2009/11/05/...n-asus-wl-500/

THANKS FOR ALL THE HELP!

**wpte** · 22-11-2009, 16:18

Originally Posted by freakazoid87

hei man...

found solution (think you should include it in tutorial)

http://www.mattgibson.ca/2009/11/05/...n-asus-wl-500/

THANKS FOR ALL THE HELP!

I included that a while ago... I even told you to test if that was the problem:
http://wl500g.info/showpost.php?p=166318&postcount=38
you told me however there was no feedback from lighttpd...

anyway, the same problem with version 1.4.25-1

**bef** · 11-12-2009, 23:24

Hello,

I followed this tutorial without any problems until the installation of buildroot.
when i enter ipkg install devel-buildroot the following error message shows up:

Code:

 ipkg install optware-devel buildroot
Installing optware-devel (6.8-9) to /opt/...
Downloading http://ipkg.nslu2-linux.org/feeds/optware/oleg/cross/stable/optware-devel_6.8-9_mipsel.ipk
wget: can't load library 'libidn.so.11'
Installing buildroot (4.1.1-13) to /opt/...
Downloading http://ipkg.nslu2-linux.org/feeds/optware/oleg/cross/stable/buildroot_4.1.1-13_mipsel.ipk
wget: can't load library 'libidn.so.11'
Nothing to be done
An error ocurred, return value: 22.
Collected errors:
ipkg_download: ERROR: Command failed with return value 16: `wget    -q -P /opt/ipkg-mNvRKO http://ipkg.nslu2-linux.org/feeds/optware/oleg/cross/stable/optware-devel_6.8-9_mipsel.ipk'
Failed to download optware-devel. Perhaps you need to run 'ipkg update'?
ipkg_download: ERROR: Command failed with return value 16: `wget    -q -P /opt/ipkg-mNvRKO http://ipkg.nslu2-linux.org/feeds/optware/oleg/cross/stable/buildroot_4.1.1-13_mipsel.ipk'
Failed to download buildroot. Perhaps you need to run 'ipkg update'?

I have installe wget-ssl previously (wget-ssl - 1.12-2)
Now even 'ipkg update' does not work any longer.
Any ideas or suggestions?

Thanks in advance

**wpte** · 12-12-2009, 12:57

something went wrong there...

try to remove all the wgets installed

ipkg remove wget wget-ssl

meanwhile you can download the ipkg package manually on your pc:

wget-ssl http://ipkg.nslu2-linux.org/feeds/op...2-2_mipsel.ipk
normal wget: http://ipkg.nslu2-linux.org/feeds/op...2-2_mipsel.ipk

just use ftp or samba to place it anywhere on your disk

then you can simply install it with

ipkg install /path/to/wget

I can recommend wget-ssl since it's the normal wget + ssl support (https)

I hope that'll fix it

**DrChair** · 29-07-2009, 00:54

Originally Posted by cichy

Hello
Gr8 tutorial but i'm getting errors while trying to connect to mysql

Code:

/opt/bin/mysqladmin -u admin password '********'
/opt/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'admin'@'localhost' (using password: YES)'

I also had that problem after following this tutorial.

I solved it by commenting-out the password line in my.cnf (like it was by default).

**wpte** · 29-07-2009, 07:55

so Dr. Chair... nothing wrong with the users then?

Oh yes, I see I need to fix a few things there

**cichy** · 29-07-2009, 16:17

I've rebuilt whole mysql database, changed name from admin to root and vice versa and it didn't helped, I can't get to mysqladmin.

Code:

Enter password:
/opt/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

Dunno what to do now, removing ' didn't help, any sugestions?

P.S. I've installed whole system from a scratch, wget, transmission, ftp are working fine but i ca't get lighttpd to work. Sure I installed it, index.htm* files are working without problem but i can't get fast-cgi to work. Htop shows this

Code:

  152 ?        Ss     0:00      1   146  1365   340  1.1 /usr/sbin/vsftpd
  154 ?        Ss     0:00     36   119  2572   924  3.0 /usr/sbin/nmbd -D
  156 ?        Ss     0:00      9   343  2588   852  2.8 /usr/sbin/smbd -D
  170 ?        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
  203 ?        S      0:00    599  3107  4236  2576  8.5  \_ /opt/libexec/mysqld --basedir=/opt --datadir=/opt/var/lib/mysql --user=admin --pid-file=/opt/var/lib/mysql/router.pi
  206 ?        S      0:00      0  3107  4236  2576  8.5      \_ /opt/libexec/mysqld --basedir=/opt --datadir=/opt/var/lib/mysql --user=admin --pid-file=/opt/var/lib/mysql/route
  207 ?        S      0:00      2  3107  4236  2576  8.5          \_ /opt/libexec/mysqld --basedir=/opt --datadir=/opt/var/lib/mysql --user=admin --pid-file=/opt/var/lib/mysql/r
  225 ?        S      0:00     22   578  4633  2792  9.2 /opt/bin/transmission-daemon -g /tmp/harddisk/transmission/config
  226 ?        S      0:00      0   578  4633  2792  9.2  \_ /opt/bin/transmission-daemon -g /tmp/harddisk/transmission/config
  227 ?        S      0:24    241   578  4633  2792  9.2      \_ /opt/bin/transmission-daemon -g /tmp/harddisk/transmission/config
  383 ?        S      0:00     42   194  3853  1416  4.6 /opt/sbin/lighttpd -f /opt/etc/lighttpd/lighttpd.conf
  384 ?        Z      0:00   1078     0     0     0  0.0  \_ [php-fcgi] <defunct>
  385 ?        Z      0:00   1078     0     0     0  0.0  \_ [php-fcgi] <defunct>
  386 ?        Z      0:00   1078     0     0     0  0.0  \_ [php-fcgi] <defunct>
  388 ?        Z      0:00   1078     0     0     0  0.0  \_ [php-fcgi] <defunct>

I'm attaching my installed packages, maybe something is missing? Also after reinstallation i can't compile latest eaccelerator (it worked earlier).

**wpte** · 30-07-2009, 11:43

well lets focus on the mysql server first:
the idea is:

change the usernames in my.cfg and remove the password line, save it
stop the server
Rebuild the database
start the server
do the password setting: /opt/bin/mysqladmin -u admin password '********'
add the password line in my.cfg
try getting in by: mysql

**cichy** · 30-07-2009, 20:13

Ok, concerning mysql server i've managed to login to root account and later on into admin account. After restart mysql is working fine and you can both login as admin and as as a root. Next restart brought disappointment i couldn't login to mysql either by root nor admin account (s!c).

Thread: How-to Lighttpd, PHP, MySQL and Eaccelerator

Thread Tools

Rate This Thread

Display

Hybrid View

Similar Threads

Full server config: Samba ftp http xmail mysql forum motor

Tags for this Thread

Posting Permissions