refbase - Web Reference Database

In install.php this is supported now. I had to do a manual installation,
and wrote a Perl script to rename the tables in install.sql:

http://www.win.tue.nl/~rp/bin/mysql-rename-tables

Hi jhudsy,

thanks for the bug report! The issue you're describing has already been
fixed in the refbase version that's available in the refbase SVN
repository:

http://svn.refbase.net/

Best, Matthias

There is a problem with the instructions regarding how to do this on the
wiki; line 2994 of include.inc.php seems hard coded to use the
user_permissions (or group_permissions) table. I had to manually edit that
line and add my prefix to it. This is in version 0.9.0 of refbase

I've added your suggestions to our feature additions list[1] and we will
try to improve the refbase install script so that it can be used more
flexibly. However, these improvements will not be part of the upcoming
minor release, but are scheduled for a release thereafter.

[1]:
http://wiki.refbase.net/index.php/Planned_feature_additions#Improvements_to_install.php

Thanks again for the feedback!

Matthias

We decided to install refBase in a new and empty database. Everything
works fine.

Perhaps you can improve in installation-script for installations over an
existing DB in future releases.


Andrea

Sorry for the quick follow-up:

Your error message is probably since the 'install.php' script from
refbase-0.9.0 had a bug where its UPDATE SQL queries did still use raw
table names instead of the appropriate '$table*' variables from
'initialize/db.inc.php'. Thas his already been fixed in the refbase SVN
version. You could download an updated version of 'install.php' from:

http://refbase.svn.sourceforge.net/viewvc/refbase/branches/bleeding-edge/install.php?view=log

The current revision (rev. 902) should work fine in conjunction with
refbase-0.9.0.

Matthias

Did you make sure that ALL table names in 'db.inc.php' *AND* in
'install.sql' were correctly prefixed with your table name prefix prior to
using 'install.php'? The error you receive could result from an incomplete
renaming action. Anyways, I recommend to also read the instructions at:

http://wiki.refbase.net/index.php/Manual_installation

Let us know if this doesn't help. Matthias

I didn't try the manual installation yet.

I got the following error, when I try the installation over an existing
database as descriped in:
http://wiki.refbase.net/index.php/Installing_refbase#Installation_over_an_existing_database

Error 1146 : Table 'My-ownDB.depends' doesn't exist

from install.php, line 420

Hi Andrea, thanks for the feature request! Our forums may be best to
discuss this in more detail.
While the web install script ('install.php') has no option (yet) to
specify a table prefix, it's possible to install refbase-0.9.0 into an
existing database. See here:

http://wiki.refbase.net/index.php/Installing_refbase#Installation_over_an_existing_database

It's correct that the current version of 'install.php' requires a MySQL
admin user. See:

http://wiki.refbase.net/index.php/Installing_refbase#Additional_web-install_requirements

If you are trying to install refbase on a shared hosts you'll currently
need to perform a manual installation:

http://wiki.refbase.net/index.php/Manual_installation

On the "Manual installation" page, look for comments w.r.t. shared hosts.
Also note that you can copy the entire contents of 'install.sql' into the
SQL command entry form provided by tools such as phpMyAdmin. This will
allow you to install refbase without the need for 'install.php'.

That said, we'll try to improve the refbase web installer. We could add an
option to skip the creation of a separate MySQL user. However, note that
this may pose serious security concerns if you're not on a shared host
(i.e. if the regular MySQL user has full database access rights).

Matthias