{"id":1510,"date":"2016-03-22T16:02:52","date_gmt":"2016-03-22T23:02:52","guid":{"rendered":"http:\/\/internetofhomethings.com\/homethings\/?p=1510"},"modified":"2016-04-29T15:04:15","modified_gmt":"2016-04-29T22:04:15","slug":"usb-lamp-web-server-part-3-adding-mysql-server","status":"publish","type":"post","link":"https:\/\/internetofhomethings.com\/homethings\/?p=1510","title":{"rendered":"USB LAMP Web Server Part 3 – Adding mySQL Server"},"content":{"rendered":"

\"phpmysql2\"<\/a><\/p>\n

A\u00a0web server is certainly not complete without a database server.\u00a0Currently, the one-source server of choice is mySQL. At first, adding this database server to my Linux setup\u00a0update appeared to be simple and straight-forward. Just add another package to the Puppy Linux installation and restart – instant mySQL server capability. But then I soon found that it was not going to be that simple.<\/p>\n

Still, after persistent effort to overcome several patience-trying obstacles, the installation was finally complete. Presented here are the successful steps to adding mySQL Server, without having do deal with the problems. And for those who do not want to go through all the setup steps, a Linux session save file is included with this post.<\/p>\n

Simply replace your existing save file with this one and you will be 99% complete with a web server that supports both php and mySQL server. Here it is<\/a>. You can also refer to the Quick and Easy<\/a> section of this post minimal installation steps.<\/p>\n

But if\u00a0you would like to understand the steps to installing \u00a0mySQL on the USB Puppy Linux setup, read on. Now let’s add the mySQL server\u00a0to the USB LAMP web server installation from\u00a0part 2<\/a>\u00a0of this series.<\/p>\n

Adding mySQL Server\u00a0to the USB Web\u00a0Server<\/strong><\/h3>\n
IMPORTANT: The installation of mySQL Server will corrupt the save file. This will make it impossible to shut-down or start the USB Puppy Linux. Prior to proceeding, copy the save (*.sfs) file, located in the root USB directory (when viewed from Windows OS). It will be needed later to restore the Linux installation.<\/div>\n

Start the USB installed Precision Puppy Linux from part 2<\/a>. Then launch the Puppy Package Manager. In the search window (Find), enter “mysql”.<\/p>\n

\"mysql_svr1\"<\/a><\/p>\n

From the list of results, select mysql-server-5.5-47 metapackage.<\/p>\n

Then click on “Examine dependencies”.<\/p>\n

When a window pops up, click on the “Download and install selected packages” button.<\/p>\n

Then click on “Download packages”.<\/p>\n

After the installation finishes, the following prompt appears:<\/p>\n

\"mysql_svr5\"<\/a><\/p>\n

In order to add\u00a0\u00a0the missing library, first close and then re-opening the Puppy Package Manager.<\/p>\n

This time, enter “libatm” in the find input. You will probably only find one results from searching all the repositories, “libatm1_2.5.1-1.3”.<\/p>\n

Select it and install the package as done for the mySQL server package.<\/p>\n

Backing up the installed packages<\/strong><\/h3>\n

Now is the time to create a backup of the installed programs. Do not exit Puppy Linux until this is completed.<\/p>\n

First, install a blank USB memory stick of at least 4MB into the computer that is running Puppy Linux. This drive will appear as an added device in the bottom left of the Linux screen. Take note of the name assigned to this drive (it will be something like sdb1 or sdc1).<\/p>\n

From a console window, enter:<\/p>\n

cd \/<\/p>\n

mksquashfs etc root usr \/mnt\/<drive name from above>\/mybackup.sfs\u00a0<\/span><\/span><\/span><\/p>\n

Wait for the SFS file creation to complete.<\/p>\n

Now remove the added thumb drive and then hold down the PC start button until the PC shuts off.<\/p>\n

Restoring the backed up configuration<\/strong><\/h3>\n

These steps need to be performed from a PC running\u00a0Windows OS.<\/p>\n

Using the same USB memory stick we have been using to prepare this setup, first copy the save file (see red text above) to the root directory.<\/p>\n

Then copy the “mybackup.sfs” file created above to the USB memory stick root directory.<\/p>\n

Now lets boot from the USB memory stick, which should start in the Puppy Linux OS again.<\/p>\n

NOTE: Make sure the PC you are using for this step has at least 4 GB of ram installed. I tried it with a 1GB netbook which failed the process after running out of RAM.<\/p>\n

Open two file browser windows (Menu->Filesystem->ROX-Filer).<\/p>\n

In one window, navigate to \/etc\/home\/mybackup.sfs. After clicking on the file, select “view”. A folder with the 3 backed up directories (etc root usr) will appear.<\/p>\n

In the other file manager windows, navigate to the top-level folder. Among the other directories, this window will also include etc, root, and usr. Copy the files from the first window to the second window.<\/p>\n

This can be done by pressing Ctl-A in a blank space in the first window (Selects the 3 folders) and dragging these selected folders to the second window.<\/p>\n

I found that a prompt to confirm the over-write of each file was required and could not figure out how to suppress it. Since there are thousands of files to copy, this requires many mouse clicks or pressing the enter key. As a work-around to automate this step, I used an object that was heavy enough to hold the enter key down. A bottle of essential oil worked well for my enter key.<\/p>\n

Use your imagination here!<\/p>\n

\"20160321_151721\"<\/a><\/p>\n

And\u00a0here is where patience is needed. This copy process took over an hour to complete.<\/p>\n

Remember, a save file (*.sfs) is provided with this post which already includes these steps, so you don’t have to repeat this lengthy but necessary step.<\/p>\n

Once the copy is completed, restart the Linux computer. This should created a clean save file.<\/p>\n

Alas, we are ready to resume the mySQL installation!<\/p>\n

Console Entries<\/strong><\/h3>\n

A few steps are now needed to complete the installation of mySQL. Open a console window and enter the following:<\/p>\n

# mkdir \/var\/lib\/mysql<\/p>\n

# adduser mysql<\/p>\n

# chown -R mysql:mysql \/var\/lib\/mysql<\/p>\n

# chgrp -R mysql \/var\/lib\/mysql<\/p>\n

#mysql_install_db<\/p>\n

# mkdir \/var\/run\/mysqld<\/p>\n

# chown mysql:mysql \/var\/run\/mysqld<\/p>\n

That’s it. The installation of mySQL Server is complete.<\/p>\n

mySQL Server commands<\/strong><\/h3>\n

Here are a few console commands to run the server:<\/p>\n

Start Server:<\/strong><\/p>\n

# mysqld<\/p>\n

Stop Server<\/strong> (Do this from a second console window):<\/p>\n

# mysqladmin -u root -p shutdown<\/p>\n

Change rood password:<\/strong><\/p>\n

# mysqldadmin -u root password ‘new-password’<\/p>\n

or<\/p>\n

# \/usr\/bin\/mysqldadmin -u root password ‘new-password’<\/p>\n

Here<\/a> is a reference of other commonly used mySQL server commands.<\/p>\n

Quick and Easy Setup<\/strong><\/h3>\n

And as promised,\u00a0I am providing a system image of the full USB LAMP installation in this section, so you can skip most of\u00a0the steps outlined above and in the first two posts of this series.<\/p>\n

Just follow these simple steps, eliminating most of the time-consuming setup:<\/p>\n

Step 1: Create a Linux USB Memory stick installation per the first part of this post<\/a>. You can stop prior to installing Apache Server. That package is included with the *.2fs file referenced below.<\/p>\n

Step 2: Shut-down the Linux OS running from the USB stick. This will create a save file.<\/p>\n

Step 3: Boot a PC to Windows. Install the USB memory stick and delete the save (*.2fs) file from the root directory. Then copy the *.2fs file from this location<\/a> to the root directory.<\/p>\n

NOTE: The file is contained in a ZIP compressed file. The compressed file is over 280MB in size and\u00a01GB uncompressed. Expect the download to require some time (17 minutes with my connection).<\/strong><\/p>\n

Step 4: Boot a PC with the USB Stick installed to Puppy Linux. This stick now has a complete LAMP stack. But you may need to adjust the IP and port of the server to your specific system. The defaults are IP=192.168.0.110 and port=9777.<\/p>\n

Step 5: Set the IP for your system<\/a><\/p>\n

Step 6: Set the listen port for your system<\/a><\/p>\n

Step 7: Reboot one more time to create your own save file.<\/p>\n

Be sure and review the 3 posts in this series as a guide to using this LAMP stack. A sample HTML and PHP file is provided in the root folder for web pages, \/var\/www<\/p>\n

In Conclusion<\/strong><\/h3>\n

In these 3 articles, we have created a USB memory stick Linux environment and added an Apache Web Server, php and mySQL client libraries, and now the popular mySQL Server. Next, we will add phpmyAdmin as a basic tool for administering the mySQL database.<\/p>\n

As always, I hope you find this information useful…<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

A\u00a0web server is certainly not complete without a database server.\u00a0Currently, the one-source server of choice is mySQL. At first, adding this database server to my Linux setup\u00a0update appeared to be …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,19,3],"tags":[124,125,126,127],"class_list":["post-1510","post","type-post","status-publish","format-standard","hentry","category-alltheposts","category-internet-of-things","category-web-coding-tips","tag-cannot-shutdown-puppy-linux","tag-install-mysql-in-puppy-linux","tag-mysql-corrupts-linux","tag-quick-and-easy-usb-lamp-stack"],"_links":{"self":[{"href":"https:\/\/internetofhomethings.com\/homethings\/index.php?rest_route=\/wp\/v2\/posts\/1510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/internetofhomethings.com\/homethings\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/internetofhomethings.com\/homethings\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/internetofhomethings.com\/homethings\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/internetofhomethings.com\/homethings\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1510"}],"version-history":[{"count":17,"href":"https:\/\/internetofhomethings.com\/homethings\/index.php?rest_route=\/wp\/v2\/posts\/1510\/revisions"}],"predecessor-version":[{"id":1604,"href":"https:\/\/internetofhomethings.com\/homethings\/index.php?rest_route=\/wp\/v2\/posts\/1510\/revisions\/1604"}],"wp:attachment":[{"href":"https:\/\/internetofhomethings.com\/homethings\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/internetofhomethings.com\/homethings\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/internetofhomethings.com\/homethings\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}