Topic: Zope / Amphora

[guestFF]

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

[Chaloner Hale]

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

[guestFF]

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

[Darrell May]

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

[Dan Brown]

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

[Gavin Jackson]

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

[Rob Hillis]

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.

[Dan Brown]

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.

[Gavin Jackson]

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

[Filippo Carletti]

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).

[Rich Lafferty]

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