Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: guestFF on December 10, 2001, 07:50:12 PM

Title: Zope / Amphora
Post by: guestFF on December 10, 2001, 07:50:12 PM

Hi all,

I like to experiment with zope on a SMEv5 box.

I saw a thread about getting the correct RPM's (http://forums.contribs.org/index.php?topic=11853.msg44575#msg44575)

Installed it and it workes. (except for the expat rpm wich had to be installed separately).

Now I would like to 'play' with Amphora (http://www.amphora.ee/freeware/)
but it requires a lot of packages wich are not on SMEv5

See: http://www.amphora.ee/freeware/INSTALL

Did anybody play with it before or made any atempts...?

Any suggestion, recommendation (or How-To) is welcome.

Thanks and regards,

RequestedDeletion

Title: Re: Zope / Amphora
Post by: Chaloner Hale on December 10, 2001, 09:06:55 PM

I would like to try Zope as well on SME V5. Could you please let me know which version you installed, and which expat uou installed.

Thanks,

Chaloner Hale

Title: Re: Zope / Amphora
Post by: guestFF on December 11, 2001, 01:24:21 AM

Hi Chaloner,

I installed the RPM's mentioned in my previuous mail. Expat I took from a RPMfind.net at http://www.rpmfind.net//linux/RPM/redhat/7.2/i386/expat-1.95.1-7.i386.html

HFW

Title: Re: Zope / Amphora
Post by: Darrell May on December 11, 2001, 03:54:05 AM

guestFF wrote:
> Now I would like to 'play' with Amphora
> (http://www.amphora.ee/freeware/)
> but it requires a lot of packages wich are not on SMEv5

I believe it requires postgresql which would not be a good fit for SME since mySQL is the installed database.  Try twiggi:

http://sourceforge.net/projects/twiggi/

Regards,

Darrell

Title: Re: Zope / Amphora
Post by: Dan Brown on December 11, 2001, 04:04:28 AM

Darrell, why should MySQL being installed cause a problem with postgres?  AFAIK, the two can coexist quite well.

Title: Re: Zope / Amphora
Post by: Gavin Jackson on December 11, 2001, 05:03:40 AM

Guys,
         Could I be so bold to suggest  that SME 5.1 should have postgresql as a second database type that is installed by default. It appears to be nearly as popular as mysql by my reckoning

Food for thought

Regards,
Gavin

Title: Re: Zope / Amphora
Post by: Rob Hillis on December 11, 2001, 05:31:21 AM

Gavin Jackson wrote:

>          Could I be so bold to suggest  that SME 5.1 should
> have postgresql as a second database type that is installed
> by default. It appears to be nearly as popular as mysql by my
> reckoning

I'd disagree with this... if you do this, you end up with "bloatware" - and possibly *lots* of unnecessary services creating a security risk.

MySQL is installed on SME as it is required by IMP.  That's the only reason it's there.  If you want it, by all means install it yourself.

I personally don't want two database servers on my server, when one (that does everything I need) is just fine.

Title: Re: Zope / Amphora
Post by: Dan Brown on December 11, 2001, 05:45:47 AM

Actually, MySQL is _not_ required by IMP--some database is, but it could just as well be Postgres.  I'd still disagree with adding it as part of the distro, though.

Title: Re: Zope / Amphora
Post by: Gavin Jackson on December 11, 2001, 06:06:09 AM

The reason for the question in the first place is that postgres supports stored procedures, That are a personal requirement, and Mysql doesn't.

I was more concerned about having to cut modules to add additional user accounts and the upgrade ramifications that are involved.

It appears that more users of SME are requiring postgres than I had noticed previously and I noticed only 3 question asked about it in a search of the site.
None seemed to give a definitive answer about a recommended procedure for installing it and no resolutions appeared to have been found in the search.


Please feel free to disregard my suggestion.

Regards,
Gavin

Title: Re: Zope / Amphora
Post by: Filippo Carletti on December 11, 2001, 04:46:49 PM

Dan Brown wrote:
>
> Actually, MySQL is _not_ required by IMP--some database is,
> but it could just as well be Postgres.  I'd still disagree
> with adding it as part of the distro, though.

IMP needs a db only for Contacts. Sessions could be stored elsewhere even if it's common to use a db.

I too disagree on having two rdbms on the base install.
Any db could be added later and often there is no need to have more than one (especially now that both PEAR and ADODB are beginning to be used).

Title: Re: Zope / Amphora
Post by: Rich Lafferty on December 11, 2001, 07:48:22 PM

IMP needs a db for contacts, preferences, and sessions.
While it's *technically* possible to store sessions in shared
memory, it's sort of a "gray area" with IMP, as it's not
used very heavily, none of the core developers use shared
memory sessions themselves, and there's not a huge body of
knowledge on the mailing lists in terms of configuring and
debugging it.

It's essentially a PHPlib feature that wasn't explicitly
taken *out* of Horde's modified PHPlib, but it's still
essentially deprecated.

For practical purposes, IMP 2.2.x /does/ need a database for
sessions.

-Rich