Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: eiceic on February 12, 2005, 02:45:27 PM

Title: Software that runs this site
Post by: eiceic on February 12, 2005, 02:45:27 PM

What is the software that runs this site and allows the forums/etc?

Is there an FAQ for setting it up on SME?  

Thanks,

Chris Buechler

Title: Software that runs this site
Post by: crazybob on February 12, 2005, 03:06:00 PM

The software is xoops, at least that is what it says at the bottom of the page, and yes there is a how to here, just search for it.

Bob

Title: MySQL Rights
Post by: eiceic on February 13, 2005, 02:05:20 AM

The howto says this...

1. Create a mysql user with the access rights to create,modify, and delete mysql dbases. The best tool to do this with is phpmyadmin (see Darrell May's contrib area).

The phpmyadmin offers these options for privileges - can someone tell me specifically which ones xoops needs at a minimum..

 Global privileges
Note: MySQL privilege names are expressed in English
Check All     Uncheck All
 Data      Structure      Administration
   SELECT       CREATE       GRANT
   INSERT       ALTER       PROCESS
   UPDATE       INDEX       RELOAD
   DELETE       DROP       SHUTDOWN
   FILE            REFERENCES

Title: Software that runs this site
Post by: crazybob on February 13, 2005, 02:10:19 AM

I think all you need is create, alter, and delete.

Bob

Title: I need an answer to this one as well
Post by: drywalldude on February 13, 2005, 01:40:18 PM

I didn't have any problem installing and it runs quite well on the contribs server. But obviously I have to many privaleges to my "xoops user" and I'm sure this is a potential security risk, I will start by closing some until it breaks and then reopen untill it works again. Although I am surprised the xoops doc was not more specific. http://www.ericswww.com/rpm_bay/screenshots/xoops_user.PNG

Title: Xoops
Post by: eiceic on February 13, 2005, 02:20:08 PM

Ok -- I installed Xoops without any problem - worked great..  I'm now trying to decide between Xoops & Mambo for my website.  They both seem up to the task.  Does anyone have feedback before I commit

Here's a great site I found for comparing/testing all the CMS Portals:   http://www.opensourcecms.com/

Thanks,

Chris Buechler

Title: Software that runs this site
Post by: gizzmo2k1 on April 01, 2005, 07:34:57 PM

Just my two cents, but I much preferred Mambo and am now using this on my site.  I would, however, be interested in a howto on loading Mambo onto SME 6.5 RC1.  Right now I am running my website on Mandrake 10.1.  Any help would be appreciated.  Thanks

Title: Installing Mambo on SME
Post by: pdupreez on April 03, 2005, 05:02:18 PM

I am running SME Custom (sort of a 6.1 with add-ons), and installing Mambo on that was really easy. I downloaded the latest version from http://mamboforge.net/frs/download.php/4004/MamboV4.5.2-Stable.tar.gz , extracted it into my Primary/html directory manually (using Midnight Commander).

I then opened a web browser on another machine, fixed the access errors on the installation page (specifically the security levels on the directories), ignored the unwritable configuration.php and proceeded with the installation.

I had to select the text on the last page and pasted it into a new configuration.php I created in Primary/html, chmod to 664, and saved the file.

I tried with SFE active, but that did not work, and I switched it off afterwards again. That is it, done!

Hope it helps!

Title: Software that runs this site
Post by: boss_hog on April 03, 2005, 05:53:22 PM

Hey Yall,
I will pass on the "which is better CMS". I have a site using Xoops and one using phpWebsite. To each their own, if it works for your needs, then it is the best.

As for the MySQL databases that is needed for Xoops.
Here is my settings:

SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES.

These settings are only for the "Xoops DB user", they are not GLOBAL. I have a GLOBAL user set up just for backing up the DB's.

I read somewhere about minimizing privileges to keep security tight, sorry I don't have the link.
Hope this helps.
Joe