Multi-site (?) on DreamHost

edited December 2010 in Installation
I've installed v0.9.6 on a DreamHost shared server into a ~myroot/status directory. That works and now I'd like to try a multi-site kind of installation as follows:
Software is installed in ~myroot/statusnet
The install.php is run in ~myroot/site1 to create a config.php for Site1 users.
The install.php is run in r~myroot/site2 to create a config.php for Site2 users.
Both of these use the software in root/statusnet, they will use different databases.
I don't know which files need to be put into the ~myroot/siteN directories and which should not.
.htaccess should be set in each siteN directory as well, but with
RewriteBase '~myroot/siteN' and $config['site']['path'] = '~myroot/statusnet'; ?
Will $config['site']['fancy']=true still do the trick here?
Where are themes kept?
Are plugins at the software level or the site level?
There are too many questions and not enough sources of answers.

The info at http://status.net/wiki/Status_network is discouraging with words like "hairy" and "tricky". And for this scenario I'm not even sure if that's what I need to look at.

To add a monkey wrench into the works, when I accomplish this task I'd like to understand how to setup as site1.mydomain.com, and perhaps site2.mydomain.com/subtopic ... all with a single codeset.

Thanks for your time!

Comments

  • @CaptainStarbuck you won't be able to run a multi-site status network on shared hosting because you need to be able to have root access to apache settings.
  • Fair enough. I won't get a Private Server (PS) package just to support this. So for now I'll just maintain copies of the source in each subsite.

    For anyone who is going to do this (and if a client asks me to set it up, that anyone might be me), is there a definitive HowTo anywhere? Right now it seems like information is scattered among Readme, wiki, and forum postings. Thanks!
  • @CaptainStarBuck I think that's pretty much it right now. We're working on improving documentation - the Wiki is generally the main source.
  • Hi,

    I've got exactly the same need.
    CaptainStarbuck, have you got any feedback or prefered method to give?

    Thx
  • No info beyond what we see here. :(
  • I'm trying to use status_network optional table but it doesn't works for me :

    - statusnet 0.9.6 has been installed correctly on a local httpd. (I can see index.php correctly, post a message...)
    - site.sql has been imported into my DB (I can see the table in my db)
    - When I add to my config.php
    Status_network::setupDB('localhost', 'statusnet3', 'root');
    if (!Status_network::setupSite($_server, $_path)) {
    print "Error\n";
    exit(1);
    }

    The connexion to the DB is ok but I've got this :

    Status_network: databaseStructure: Cant find database schema: statusnet3/status_network
    in links file data: Array
    (
    [statusnet3] => Array
    (
    )

    )

    Status_network: ERROR: Unable to load schema for database and table (turn debugging up to 5 for full error message)
    DB_DataObject Error: Unable to load schema for database and table (turn debugging up to 5 for full error message) Status_network: 1: Clearing Cache for status_network

    What can I do?
  • How to install a multi-site instance of StatusNet :

    A.Create the "father" instance of SN :
    1)download and unzip statusnet
    2)create a database and user
    3)import the site.sql to the database in order to build the necessaries tables
    4)hack the config.php as it's said on the wiki status_network by replacing the created one with :

    Status_network::setupDB('localhost', 'statusnet', 'statuspass', 'statusnet');
    if (!Status_network::setupSite($_server, $_path,)) {
    print "Error\n";
    exit(1);
    }

    B)Create the children instances (reel sites) :
    1) configure the /scripts/setup.cfg
    2) launch setup_status_network.sh with the good parameters (like the example in the script)

    At this state, the multi-site is working but I have 2 last issues :
    - the path for avatar,file and background point to the "father" folder instead of "children" ones.
    - the search engine doesn't work (Is it normal that the setup_status_network.sh launch innodb.sql while install.php did not? )
  • @ndox you should append /'.$sn->nickname; to your avatar/file/background paths in your config.php that will probably fix it up the way you expect.

    What kind of errors are you getting with the search engine? (afaik innodb is the default structure that we use now, the fact that innodb.sql it's called by setup_status_network may be a redundant legacy issue)
  • I've got this error :
    The database for le microblog de losc1 isn't responding correctly, so the site won't work properly. The site admins probably know about the problem, but you can contact them at root@localhost to make sure. Otherwise, wait a few minutes and try again.

    When I try to execute manually the last sql command, I've got that :

    mysql> show profile;
    Empty set (0.00 sec)

    mysql> SELECT *
    -> FROM profile
    -> WHERE ( MATCH(nickname, fullname, location, bio, homepage) AGAINST ('test' IN BOOLEAN MODE) )
    -> ORDER BY created desc ;
    ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes
  • @ndox add to your config.php
    $config['search ']['type'] = like;
  • @jordanc ok for the nicknames.
    Ok for the search error. But I was asking myself if it's not better to use MyISAM in order to use full text search?

    thx for your help
  • @ndox depends on the volume you expect to have on your site, full text search can really bog it down. If you're expecting high volume you probably want to use something like sphinx to handle indexing and searches.
  • @jordanc Ok I will think about.

    thx again
  • Has anyone else implemented multi-site the way ndox suggests? It doesn't look like root privileges are really required, so maybe this would work with a shared host like DreamHost. I'll be happy to try what's here but only if there is reasonable chance of success in a shared environment. Thanks!
  • BTW, thanks ndox for your contribution!
  • Not sure anyone has noticed, but ./classes/Status_network.php has changed in 0.97. The pre-made calls in config.php are no longer correct, because Status_network::setupDB() now take 5 args and Status_network::setupSite() now takes 3 args.

    Is there a place to get an updated example?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Google Sign In with OpenID