Koozali.org: home of the SME Server

[Announce] Horde 3.1.x RPM's

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Horde Groupware Full Suite
« Reply #45 on: January 04, 2007, 09:56:09 PM »
Quote from: "Agent86"
...Yes I agree this would make SME very appealing even to the new user

Got my vote for full Horde Groupware Webmail Suite

Thanks for the help I'll get those RPM's installed tonight and see how it goes

I need to research the various methods of installing / upgrading etc.
Anyway possible to put this on the SME CD I have and simply select upgrade from the CD ?
I would like to be able to do this via yum in the server-manager, but if thats not possible then I'll use ssh to the konsole etc.

Thanks again I'm looking forward to playing with it tonight


P.S
Would be nice to have a signup page for people to enroll in my horde email service, then I would not have to do it manually.
I have no idea how this may be accomplished but would be nice


There is no repo setup for these files.  You need to download them, then do yum localinstall *.rpm.  

I'm pretty sure you can have a signup page.  Do - config setprop horde Administration enabled ; signal-event email-update
then login to horde as admin and look at the horde setup screen and make the appropriate changes.  Click save or generate config, you will get an error that you can't save, but you will be able to see what additions you need to make in your custom templates.

John
......

Offline calisun

  • *
  • 601
  • +0/-0
[Announce] Horde 3.1.x RPM's
« Reply #46 on: January 06, 2007, 01:46:26 AM »
John
What do you recomment?,
If I have SME 7.0 and want to udate to 7.1
Should I upgrade first than install your RPM's, or your RPM's first than upgrade to 7.1, or does it make a difference what order.
SME user and community member since 2005.
Want to install Wordpress in iBay of SME Server?
See my step-by-step How-To wiki here:
http://wiki.contribs.org/Wordpress_Multisite

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
[Announce] Horde 3.1.x RPM's
« Reply #47 on: January 06, 2007, 02:28:36 AM »
Quote from: "calisun"
John
What do you recomment?,
If I have SME 7.0 and want to udate to 7.1
Should I upgrade first than install your RPM's, or your RPM's first than upgrade to 7.1, or does it make a difference what order.


If you upgrade to 7.1, you will automatically upgrade horde, imp, turba, and ingo.  Each of those rpm's has an obsolete section for the specific smeserver-menuarray rpm.  

Then, I'd upgrade the other add-ons.  If you are going to run Kronolith, then you need to make sure the additional pear modules are installed as well.

FWIW, in my testing, I tested both ways, and didn't have any issues, but again, that was on a test server.

John
......

Offline Agent86

  • ****
  • 592
  • +0/-0
    • http://www.iclbiz.com
Trean
« Reply #48 on: January 07, 2007, 06:09:00 PM »
Can someone please post a screenshot of Trean bookmarks in action

And also the sidebar for fox with Trean if anyone has a screenshot of this working also

Thanks
Steve

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Trean
« Reply #49 on: January 07, 2007, 06:21:12 PM »
Quote from: "Agent86"
Can someone please post a screenshot of Trean bookmarks in action

And also the sidebar for fox with Trean if anyone has a screenshot of this working also

Thanks
Steve


Really not much to see.  Click on the heart, add a bookmark.  Here is something I just did on one of my test servers.
http://www.thebennetthome.com/downloads/sme7/trean.gif

JB
......

Offline Agent86

  • ****
  • 592
  • +0/-0
    • http://www.iclbiz.com
Bookmarks Thanks
« Reply #50 on: January 08, 2007, 05:12:33 AM »
Hi and thanks for that bookmarks screenshot.

Regarding installation of the RPMs
In my case: NagMnemo,Kronolith,and Gollem RPM's-base and RPM's-esmith

If I wget the rpms does it matter which directory I'm in when I  download etc. or is there a specific directory I should put them in prior to installing them?

Regarding signal-event post upgrade and signal-event reboot; I assume I need to either type the command below  exact from root or be in the /e-smith directory either way ?

/sbin/e-smith/signal-event post-upgrade
/sbin/e-smith/signal-event reboot

Please confirm
Thanks

PS.
In addition can I install the RPM's and signal a post-upgrade and event reboot in the server manager somehow ?

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Bookmarks Thanks
« Reply #51 on: January 08, 2007, 08:09:25 PM »
Quote from: "Agent86"
Hi and thanks for that bookmarks screenshot.

Regarding installation of the RPMs
In my case: NagMnemo,Kronolith,and Gollem RPM's-base and RPM's-esmith

If I wget the rpms does it matter which directory I'm in when I  download etc. or is there a specific directory I should put them in prior to installing them?

Regarding signal-event post upgrade and signal-event reboot; I assume I need to either type the command below  exact from root or be in the /e-smith directory either way ?

/sbin/e-smith/signal-event post-upgrade
/sbin/e-smith/signal-event reboot

Please confirm
Thanks

PS.
In addition can I install the RPM's and signal a post-upgrade and event reboot in the server manager somehow ?


No, it doesn't matter what directory you are in.  Typically, I ssh to the server, create a temp directory, download the rpm's to that directory, then install them.  yum localinstall *.rpm, then post-upgrade and reboot.  There is no panel which you can use to install the rpms, you can do a reconfigure and reboot from the server-manager backup panel.

JB
......

Offline Agent86

  • ****
  • 592
  • +0/-0
    • http://www.iclbiz.com
RPM's Thanks
« Reply #52 on: January 08, 2007, 10:51:13 PM »
That helps thanks

I sort of thought thats what the reconfig and reboot from the server-manager would do, but wanted to make sure

Thanks
Steve

Offline Agent86

  • ****
  • 592
  • +0/-0
    • http://www.iclbiz.com
Thanks it works perfect Tasks,Notes,Calendar Etc.
« Reply #53 on: January 09, 2007, 12:39:20 AM »
Thanks alot it was a lot easier then I thought and it worked perfectly all  features appear to be working and functional.

Thanks again

Offline machoboy

  • 4
  • +0/-0
[Announce] Horde 3.1.x RPM's
« Reply #54 on: January 26, 2007, 11:53:46 PM »
Hi,

I have installed all rpm with yum localinstall and did a postupgrade and reboot.

For Calendar and Tasks I have the following error :
DB Error: insufficient permissions
I have a blank page when I try to see the bookmarks page...

This is what I have in my logs :

Jan 27 00:00:18 XXXX HORDE[4374]: [trean] DB Error: insufficient permissions: UPDATE horde_datatree_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1142 ** UPDATE command denied to user 'horde'@'localhost' for table 'horde_datatree_seq'] [on line 454 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Jan 27 00:00:18 XXXX HORDE[4374]: PHP Warning:  Illegal offset type in /home/httpd/html/horde/trean/lib/Bookmarks.php on line 77
Jan 27 00:00:18 XXXX HORDE[4374]: PHP Warning:  Illegal offset type in /home/httpd/html/horde/trean/lib/Bookmarks.php on line 78
Jan 27 00:00:18 XXXX HORDE[4374]: PHP Warning:  Illegal offset type in /home/httpd/html/horde/trean/lib/Bookmarks.php on line 79
Jan 27 00:00:18 XXXX HORDE[4374]: PHP Warning:  Illegal offset type in /home/httpd/html/horde/trean/lib/Bookmarks.php on line 80
Jan 27 00:00:18 XXXX HORDE[4374]: PHP Fatal error:  Call to a member function on a non-object in /home/httpd/html/horde/trean/lib/Bookmarks.php on line 80

Jan 27 00:02:57 XXXX HORDE[4037]: [kronolith] DB Error: insufficient permissions: UPDATE horde_datatree_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1142 ** UPDATE command denied to user 'horde'@'localhost' for table 'horde_datatree_seq'] [on line 454 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Jan 27 00:02:57 XXXX HORDE[4037]: [kronolith] DB Error: insufficient permissions: UPDATE horde_datatree_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1142 ** UPDATE command denied to user 'horde'@'localhost' for table 'horde_datatree_seq'] [on line 454 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Jan 27 00:02:57 XXXX HORDE[4037]: [kronolith] DB Error: insufficient permissions: UPDATE horde_datatree_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1142 ** UPDATE command denied to user 'horde'@'localhost' for table 'horde_datatree_seq'] [on line 454 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Jan 27 00:02:57 XXXX HORDE[4037]: [kronolith] DB Error: insufficient permissions: SELECT event_id, event_uid, event_description, event_location, event_status, event_attendees, event_keywords, event_title, event_category, event_recurtype, event_recurenddate, event_recurinterval, event_recurdays, event_start, event_end, event_alarm, event_modified, event_exceptions, event_creator_id FROM kronolith_events WHERE calendar_id = 'nico@guilbert.name' AND ((event_end > '2006-12-31 00:00:00' AND event_start < '2007-02-05 00:00:00') OR (ev
Jan 27 00:02:58 XXXX HORDE[4037]: [kronolith] DB Error: insufficient permissions: UPDATE horde_datatree_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1142 ** UPDATE command denied to user 'horde'@'localhost' for table 'horde_datatree_seq'] [on line 454 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Jan 27 00:02:58 XXXX HORDE[4037]: [kronolith] DB Error: insufficient permissions: UPDATE horde_datatree_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1142 ** UPDATE command denied to user 'horde'@'localhost' for table 'horde_datatree_seq'] [on line 454 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Jan 27 00:02:58 XXXX HORDE[4037]: [kronolith] DB Error: insufficient permissions: UPDATE horde_datatree_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1142 ** UPDATE command denied to user 'horde'@'localhost' for table 'horde_datatree_seq'] [on line 454 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]


My installation is based on SME 7.1, is this a known problem ?

Thanks

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
[Announce] Horde 3.1.x RPM's
« Reply #55 on: January 27, 2007, 01:29:15 AM »
No, there are no more known problems that I know of.  I install these as well.  Did you check/verify the md5sums?  Look at /var/log/messages and look at the various mysql.init events and see if you have any errors.  Is this a fresh 7.1 install or an upgrade?  Were any previous scripts or contribs install on the server?

JB
......

Offline calisun

  • *
  • 601
  • +0/-0
[Announce] Horde 3.1.x RPM's
« Reply #56 on: February 02, 2007, 12:51:56 AM »
Hi JB
I have installed your latest rpm's and just like before, as we have discussed  it before here: http://forums.contribs.org/index.php?topic=31018.0

I am unable to connect to file manager if my ftp settings are set to:
FTP access: Allow only from local networks
FTP password access: Accept passwords only from local networks

Only way I can access file manager is one of two ways:
1) Set FTP access AND password to allow from entire internet
or
2) Change settings as you have described in the post from attached link.
     in backends.php
     'hostspec' => 'localhost',

Nether one of these is ideal since #1 is not secure and #2 is only temporary.
SME user and community member since 2005.
Want to install Wordpress in iBay of SME Server?
See my step-by-step How-To wiki here:
http://wiki.contribs.org/Wordpress_Multisite

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
[Announce] Horde 3.1.x RPM's
« Reply #57 on: February 02, 2007, 05:54:03 AM »
Quote from: "calisun"
Hi JB
I have installed your latest rpm's and just like before, as we have discussed  it before here: http://forums.contribs.org/index.php?topic=31018.0

I am unable to connect to file manager if my ftp settings are set to:
FTP access: Allow only from local networks
FTP password access: Accept passwords only from local networks

Only way I can access file manager is one of two ways:
1) Set FTP access AND password to allow from entire internet
or
2) Change settings as you have described in the post from attached link.
     in backends.php
     'hostspec' => 'localhost',

Nether one of these is ideal since #1 is not secure and #2 is only temporary.


I stated back in that thread that I would change it, just never did.  Look for -12 on the mirrors soon.  Please next time raise a bug in the bug tracker, there is an item for all of the horde add-ons.  I did not get an email that you have posted back to this thread, so just lucky I was looking around tonight.  Also, you could create a custom-template of 100LocalFTP and set whatever you like and the settings would not be temporary.

JB
......

Offline calisun

  • *
  • 601
  • +0/-0
[Announce] Horde 3.1.x RPM's
« Reply #58 on: February 02, 2007, 05:41:50 PM »
Thanks John, I will check often for -12 release.

PS. I heard that you will be in San Francisco for vacation this month.
If you need a guide in San Francisco on your vacation, let me know, I live 20 minute drive from SF.
My wife likes to go to SF to play a tourist for a day.
SME user and community member since 2005.
Want to install Wordpress in iBay of SME Server?
See my step-by-step How-To wiki here:
http://wiki.contribs.org/Wordpress_Multisite

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
[Announce] Horde 3.1.x RPM's
« Reply #59 on: February 03, 2007, 02:12:21 AM »
Quote from: "calisun"
Thanks John, I will check often for -12 release.

PS. I heard that you will be in San Francisco for vacation this month.
If you need a guide in San Francisco on your vacation, let me know, I live 20 minute drive from SF.
My wife likes to go to SF to play a tourist for a day.


Thanks for the offer.  I will be in SF with my inlaws.  They live in the area and pretty much keep the family on the go.  I will try to remember that for the future.  I'd sure like to meet some of the other folks that use this distro.

JB
......