Topic: Kronolith RPM mebbe?

[Ben Morrisson]

Hi all,

Noticed some of you were keen on getting a Kronolith RPM going?

This is a minimal build of Kronolith 1.0 with the minimum requirements needed to
stop SME overwriting the horde config etc.

It contains custom conf for SME 5.5 running Horde 2.1-1. Install and run
should pick up your SQL password automatically.

This is alpha software!! I make no promises!! DO NOT!! Let me say it again
DO NOT install on a production system until you fully test it. Please let me know any feedback you have - I have only installed on 5.5. but should work on any
versions 4.1.2 and above provided all updates - PHP - HORDE IMP ETC
have been done to bring it up to the latest versions - NO RESPONSIBILTY
OR LIABILITY IS ACCEPTED!!

Thanks to DAN for IMP upgrades!!

Will gradually improve RPM with full template support but for now this should get you going. The RPM is rough cause I didn't have much time.

Anyway hope this helps someone.
cheers
Ben Morrisson

Oh yeah : ) you can get it at http://staff.interworx.com.au/sme/
B.

[Dan Brown]

Well, I downloaded and installed it on my 5.1.2 production box; here's what happened:

[root@e-smith home]# rpm -Uvh e-smith-kronolith-1.0-01.noarch.rpm
Preparing...                ########################################### [100%]
   1:e-smith-kronolith      ########################################### [100%]
Bareword found where operator expected at -e line 1, near "s/KRPWD/[long string that looks a lot like my mysql root password]"
syntax error at -e line 1, near "s/KRPWD/[long string that looks a lot like my mysql root password]"
Search pattern not terminated at -e line 1.

Trying to access kronolith, I get this:

DB Error: connect failed

[line 65 of /home/httpd/html/horde/kronolith/lib/Driver/sql.php]

Details have been logged for the administrator.

nothing in error_log, though.  It was simple to fix, though; I just changed /home/httpd/html/horde/kronolith/config/conf.php to reflect the correct horde user and password.  With that fixed, it seems to work fine as far as I can see at the moment.

    Looks like none of the kronolith config files are templated; you've just added a template fragment to the horde registry.

A few suggestions:

*    Make the .src.rpm file available.  This is required by the GPL anyway, and it'll make it easier for others to track down problems and/or offer improvements.

*  Put template fragments in /templates/, not in /templates-custom/.  templates-custom is intended only for local customizations.

*  From what I can tell from the error message above, you're telling kronolith to use the mysql root user.  Really bad idea, for reasons I covered in my HOWTO.  Use the horde user instead, with the default horde password (this is the same in 5.5 as in my contribs for 5.1.2, I believe).

*  Break this out into 2 RPMs, as Mitel does (and I do)--one for Kronolith itself, and one for the templates and other customizations.  The Kronolith RPM can be almost identical to the one at horde.org, just placing the content in /home/httpd instead of /var/www and a couple of other minor changes (you should be able to do this by just changing a couple of the defines at the top of the .spec file if Brent's still building them the way I suggested).  The e-smith-kronolith RPM is where you'd put all the template fragments.  Tag the release number of that one with your initials (i.e., e-smith-kronolith-1.0-02bm.noarch.rpm or some such).

*  Add a template fragment to /home/httpd/html/horde/imp/config/conf.php to give a link for Kronolith from inside IMP (this should be fairly easy with 5.5, but won't be as simple with 5.1.2 and the crappy way I broke up the template).  Do the same for turba., and add these two to the kronolith conf.php file as well.

    Thanks for taking the time to put this together!  I've been meaning to do it for some time, but hadn't gotten around to it.

[John]

You know the differences between 5.1.2, 5.5 and the latest 5.6 really should be considered MAJOR upgrades.  Most things are not compatible with each other.

It's hard to develop for SO many different product lines.

It's really irritating.  But Microsoft has been doing this with their Windows line for years, so I guess it's ok for Mitel to be doing it too.  If they want to get as big as Microsoft, then maybe that's their plan.  Force everyone to keep upgrading.

[Ben Morrisson]

Yeap had planned to do this . . .
This was a very rough and ready first effort to complete a job I was doing. : )
Won't publish the source till I make a more respectable effort of it - its very blah - just wanted to see what was possible - will do something better and put that up

Dan - Thanks heaps for this advice !!! i.e where templates go, naming etc!
Remembered reading something of this somewhere was unable to find the exact thing again.

Was aware of the horde user but couldn't determine where and how to find the password for it? Can you give me a clue.

Also got the syntax error on one of my other test machines - Its caused by the '/' in the password due to the perl search and replace used to add the password  to the conf file. Ironically my test machine was the only machine to have no '/' in the encrypted password. (go figure)

Anyway will work on this some more. Would be great if you could look the src over when I am finished?

Thanks again for the response!
Cheers
Ben

[Dan Brown]

To get the password for the horde user, just take a look at the horde config files.  Unlike the root password, it's the same from machine to machine.

I'd be glad to take a look at the source when I get some time.