MySQL

From WL-HDD Wiki

Jump to: navigation, search
WL-HDD Contents
What is the WL-HDD
Features
Pro's/con's
Reviews
Hacking
Inserting the HDD
Hacking Guides
Basic setup guides
Packages guides
Requests
Troubleshooting
This Wiki
Credits
Editing help
Contact Me

Contents

Prerequisites

To complete this guide, the following is assumed:

You are running Oleg's firmware (1.9.2.7-6b or later)
You have harddisk partitions up and running with an extended filesystem mounted to /opt
You have installed the Ipkg package system.
You have configured your partitions to automount.

Installation

Install the new version of ipkg:

On a freshly formatted external filesystem, mounted on /opt, do the following...

  • First create the directories needed: 
mkdir /opt/tmp
mkdir /opt/tmp/ipkg
  • Now get the better version of ipkg and uclibc. The ipkg.sh below will complain about missing /opt/lib/ipkg/lists/wl500g, but there is no problem since we are installing straight from the ipkg files. 
# Get the better version of ipkg
wget http://ipkg.nslu2-linux.org/feeds/optware/oleg/cross/stable/ipkg-opt_0.99.163-9_mipsel.ipk
  1. Install it (Ignore the missing lists/wl500g error) 
ipkg.sh install ipkg-opt_0.99.163-9_mipsel.ipk
  1. Get the better version of uclibc 
wget http://ipkg.nslu2-linux.org/feeds/optware/oleg/cross/stable/uclibc-opt_0.9.28-12_mipsel.ipk
  1. Now install it (Ignore the missing lists/wl500g error) 
ipkg.sh install uclibc-opt_0.9.28-12_mipsel.ipk
  1. Update the list using the improved ipkg 
ipkg update

Now upgrade your system: 

ipkg upgrade
ipkg list_installed
ipkg install -force-reinstall 'all listed packages'
  1. This last command refers to the packages listed by the list_installed command. You need to update all of these packages. You do not however have to re-upgrade ipkg and uclibc, we have already done this.

Install MySQL

Lets install the package: 

ipkg install MySQL

Ignore the error messages.. We're still working on it!

Setup

Now for the 'hard' part. We'll have to change the name of 'admin' (default) into 'root' otherwise MySQL won't work.

Via a Web Browser:

  • In your web browser, browse to the WL-HDD configuration pages, then to System and finally to Change Name. Make root the new name.

Via SSH or Telnet:

  • Change the name of admin into root for Telnet (and/or SSH) 
nano /etc/passwd

change the line: 

admin:$1$uVp0rbe2$/pFIqeoCxe1spdyUOa6OP1:0:0:root:/usr/local/root:/bin/sh (note: the password hash will probably be different!!)

to 

root:$1$uVp0rbe2$/pFIqeoCxe1spdyUOa6OP1:0:0:root:/usr/local/root:/bin/sh

To save this file: 

CTRL + O (press Y)
CTRL + X

Making it permanent:

  • Enter the following commands, you only ever have to do the echo commands once on the WL-HDD - hence don't do it again if you have already done it before. 
echo "/etc/passwd" >>/usr/local/.files
echo "/etc/group" >>/usr/local/.files

Now lets commit to the flash. 

flashfs save
flashfs commit
flashfs enable

Now lets reboot and re-login with root instead of admin.

Finishing off

All packages should be installed and almost ready to go. There are only a few things left to change and then we should be going...

The MySQL database directory is corrupted in some way. We can fix this by the following command: 

rm /opt/var/lib/mysql/mysql/*.*
rmdir /opt/var/lib/mysql/mysql

Then we'll rebuild the database again: 

/opt/bin/mysql_install_db

Last (but not least): 

chown -R root:root /opt/var/lib/mysql

Start MySQL

To start MySQL type: 

/opt/etc/init.d/S70mysqld start

Now for security-reasons (obviously) CHANGE THE PASSWORD for the ROOT user:

  • To do so, start the server, then issue the following commands: 
/opt/bin/mysqladmin -u root password 'your-new-password' **

With my first installation something went wrong and I got an error about not being able to load the library libmysqlclient.so.14

  • This is solved by typing: 
ln -s /opt/lib/mysql/libmysqlclient.so /opt/lib/libmysqlclient.so.14 ((sym)link to the right library)

Note: MySQL is pretty heavy for a Asus WL-HDD. I've had it running for some time now and it's a bit slow. I wouldn't bother inputting large databases, however, for a simple homepage it's fine!

This guide was put together using this page and Google by Lucaspr.

Many thanks to the author from Jono 18:33, 7 March 2007 (GMT)

Retrieved from "http://wlhdd.co.uk/wiki/MySQL"
Personal tools