Installation

Last updated 25 june 08

kPlaylist performs automatic installation and upgrade. If you have a webserver with PHP support and MySQL, download the script, put it in a webaccessable area and point your browser to the script and the installation or upgrade should start. Refer to this page later if you have problems.

If you use Windows and don't have Apache, PHP or MySQL, download wampserver and get everything in one install. Come back here after the wamp install to continue the kPlaylist installation.

NB for WAMP! Note the username and password for MySQL

Preinstall setup

You'll need a running copy of MySQL and a webserver with PHP4 or PHP5 to perform the installation. PHP5 is recommended.

If you use a Linux distribution those applications will probably already be installed. If not, use your favourite package manager and install these.

1. Create a new directory for kPlaylist under your htdocs structure and copy the 'kplaylist' file to 'index.php' under that directory.

If you're running a UNIX based system, make sure that the user running your webserver can read the kPlaylist file and directory.

If you are using WAMP, you will have a "WAMP Web Documents" shortcut on your desktop, go there and create a new directory. Copy the 'kplaylist' file to 'index.php' in that directory.

2. Open your favourite webbrowser and point it to the kplaylist directory, and the installer will start.

Example, http://localhost/kplaylist/ if you named the directory kplaylist.

3. Now the installer should have started. Now you have to decide whether to use an existing database or a new one. If you are running kPlaylist on your own machine, create a new. If you intend to run on a hosted solution and only have access to one database, use existing.

Create new database

Enter the username and password for the root user of MySQL.

If you installed WAMP, enter the username and password you selected for MySQL during WAMP installation. Click continue and you are finished.

Use existing database

Edit the scipt with a texteditor and adjust the $db['name'] (database name), $db['user'] (user), $db['pass'] (password) and $db['host'] (server) to suit your database setup. It's also suggested to edit the $db['prepend'] to 'kplay_' to avoid duplicate table names. Click 'Continue' when you're finished.

Post install setup

Log into kPlaylist with admin/admin (follow the instructions on the installer.) Now, click the 'Settings' button to the right. A new window will appear. Click 'File handling', and put your music directory or directories in the field called 'Base directory'. Separate multiple paths with: ;. You can also click the "find" button on the right to automatically search for directories containing music.

Now, you should run the 'Update' button on the right. This will add all music files in your database. You don't need at first, but it's recommended because you get alot of features enabled right away.

Considerations

Make sure that the webserver can read your audio files. If they can't, they wont appear in kPlaylist.

You should check httpd.conf in your conf directory on Apache. Look for the variable called 'User' and 'Group'. This is normally 'nobody' and 'nogroup'. Make sure this user or group can read MP3 files, and execute directories in your audio path.

Problems

Getting this? Client does not support authentication protocol requested by server; consider upgrading MySQL client? Go here for the solution: http://www.kplaylist.net/forum/viewtopic.php?p=2231

Ancient errors, but may occur:

Getting an error saying: 'Can't connect to local MySQL server through socket "/tmp/mysql.sock"?

Do the following, find the IPC (socket) by issuing the following command in your shell:
find / -name "mysql.sock" -ls
Did you find it? Please edit your PHP configuration file (php.ini) which is usually located here: /usr/local/lib/php.ini, and find the key called "mysql.default_socket" and put the full path to the socket file there. (For example: mysql.default_socket = /var/lib/mysql/mysql.sock). Then restart Apache and you should be set.

Have comments to the installation instructions? If so, please take a few minutes and tell us how it can be improved here.