How I set up Route 66 using Mandrake 7.1

How I set up Route 66 using Mandrake 7.1

Disclaimers: I have no connection to the route66 project or Anders Brownworth. I do not promise that the steps below will work for you. However, the procedures below has worked successfully three times on Mandrake 7.1. The install of Mandrake that I used was the developer install which installs Apache, Perl and MySQL. I am posting this solely in the hopes that it can make life easier for anyone else trying to bring this up under Mandrake.

The below will surely seem simple minded and verbose to those who have a large amount of Unix experience, but I wanted to write something that would let those folks like myself see what things should look like during the process. Sometimes, seeing that helps us newbies.

This does not cover remote displays yet as I am waiting for a little bit for the money to pay for a display.

Please see Anders readme in the route66 package also before attempting this.

Things you need installed first:

MySQL - To test to see if it is installed type "myqsl" (Bet you already knew that!)

If you get the following:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.22.32

Type 'help' for help.

mysql>

You are all set, just type "\q" to end.

If you did not see that, then you need to install MySql. Don't Panic! 'Tis easy to do. Launch rpmDrake, expand Databases, click on MySQL and then install. That should do it.

Apache - To see if this is running on your machine, type ps -aux|grep httpd to see if the httpd process is running on your machine. If not, you will have to use rpmDrake to install Apache. It is listed under System -> Servers.

Perl - To see if Perl is installed, type 'perl -v'. You should see the following:

This is perl, v5.6.0 built for i386-linux

Copyright 1987-2000, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5.0 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'. If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.

If not you will have to use rpmDrake to install. It is listed under Development-> Perl.

First, change directory to your /usr/local/src directory

[root@simba jrk]# cd /usr/local/src

Copy the route66 file from the CD into the current working directory:

[root@simba src]# cp /mnt/cdrom/Route-66/route66* ./
[root@simba src]# ls
route66-0.5.3.tar.gz*

First, unzip the route66 file:
[root@simba src]# gunzip route66-0.5.3.tar.gz

Now, untar it:
[root@simba src]# tar -xvf route66-0.5.3.tar
route66-0.5.3/
route66-0.5.3/CHANGES
route66-0.5.3/Database.pm
route66-0.5.3/Display.pm
route66-0.5.3/Menu.pm
route66-0.5.3/README
route66-0.5.3/Settings.pm
route66-0.5.3/TODO
route66-0.5.3/database/
route66-0.5.3/database/add_artist
route66-0.5.3/database/notes.txt
route66-0.5.3/database/add_genre
route66-0.5.3/database/Database.pm
route66-0.5.3/database/show_albums
route66-0.5.3/database/add_songs
route66-0.5.3/database/show_genres
route66-0.5.3/database/show_artists
route66-0.5.3/database/add_album
route66-0.5.3/database/add_filesystem
route66-0.5.3/database/schema.sql
route66-0.5.3/database/notes_mysql.txt
route66-0.5.3/database/add_username
route66-0.5.3/database/add_contributor
route66-0.5.3/database/Settings.pm
route66-0.5.3/database/insert_songs
route66-0.5.3/database/format_songs
route66-0.5.3/database/test this/
route66-0.5.3/database/test this/a song.mp3
route66-0.5.3/database/test this/b song.mp3
route66-0.5.3/database/test this/some dir/
route66-0.5.3/database/test this/some dir/this file.MP3
route66-0.5.3/database/test this/some dir/that file.mp3
route66-0.5.3/display
route66-0.5.3/docs/
route66-0.5.3/docs/dev.txt
route66-0.5.3/docs/user_features.txt
route66-0.5.3/playerlib.pm
route66-0.5.3/playerlib.so
route66-0.5.3/route66
route66-0.5.3/test/
route66-0.5.3/test/display
route66-0.5.3/test/play
route66-0.5.3/test/Database.pm
route66-0.5.3/test/database
route66-0.5.3/test/Display.pm
route66-0.5.3/test/playerlib.pm
route66-0.5.3/test/playerlib.so
route66-0.5.3/test/Menu.pm
route66-0.5.3/test/code_snips/
route66-0.5.3/test/code_snips/nav
route66-0.5.3/test/code_snips/menu
route66-0.5.3/test/code_snips/select
route66-0.5.3/test/code_snips/ary
route66-0.5.3/test/code_snips/time
route66-0.5.3/test/code_snips/showchars
route66-0.5.3/test/code_snips/time2
route66-0.5.3/test/code_snips/sprintf
route66-0.5.3/test/code_snips/bargraph
route66-0.5.3/test/code_snips/Menu.pm
route66-0.5.3/test/code_snips/play
route66-0.5.3/test/code_snips/Settings.pm
route66-0.5.3/test/code_snips/ascii
route66-0.5.3/test/code_snips/Display.pm route66-0.5.3/test/limit
route66-0.5.3/test/keys
route66-0.5.3/test/Settings.pm
route66-0.5.3/BUGS
route66-0.5.3/THANKS
route66-0.5.3/VERSION
route66-0.5.3/webedit/
route66-0.5.3/webedit/Web.pm
route66-0.5.3/webedit/templates/
route66-0.5.3/webedit/templates/index.inc
route66-0.5.3/webedit/templates/error.inc
route66-0.5.3/webedit/templates/file.inc
route66-0.5.3/webedit/templates/footer.inc
route66-0.5.3/webedit/templates/popup.inc
route66-0.5.3/webedit/templates/show.inc
route66-0.5.3/webedit/templates/show_like.inc
route66-0.5.3/webedit/templates/search_paths.inc
route66-0.5.3/webedit/templates/edit_artist.inc
route66-0.5.3/webedit/templates/edit_genre.inc
route66-0.5.3/webedit/templates/edit_album.inc
route66-0.5.3/webedit/templates/edit_song.inc
route66-0.5.3/webedit/index.cgi
route66-0.5.3/webedit/BUGS
route66-0.5.3/webedit/show.cgi
route66-0.5.3/webedit/edit.cgi
route66-0.5.3/webedit/popup.cgi
route66-0.5.3/webedit/insert_path.cgi
route66-0.5.3/webedit/edit.html
route66-0.5.3/webedit/show_like.cgi
route66-0.5.3/webedit/search_paths.cgi
route66-0.5.3/webedit/Database.pm
route66-0.5.3/webedit/README

Remove the tar file:
[root@simba src]# rm route66-0.5.3.tar
rm: remove `route66-0.5.3.tar'? y

Change directory into the route66 directory:
[root@simba src]# cd route66-0.5.3

Copy the MySql stuff into the current directory:
[root@simba route66-0.5.3]# cp /mnt/cdrom/Route-66/Msql-Mysql-modules/* ./
[root@simba route66-0.5.3]# ls
Msql-Mysql-modules-1.2215.tar.gz*

Unzip the Mysql file:
[root@simba route66-0.5.3]# gunzip Msql-Mysql-modules-1.2215.tar.gz
[root@simba route66-0.5.3]# ls
Msql-Mysql-modules-1.2215.tar*

Untar the Mysql file:
[root@simba route66-0.5.3]# tar -xvf Msql-Mysql-modules-1.2215.tar
Msql-Mysql-modules-1.2215/
Msql-Mysql-modules-1.2215/dbd/
Msql-Mysql-modules-1.2215/dbd/constants.h
Msql-Mysql-modules-1.2215/dbd/dbd.xs.in
Msql-Mysql-modules-1.2215/dbd/dbimon.in
Msql-Mysql-modules-1.2215/dbd/Acknowledgements
Msql-Mysql-modules-1.2215/dbd/myMsql.h
Msql-Mysql-modules-1.2215/dbd/Changes
Msql-Mysql-modules-1.2215/dbd/bindparam.h
Msql-Mysql-modules-1.2215/dbd/dbd.pm.in
Msql-Mysql-modules-1.2215/dbd/Makefile.PL.in
Msql-Mysql-modules-1.2215/dbd/dbdimp.c
Msql-Mysql-modules-1.2215/dbd/dbdimp.h
Msql-Mysql-modules-1.2215/dbd/bundle.pm.in
Msql-Mysql-modules-1.2215/lib/
Msql-Mysql-modules-1.2215/lib/ExtUtils/
Msql-Mysql-modules-1.2215/lib/ExtUtils/PerlPP.pm
Msql-Mysql-modules-1.2215/lib/DBD/
Msql-Mysql-modules-1.2215/lib/DBD/mSQL/
Msql-Mysql-modules-1.2215/lib/DBD/mSQL/Install.pm
Msql-Mysql-modules-1.2215/lib/DBD/mSQL1/
Msql-Mysql-modules-1.2215/lib/DBD/mSQL1/Install.pm
Msql-Mysql-modules-1.2215/lib/DBD/mysql/
Msql-Mysql-modules-1.2215/lib/DBD/mysql/Install.pm
Msql-Mysql-modules-1.2215/tests/
Msql-Mysql-modules-1.2215/tests/ak-dbd.t
Msql-Mysql-modules-1.2215/tests/mSQL1.dbtest
Msql-Mysql-modules-1.2215/tests/CSV.mtest
Msql-Mysql-modules-1.2215/tests/CSV.dbtest
Msql-Mysql-modules-1.2215/tests/20createdrop.t
Msql-Mysql-modules-1.2215/tests/dbdadmin.t
Msql-Mysql-modules-1.2215/tests/50commit.t
Msql-Mysql-modules-1.2215/tests/msql2.t
Msql-Mysql-modules-1.2215/tests/mysql.dbtest
Msql-Mysql-modules-1.2215/tests/50chopblanks.t
Msql-Mysql-modules-1.2215/tests/00base.t
Msql-Mysql-modules-1.2215/tests/40nulls.t
Msql-Mysql-modules-1.2215/tests/msql1.t
Msql-Mysql-modules-1.2215/tests/pNET.dbtest
Msql-Mysql-modules-1.2215/tests/mysql2.t
Msql-Mysql-modules-1.2215/tests/40bindparam.t
Msql-Mysql-modules-1.2215/tests/10dsnlist.t
Msql-Mysql-modules-1.2215/tests/mSQL.mtest
Msql-Mysql-modules-1.2215/tests/mysql.t
Msql-Mysql-modules-1.2215/tests/README
Msql-Mysql-modules-1.2215/tests/60leaks.t
Msql-Mysql-modules-1.2215/tests/mSQL1.mtest
Msql-Mysql-modules-1.2215/tests/30insertfetch.t
Msql-Mysql-modules-1.2215/tests/Adabas.mtest
Msql-Mysql-modules-1.2215/tests/40blobs.t
Msql-Mysql-modules-1.2215/tests/40numrows.t
Msql-Mysql-modules-1.2215/tests/lib.pl
Msql-Mysql-modules-1.2215/tests/pNET.mtest
Msql-Mysql-modules-1.2215/tests/40listfields.t
Msql-Mysql-modules-1.2215/tests/skeleton.test
Msql-Mysql-modules-1.2215/tests/mysql.mtest
Msql-Mysql-modules-1.2215/tests/mSQL.dbtest
Msql-Mysql-modules-1.2215/tests/Adabas.dbtest
Msql-Mysql-modules-1.2215/tests/akmisc.t
Msql-Mysql-modules-1.2215/mSQL/
Msql-Mysql-modules-1.2215/mSQL/lib/
Msql-Mysql-modules-1.2215/mSQL/lib/Bundle/
Msql-Mysql-modules-1.2215/mSQL/lib/Bundle/DBD/
Msql-Mysql-modules-1.2215/mSQL/lib/Bundle/DBD/mSQL.pm
Msql-Mysql-modules-1.2215/mSQL/lib/DBD/
Msql-Mysql-modules-1.2215/mSQL/lib/DBD/mSQL.pm
Msql-Mysql-modules-1.2215/mSQL/lib/Msql.pm
Msql-Mysql-modules-1.2215/mSQL/lib/Msql/
Msql-Mysql-modules-1.2215/mSQL/lib/Msql/Statement.pm
Msql-Mysql-modules-1.2215/nodbd/
Msql-Mysql-modules-1.2215/nodbd/nodbd.pm.in
Msql-Mysql-modules-1.2215/nodbd/pmsql.in
Msql-Mysql-modules-1.2215/nodbd/statement.pm.in
Msql-Mysql-modules-1.2215/nodbd/typemap
Msql-Mysql-modules-1.2215/mysql/
Msql-Mysql-modules-1.2215/mysql/lib/
Msql-Mysql-modules-1.2215/mysql/lib/Mysql.pm
Msql-Mysql-modules-1.2215/mysql/lib/Mysql/
Msql-Mysql-modules-1.2215/mysql/lib/Mysql/Statement.pm
Msql-Mysql-modules-1.2215/mysql/lib/DBD/
Msql-Mysql-modules-1.2215/mysql/lib/DBD/mysql.pm
Msql-Mysql-modules-1.2215/mysql/lib/Bundle/
Msql-Mysql-modules-1.2215/mysql/lib/Bundle/DBD/
Msql-Mysql-modules-1.2215/mysql/lib/Bundle/DBD/mysql.pm
Msql-Mysql-modules-1.2215/Makefile.PL
Msql-Mysql-modules-1.2215/MANIFEST
Msql-Mysql-modules-1.2215/MANIFEST.SKIP
Msql-Mysql-modules-1.2215/README
Msql-Mysql-modules-1.2215/ChangeLog

Remove the tar file:
[root@simba route66-0.5.3]# rm Msql-Mysql-modules-1.2215.tar
rm: remove `Msql-Mysql-modules-1.2215.tar'? y

Run the makefile through perl. Select MySQL only.
[root@timon Msql-Mysql-modules-1.2215]# perl Makefile.PL
Which drivers do you want to install?

1) MySQL only
2) mSQL only (either of mSQL 1 or mSQL 2)
3) MySQL and mSQL (either of mSQL 1 or mSQL 2)

4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2

Enter the appropriate number: [3] 1

Do you want to install the MysqlPerl emulation? You might keep your old
Mysql module (to be distinguished from DBD::mysql!) if you are concerned
about compatibility to existing applications! [n]

Where is your MySQL installed? Please tell me the directory that contains the subdir 'include'. [/usr]

Which database should I use for testing the MySQL drivers? [test]

On which host is database test running (hostname, ip address or host:port) [localhost]

User name for connecting to database test? [undef] root
Password for connecting to database test? [undef]

Creating files for MySQL ....................
Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lgz
Using DBI 1.13 installed in /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI
Writing Makefile for DBD::mysql
Writing Makefile for Msql-Mysql-modules

Run make
[root@timon Msql-Mysql-modules-1.2215]# make
mkdir blib
mkdir blib/lib
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/Msql-Mysql-modules
mkdir blib/lib/auto
mkdir blib/lib/auto/Msql-Mysql-modules
mkdir blib/man1
/usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux \
-I/usr/lib/perl5/5.6.0 -Ilib -MExtUtils::PerlPP \
-e ppp "dbd/dbimon.in" "dbimon" "lib/DBD/mysql/Install/Config.pm"
/usr/bin/pod2text mysql/lib/DBD/mysql.pm >README
make[1]: Entering directory `/usr/local/src/route66/Msql-Mysql-modules-1.2215/my
sql'
mkdir ../blib/lib/DBD
mkdir ../blib/arch/auto/DBD
mkdir ../blib/arch/auto/DBD/mysql
mkdir ../blib/lib/auto/DBD
mkdir ../blib/lib/auto/DBD/mysql
mkdir ../blib/man3
cp lib/DBD/mysql.pm ../blib/lib/DBD/mysql.pm
cp lib/Bundle/DBD/mysql.pm ../blib/lib/Bundle/DBD/mysql.pm
cp lib/Mysql/Statement.pm ../blib/lib/Mysql/Statement.pm
cp lib/Mysql.pm ../blib/lib/Mysql.pm
cc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/include/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/lib/perl5/5 .6.0/i386-linux -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -fomit-frame-pointer -fno-exceptions -fno-rtti -pipe -s -mpentium -mcpu=pent ium -march=pentium -ffast-math -fexpensive-optimizations -DVERSION=\"2.0415\ " -DXS_VERSION=\"2.0415\" -fpic -I/usr/lib/perl5/5.6.0/i386-linux/CORE -DDBD_MYS QL dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" < /usr/lib/perl5/site_perl/5.6.0/i386-l inux/auto/DBI/Driver.xst > mysql.xsi
/usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 /usr/lib/ perl5/5.6.0/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.6.0/ExtUtils/typemap mysq l.xs > mysql.xsc && mv mysql.xsc mysql.c
cc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/include/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/lib/perl5/5 .6.0/i386-linux -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -fomit-frame-pointer -fno-exceptions -fno-rtti -pipe -s -mpentium -mcpu=pent ium -march=pentium -ffast-math -fexpensive-optimizations -DVERSION=\"2.0415\ " -DXS_VERSION=\"2.0415\" -fpic -I/usr/lib/perl5/5.6.0/i386-linux/CORE -DDBD_MYS QL mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i586-mandrake-linux/2 .95.3" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdi mp.o mysql.o -L/usr/lib/mysql -L/usr/lib/mysql -lmysqlclient -lm -lz -L/usr/l ib/gcc-lib/i586-mandrake-linux/2.95.3 -lgcc
chmod 755 ../blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs
Manifying ../blib/man3/DBD::mysql.3
Manifying ../blib/man3/Bundle::DBD::mysql.3
Manifying ../blib/man3/Mysql.3
make[1]: Leaving directory `/usr/local/src/route66/Msql-Mysql-modules-1.2215/mys
ql'
mkdir blib/script
cp dbimon blib/script/dbimon
/usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 -MExtUtil
s::MakeMaker -e "MY->fixin(shift)" blib/script/dbimon
Manifying blib/man1/dbimon.1

Now, test what you just made:

[root@timon Msql-Mysql-modules-1.2215]# make test
make[1]: Entering directory `/usr/local/src/route66/Msql-Mysql-modules-1.2215/my sql'
make[1]: Leaving directory `/usr/local/src/route66/Msql-Mysql-modules-1.2215/mys ql'
make[1]: Entering directory `/usr/local/src/route66/Msql-Mysql-modules-1.2215/my sql'
PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5. 6.0/i386-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(&runtests $verbos e); $verbose=0; runtests @ARGV;' t/*.t
t/00base............ok
t/10dsnlist.........ok
t/20createdrop......ok
t/30insertfetch.....ok
t/40bindparam.......ok
t/40blobs...........ok
t/40listfields......ok
t/40nulls...........ok
t/40numrows.........ok
t/50chopblanks......ok
t/50commit..........ok
t/60leaks...........skipped test on this platform
t/ak-dbd............ok
t/dbdadmin..........ok
All tests successful, 1 test skipped.
Files=14, Tests=276, 23 wallclock secs ( 3.06 cusr + 0.23 csys = 3.29 CPU)
make[1]: Leaving directory `/usr/local/src/route66/Msql-Mysql-modules-1.2215/mys ql'

Now, go ahead and install it:

[root@timon Msql-Mysql-modules-1.2215]# make install
make[1]: Entering directory `/usr/local/src/route66/Msql-Mysql-modules-1.2215/my sql'
make[1]: Leaving directory `/usr/local/src/route66/Msql-Mysql-modules-1.2215/mys ql'
Installing /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/mysql/mysql.so
Installing /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/mysql/mysql.bs
Files found in blib/arch: installing files in blib/lib into architecture depende nt library tree
Installing /usr/lib/perl5/site_perl/5.6.0/i386-linux/Mysql.pm
Installing /usr/lib/perl5/site_perl/5.6.0/i386-linux/Mysql/Statement.pm
Installing /usr/lib/perl5/site_perl/5.6.0/i386-linux/Bundle/DBD/mysql.pm
Installing /usr/lib/perl5/site_perl/5.6.0/i386-linux/DBD/mysql.pm
Installing /usr/man/man1/dbimon.1
Installing /usr/lib/perl5/man/man3/DBD::mysql.3
Installing /usr/lib/perl5/man/man3/Bundle::DBD::mysql.3
Installing /usr/lib/perl5/man/man3/Mysql.3
Installing /usr/bin/dbimon
Writing /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/Msql-Mysql-modules/.packl ist
Appending installation info to /usr/lib/perl5/5.6.0/i386-linux/perllocal.pod

Are you tired of typing in route66-0.5.3 yet? I am. Let's rename it to route66.
[root@timon Msql-Mysql-modules-1.2215]cd /usr/local/src
[root@timon src]mv route66-0.5.3 route66

Let's start setting up the sql database:

[root@timon src]# cd route66
[root@timon route66]# mysql mysql -u root

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 32 to server version: 3.22.32

Type 'help' for help.

mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.00 sec)

mysql> drop database route66;
ERROR 1008: Can't drop database 'route66'. Database doesn't exist
mysql> create database route66;
Query OK, 1 row affected (0.00 sec)

mysql> use mysql;
Database changed
mysql> grant all privileges on route66.* to route66@localhost identified by 'rou
te66';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> select user, host, password from user;
+---------+-----------------------+------------------+
| user | host | password |
+---------+-----------------------+------------------+
| root | localhost | |
| root | timon.wizardskeep.org | |
| | localhost | |
| | timon.wizardskeep.org | |
| route66 | localhost | 3c894bc50ccb5d1a |
+---------+-----------------------+------------------+
5 rows in set (0.00 sec)

mysql> \q
Bye

Now, we import the schema that Anders has already defined for us:

[root@timon route66]# mysql -u route66 -proute66 route66 < database/schema.sql

Now, verify that the tables got imported:

[root@timon route66]# mysql -u route66 -proute66 route66

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 34 to server version: 3.22.32

Type 'help' for help.

mysql> show tables;
+-------------------+
| Tables in route66 |
+-------------------+
| albumprefs |
| albums |
| artistprefs |
| artists |
| contributors |
| current |
| filesystems |
| genreprefs |
| genres |
| history |
| paths |
| playlistitems |
| playlists |
| songprefs |
| songs |
| usernames |
| versions |
+-------------------+
17 rows in set (0.00 sec)

mysql> \q;
Bye

Now, we will cd into the 'database' directory and set up a few starting values:

[root@timon route66]# cd database
[root@timon database]# ./add_filesystem
what's the name of the filesystem? timon.wizardskeep.org
timon.wizardskeep.org filesystemid = 2

done.
[root@timon database]# ./add_contributor
what's the contributor? jrk
jrk contributorid = 2

done.
[root@timon database]# ./add_genre
what's the genre? Country
Country genreid = 1

done.
All righty now, lets setup the stuff for Apache (I am assuming that Apache is already up and running for you. If not, use rpmDrake to install it):

Let's change directory to where Apache keeps it's web pages:

[root@timon conf]# cd /home/httpd/html

Now, we need to create a symbolic link for the webedit directory:

[root@timon html]# ln -s /usr/local/src/route66/webedit /home/httpd/html/webedit

Next, change directory to /home/httpd/conf so that we can edit httpd.conf:

[root@timon route66]# cd /etc/httpd/conf

Load httpd.conf in your favorite editor:&nbsp;

[root@timon conf]# vi httpd.conf

Look for the following lines around line 400:

< Directory /home/httpd/cgi-bin >
AllowOverride None
Options ExecCGI
< /Directory >

Now, add the following:

< Directory /home/httpd/html/webedit >
AllowOverride None
Options ExecCGI
< /Directory >

Start and restart httpd.

New, we need to install the MP3-Info package. 'Tis the same basic procedure as the other Perl packages

[root@timon route66]# cp /mnt/cdrom/Route-66/MP3-Info-0.80.tar.gz ./
[root@timon route66]# gunzip MP3-Info-0.80.tar.gz
[root@timon route66]# tar -xvf MP3-Info-0.80.tar
MP3-Info-0.80/eg/mp3tag.PL
MP3-Info-0.80/eg/mp3tocddb.PL
MP3-Info-0.80/Info.pm
MP3-Info-0.80/lib/MPEG/MP3Info.pm
MP3-Info-0.80/Makefile.PL
MP3-Info-0.80/MANIFEST
MP3-Info-0.80/README
MP3-Info-0.80/test.pl
MP3-Info-0.80/test1.mp3
MP3-Info-0.80/test2.mp3
[root@timon route66]# rm *.tar

[root@timon route66]# cd MP3-Info-0.80
[root@timon MP3-Info-0.80]# perl Makefile.PL
Checking if your kit is complete...
Looks good
Writing Makefile for MP3::Info

[root@timon MP3-Info-0.80]# make
mkdir blib
mkdir blib/lib
mkdir blib/lib/MP3
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/MP3
mkdir blib/arch/auto/MP3/Info
mkdir blib/lib/auto
mkdir blib/lib/auto/MP3
mkdir blib/lib/auto/MP3/Info
mkdir blib/man3
cp Info.pm blib/lib/MP3/Info.pm
cp lib/MPEG/MP3Info.pm blib/lib/MPEG/MP3Info.pm
Manifying blib/man3/MP3::Info.3
Manifying blib/man3/MPEG::MP3Info.3

[root@timon MP3-Info-0.80]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i3
86-linux -I/usr/lib/perl5/5.6.0 test.pl
1..91
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
ok 52
ok 53
ok 54
ok 55
ok 56
ok 57
ok 58
ok 59
ok 60
ok 61
ok 62
ok 63
ok 64
ok 65
ok 66
ok 67
ok 68
ok 69
ok 70
ok 71
ok 72
ok 73
ok 74
ok 75
ok 76
ok 77
ok 78
ok 79
ok 80
ok 81
ok 82
ok 83
ok 84
ok 85
ok 86
ok 87
ok 88
ok 89
ok 90
ok 91

[root@timon MP3-Info-0.80]# make install
Installing /usr/lib/perl5/site_perl/5.6.0/MPEG/MP3Info.pm
Installing /usr/lib/perl5/site_perl/5.6.0/MP3/Info.pm
Installing /usr/lib/perl5/man/man3/MP3::Info.3
Installing /usr/lib/perl5/man/man3/MPEG::MP3Info.3
Writing /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/MP3/Info/.packlist
Appending installation info to /usr/lib/perl5/5.6.0/i386-linux/perllocal.pod

Now, you are ready to start adding MP3s to your database. Point your browser to: http://youripaddress/webedit/ and you should see the following:

Click on Insert Paths Into Database ad you should see this:

Type in the path where your mp3s are. Note that the permissions must allow the 'other' group to see it for cgi scripts to work on it. Once you have entered a valid path you will see a list of your MP3s:

Click on "insert" to edit a MP3 values:

Click on "Insert" to insert the MP3 into the database

When you are done entering your MP3s, there is one more task. The playerlib.so on the magazine cd will not work as is. You can either download it from Michael Kidd's website or grab it here. You must replace the playerlib.so in the route66 directory with it. After that change to the route66 directory and type './route66' and you should be up and running! Good luck!

This is a screen capture of it running on a console session:

For other Route 66 files I have, click here.

Home Journal

Search:	Enter keywords...