#1 Installation in existing Database with table-prefix

open
5
2007-03-29
2007-03-29
Andrea
No

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

Discussion

  • Matthias Steffens

    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

     
  • Matthias Steffens

    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

     
  • Matthias Steffens

    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

     
  • Andrea

    Andrea - 2007-03-30

    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

     
  • Matthias Steffens

    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

     
  • Nir Oren

    Nir Oren - 2007-12-13

    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

     
  • Matthias Steffens

    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

     
  • Reinier Post

    Reinier Post - 2009-09-04

    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

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks