Home arrow Forum Install SMF on different database than Joomla
  Welcome, Guest. Please login or register.
Did you miss your activation email?
December 05, 2008, 12:46:25 PM
Home New Posts Search Calendar


Login with username, password and session length
+  Joomla Forum
|-+  Joomla Hacks
| |-+  Joomla-SMF Forum Support
| | |-+  Joomla-SMF 2.0.x (Moderators: -Wolverine, kai920)
| | | |-+  Install SMF on different database than Joomla
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] 2 Go Down Print
Author Topic: Install SMF on different database than Joomla  (Read 3159 times)
downatone
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 4


View Profile
Install SMF on different database than Joomla
« on: October 23, 2006, 09:44:31 AM »

Well subject basically says it all. My smf is installed on a different db than my joomla installation. When I look at the "Joomla-SMF Forum Installation" under components->joomla-smf forum->install I can't see a way around installing if on different dbs. Any ideas?
Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +376/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: Install SMF on different database than Joomla
« Reply #1 on: October 23, 2006, 09:46:27 AM »

this bridge does not support that configuration.  Please review the user guide for more information on how to configure J!, SMF, and JSMF together.
Logged

Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
downatone
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 4


View Profile
Re: Install SMF on different database than Joomla
« Reply #2 on: October 23, 2006, 09:56:19 AM »

Thanks for the quick reply -- I'm assuming future ones will?
I'll wait until then...
Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +376/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: Install SMF on different database than Joomla
« Reply #3 on: October 23, 2006, 10:42:06 AM »

no firm plans for this functionality at this point.  It has been discussed... but it is a major change.  We will see.
Logged

Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
downatone
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 4


View Profile
Re: Install SMF on different database than Joomla
« Reply #4 on: October 23, 2006, 10:54:14 AM »

Not to bash the assumption - but it seems pretty limited to assume the forum is on the same db as joomla...in your experience - has this not limited your user niche?
Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +376/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: Install SMF on different database than Joomla
« Reply #5 on: October 23, 2006, 11:30:56 AM »

No, it has not in my experience.  Only a handful of users have reported or requested this.  This bridge caters more to integration with other joomla components and as such everything is in one database.  Furthermore, in my experience I haven't ever found a good reason that these databases should be separate.  Imagine the overhead in using two databases on heavily used sites.  It simply doesn't make sense.  Sure you can pull the upgradability and backup card, but if you are good enough with MySQL to be running two databases for one site then you must be good enough to use other means for backing up your systems.

I don't know, thats my opinion.  There have been requests, but the amount of overhead it would create really isn't worth it at this time.  It may happen with J! 1.5 if I can use the Joomla database object to handle separate DSN's.  But the work involved will probably mean that I won't have time to do it. 

Orstio's bridge handles that... so that is your other option.  I hope that explains things better for you.
Logged

Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
downatone
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 4


View Profile
Re: Install SMF on different database than Joomla
« Reply #6 on: October 23, 2006, 11:35:26 AM »

Fair enough - every coin has 2 sides ... I can appreciate that Smiley
Logged
Brat
Developer
Joomla Pro
*****

Karma: +11/-0
Offline Offline

Posts: 52


View Profile
Re: Install SMF on different database than Joomla
« Reply #7 on: October 25, 2006, 08:17:37 PM »

Fair enough - every coin has 2 sides ... I can appreciate that Smiley

For whatever it's worth...

If you really, truly want SMF on a different database (and there is a valid reason for this need for some webmasters), the so-called "official" bridge by Ortisio is designed to support that. Please bear in mind that, as Wolverine said, the J-bridge is designed for tight integration with CB and other Joomla extensions - meaning, stuff is best left on the same DB to better ensure things function well.

Ortisio's bridge is not so tightly integrated, but to the team's credit it wasn't designed specifically to be. However, it does play well with CB, and for some site owners that's sufficient integration for their needs.

In any case, first determine what's really important to you, and then implement the best solution to fit your needs.  Wink

Regards,
Brat.
Logged
McGrelio
Joomla Newbie
*

Karma: +2/-1
Offline Offline

Posts: 25



View Profile WWW
Re: Install SMF on different database than Joomla
« Reply #8 on: November 04, 2006, 08:00:12 AM »

I've ehard that having different DB for different scripts can increase performances.
I'd like to see this feature in the future releases of JSMF.

And now an off topic question (related in some way).

- Is it possible to install use JSMF having Joomla and SMF on different subdomains (on the same server of course)?

And a less demanding one:
- is it possible to have SMF installed outside the Joomla root?

I think these topics were discussed but i can't find a valid answer for JSMF2.

Thx!
Logged

Cya Wink

____________________________________________

Joomla 1.0.11 UTF-8
SMF 1.1 RC3 UTF-8
JSMF 2.0 RC2
CB 1.0.1
Gallery 2.1.2 (bridged)

MySql 5.0.24a
PHP 4.4.2
Apache 2.0.54
Livebox
Guest
Re: Install SMF on different database than Joomla
« Reply #9 on: November 04, 2006, 03:12:04 PM »

The Dev’s are working @ it. that you can install Joomla and SMF in Separate databases
Logged
p9939068
Joomla Expert
****

Karma: +18/-5
Offline Offline

Posts: 173


View Profile WWW
Re: Install SMF on different database than Joomla
« Reply #10 on: November 05, 2006, 02:27:54 AM »

I've ehard that having different DB for different scripts can increase performances.
I'd like to see this feature in the future releases of JSMF.

And now an off topic question (related in some way).

- Is it possible to install use JSMF having Joomla and SMF on different subdomains (on the same server of course)?

And a less demanding one:
- is it possible to have SMF installed outside the Joomla root?

I think these topics were discussed but i can't find a valid answer for JSMF2.

Thx!

Different DB with different scripts doesnt really increase performance all that much unless you have a different DB on a separate DB server.

Yes, you can install and use JSMF with joomla and smf on different subdomains provided both joomla and smf are using the same database, and that your joomla's live site value in the configuration file is set correctly.

What do you mean outside of joomla's root? do you mean that you installed joomla in www.domain.com/joomla and smf in www.domain.com/smf? I'm afraid no, your smf must be in www.domain.com/joomla/smf, but you can still set up a subdomain to point to this url. HOWEVER, you wouldnt want to do that because with the jsmf bridge, you will be accessing your smf forums using the bridge's URL (option=com_smf?blahblahblah), so what you can do is manually specify the redirection url for your subdomain. (eg forums.domain.com redirects to www.domain.com/index.php?option=com_smf)
Logged

-----
Owner of http://mike.simbunch.com
Creator of ParaInvite, AJAX Sandbox, AJAX SMF Polls, Profile URL etc..
McGrelio
Joomla Newbie
*

Karma: +2/-1
Offline Offline

Posts: 25



View Profile WWW
Re: Install SMF on different database than Joomla
« Reply #11 on: November 05, 2006, 05:24:43 AM »

Different DB with different scripts doesnt really increase performance all that much unless you have a different DB on a separate DB server.

Yes, you can install and use JSMF with joomla and smf on different subdomains provided both joomla and smf are using the same database, and that your joomla's live site value in the configuration file is set correctly.

What do you mean outside of joomla's root? do you mean that you installed joomla in www.domain.com/joomla and smf in www.domain.com/smf? I'm afraid no, your smf must be in www.domain.com/joomla/smf, but you can still set up a subdomain to point to this url. HOWEVER, you wouldnt want to do that because with the jsmf bridge, you will be accessing your smf forums using the bridge's URL (option=com_smf?blahblahblah), so what you can do is manually specify the redirection url for your subdomain. (eg forums.domain.com redirects to www.domain.com/index.php?option=com_smf)
Thx a lot, you've explained me very well what i can do and what i cannot.
In my vision Joomla, SMF (and Gallery2) are separated applications which interact through a bridge, so the more they're independent the better it is.  If i want to access my forum directly i can setup a subdomain forum.domain.com pointing to www.domain.com/joomla/smf, but for the administrator point of view it should be better to have different scripts on different directories. Less problems when updating, deleting, etc.
Ok maybe it's more just a sophism, than a real need Smiley
Logged

Cya Wink

____________________________________________

Joomla 1.0.11 UTF-8
SMF 1.1 RC3 UTF-8
JSMF 2.0 RC2
CB 1.0.1
Gallery 2.1.2 (bridged)

MySql 5.0.24a
PHP 4.4.2
Apache 2.0.54
mike
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 2


View Profile
Re: Install SMF on different database than Joomla
« Reply #12 on: November 07, 2006, 05:31:53 AM »

Hi!

 So i don't know much about sql,and i knew even less when i did my Joomla,and SMF installs...So,i have my joomla @ ww w.myspace.de/joomla1
 and forum @ ww w.myspace.de/forums and of course two different DB names (jos,smf)is there a way to correct this now,or am i just out of luck?

 Thanks
 Mike
Logged
p9939068
Joomla Expert
****

Karma: +18/-5
Offline Offline

Posts: 173


View Profile WWW
Re: Install SMF on different database than Joomla
« Reply #13 on: November 07, 2006, 08:22:14 AM »

Hi!

 So i don't know much about sql,and i knew even less when i did my Joomla,and SMF installs...So,i have my joomla @ ww w.myspace.de/joomla1
 and forum @ ww w.myspace.de/forums and of course two different DB names (jos,smf)is there a way to correct this now,or am i just out of luck?

 Thanks
 Mike
Create a new folder "forums" inside www.myspace.de/joomla.
Copy all your files in www.myspace.de/forums into the newly created www.myspace.de/joomla/forums.
Go to phpMyAdmin and export every table in your forums database.
Go to your joomla database and import the tables from your forums database.
Ensure your smf tables have a "smf_" prefix.
Change pathway of the relevant files in the tables smf_settings and smf_themes.
Change your smf configuration in the file forums/Settings.php
Install the bridge.
Logged

-----
Owner of http://mike.simbunch.com
Creator of ParaInvite, AJAX Sandbox, AJAX SMF Polls, Profile URL etc..
mike
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 2


View Profile
Re: Install SMF on different database than Joomla
« Reply #14 on: November 07, 2006, 10:18:17 AM »

Hi!

 Thanks for the tip!I've already figured out that i had to export and import the DB Files and have done so,but i left the forums folder outside the joomla folder,will that not work?Or should i ask why won't that work,because it's not working Lips Sealed
 My site only shows when the forum is wrapped in it?if not i only get the forum and my page won't show up.And the login and bookmarks aren't working either.

 Wow i really screwed things up today  Roll Eyes
Logged
Pages: [1] 2 Go Up Print 
« previous next »
Jump to:  



Login with username, password and session length

Powered by MySQL Powered by PHP Joomla Forum | Powered by SMF 1.1 RC1.
© 2001-2005, Lewis Media. All Rights Reserved.
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!

Joomla Hacks is a Joomla Components, Joomla Modules, Joomla Templates, & Joomla Mambots resource portal. None of the text or images in this public website may be copied without the expressed written consent of the authors. Copyright 2005 by JoomlaHacks.com. Powered by Joomla. All rights reserved.
Terms of Use
Joomla Hacks



Joomla Hacks
German Lang French Lang Italian Lang Spanish Lang Japanese Lang Chinese Lang
Search Contact About Advertise Blogs Topsites Submit News Register Login