Menu
▾
▴
#1 Installation in existing Database with table-prefix
It would be great to have the possibility to install refBase in an existing database and to choose a table prefix similar to the installation from mediawiki. Then it would be possible to have multiple installations of refBase and other things in one database.
(look at: http://meta.wikimedia.org/wiki/Help:Installation#Run_the_installation_script\)
For user who don't have the mysql root password, but only a password to access and chance their database, cannot create the new user litwww (?). Is it possible to chance the installation-script in this manner, that while the refBase installation no new user must be created?
Regards, Andrea
Logged In: YES
user_id=628208
Originator: NO
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
Logged In: YES
user_id=1756078
Originator: YES
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
Logged In: YES
user_id=628208
Originator: NO
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
Logged In: YES
user_id=628208
Originator: NO
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
Logged In: YES
user_id=1756078
Originator: YES
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
Logged In: YES
user_id=628208
Originator: NO
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
Logged In: YES
user_id=594262
Originator: NO
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
Logged In: YES
user_id=628208
Originator: NO
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
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