files/0.6.1-postinstall-en.txt

0.6.1-postinstall-en.txt (text/plain), 2.03 KB, created by Rene Zbinden on 2005-05-17 01:32:06 UTC

Installation and upgrade Information.
1. MySQL: 
---------
In this section it is assumed, that the MySQL username (used by
online-bookmarks) is "bookmarkmgr", the database where the bookmarks will
reside is named "bookmarks" and the MySQL server is on localhost. If you
decide to use other names, replace the values below accordingly.
Create a new MySQL database.
$ mysqladmin [-u privileged_user] [-p] create bookmarks
    
Create the MySQL user and give it appropriate privileges:
mysql> GRANT ALL PRIVILEGES
       ON bookmarks.* TO 'bookmarkmgr'@'localhost'
       IDENTIFIED BY 'some_password';
mysql> FLUSH PRIVILEGES;
mysql> quit
    
Now create the tables as written in "./sql/create.tables.sql". You can
do it with the command:
$ mysql bookmarks -u bookmarkmgr -p < ./sql/create.tables.sql
    

2. online-bookmarks:
--------------------
To allow the online-bookmarks scripts to communicate
with your MySQL server, edit the file "./config/connect.php". Most probably
(and most hopefully) you need to change the variable "$pw", but you might need
to change "$user", "$db" and "$server" too. This might look like this:
$server='localhost';
$user='bookmarkmgr';
$pw='some_password';
$db='bookmarks';
    

3. Authentication:
------------------
Since version 0.6.x, users are authenticated against the
SQL database. To create a new user, type the following to your MySQL Server:
mysql> INSERT INTO user (username, password) 
       VALUES ('johndoe', MD5('johndoes_password'));
    

4. Test: 
--------
Point your browser to http://www.yourserver.com/online-bookmarks/ and
give it a try.


5. Upgrade an existing Installation:
------------------------------------
If you have an already existing installation of online-bookmarks prior to
version 0.6.x and you would like to upgrade, insert the missing "user" table
to the corresponding MySQL database as described in
"./sql/upgrade.tables.sql".
$ mysql bookmarks -u bookmarkmgr -p < ./sql/upgrade.txt

Mind that you have to migrate users from basic authentication to SQL
authentication (see section "Authentication" above).