Zentyal Forum, Linux Small Business Server

News and Announcements => News and Announcements => Topic started by: javi on February 25, 2009, 06:32:45 pm

Title: ebox-egroupware ready for testing
Post by: javi on February 25, 2009, 06:32:45 pm
We  are pleased to announce the release of a new eBox module that integrates eGroupware into the eBox universe. We are certain that this new module will help many users who are in the need of having a complete groupware  solution plus the bunch of the amazing services already provided by eBox.

Having eGroupware in eBox means that you will take full advantage of all its modules out of the box, bringing to eBox new features such as: calendar sharing, address book, webmail and much more.

We have worked to provide you with a seamless integration of eGroupware and eBox. Thanks to our LDAP backend,  users and groups created in eBox will show up in your eGroupware installation. And of course, the necessary mail infrastructure is also provided by eBox.

We have just uploaded the first beta version to our unstable repository and it's ready to be tested by the community. Give it a shot and let us know what you think about it. A ready-to-go groupware solution is just one "apt-get install"  away on eBox now :)
Title: Re: ebox-egroupware ready for testing
Post by: JAK on February 26, 2009, 03:55:23 pm
Hello

There where two things that I noticed after installing egroupware with "apt-get update && install ebox-egroupware":
1.) when running the egroupware installation test an error is found:

This might take a while, please wait ...
ErrorChecking file-permissions of .././sitemgr/doc for not world writable:
.././sitemgr/doc does not exist !!!


2.) eBox Software Management module has no knowledge that egroupware is installed:
Component     Installed version 
eBox - eGroupware     none

With regards
Jüri Kirch
Title: Re: ebox-egroupware ready for testing
Post by: J. A. Calvo on February 26, 2009, 08:31:35 pm
Quote
1.) when running the egroupware installation test an error is found:

This might take a while, please wait ...
ErrorChecking file-permissions of .././sitemgr/doc for not world writable:
.././sitemgr/doc does not exist !!!

I can't reproduce this. But is eGroupware working? Have you enabled the module?

Quote
2.) eBox Software Management module has no knowledge that egroupware is installed:
Component     Installed version
eBox - eGroupware     none

ebox-software refreshes its cache every night, you can force a refresh executing sudo ebox-software

Regards,

J. A. Calvo
Title: Re: ebox-egroupware ready for testing
Post by: jbenicky on March 04, 2009, 07:45:30 pm
What software is used for groupware? I'm mainly interested in webmail.
Title: Re: ebox-egroupware ready for testing
Post by: J. A. Calvo on March 04, 2009, 08:06:21 pm
The software used is eGroupware 1.4. eGroupware 1.4 comes with a webmail called Felamimail.
Title: Help with ebox-egroupware
Post by: shortbus on March 08, 2009, 11:21:45 pm
I installed ebox-egroupware from the unstable repository. The install went fine and I configured egroupware as I normally would from the /setup/index.php.

egroupware appears to work fine after I set it up but the egroupware add-in in ebox gives an error. "An internal error has ocurred. This is most probably a bug, relevant information can be found in the logs."

Can someone tell me the proper way to install egroupware with ebox-egroupware or direct me to the documentation?

Thanks

Shortbus
Title: Re: ebox-egroupware ready for testing
Post by: J. A. Calvo on March 09, 2009, 08:58:35 am
Hi!

You don't have to configure egroupware as normally, eBox does it for you.

In fact, if you configure it with the traditional method you can create some conflict, specially if you create the users from inside egroupware instead of from the eBox interface.

The only you need to do to have eGroupware working is enabling the module on the "Module status" section. Later you may configure the mail domain from the "eGroupware" menu of eBox or change user permissions.

If you do the things this way and still get the same error you can find the detailed error in /var/log/ebox/ebox.log, and it would be useful if you paste it here.

Hope this helps!

Regards,

J.A. Calvo
Title: Re: ebox-egroupware ready for testing
Post by: shortbus on March 09, 2009, 11:03:58 pm
OK, I did it the proper way. I did a fresh install of ebox and enabled mail and webserver and then enabled egroupware. I still got:

"An internal error has ocurred. This is most probably a bug, relevant information can be found in the logs." when I clicked on eGroupware to configure it. What have I missed?

Here's the tail of the ebox.log it is what was genreated when I clicked the egroupware

# tail -f /var/log/ebox/ebox.log
2009/03/09 17:48:50 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName RetrievalServices does not exist.
2009/03/09 17:49:18 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName DomainTable does not exist.
2009/03/09 17:49:27 DEBUG> CompositeManager.pm:142 EBox::Model::CompositeManager::composite - composite General does not exist.
2009/03/09 17:49:27 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName BadHeadersPolicy does not exist.
2009/03/09 17:49:27 DEBUG> CompositeManager.pm:142 EBox::Model::CompositeManager::composite - composite VDomains does not exist.
2009/03/09 17:49:31 DEBUG> CompositeManager.pm:142 EBox::Model::CompositeManager::composite - composite ObjectPolicy does not exist.
2009/03/09 17:49:31 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName ExternalFilter does not exist.
2009/03/09 17:49:31 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName SMTPAuth does not exist.
2009/03/09 17:49:31 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName SMTPOptions does not exist.
2009/03/09 17:49:31 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName RetrievalServices does not exist.
2009/03/09 17:52:23 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName VMailDomain does not exist.
2009/03/09 17:52:23 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName DefaultApplications does not exist.
2009/03/09 17:52:23 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName PermissionTemplates does not exist.
2009/03/09 17:52:23 ERROR> ModelProvider.pm:243 EBox::Model::ModelProvider::AUTOLOAD - Undefined method isImapEnabled


Now, even though I gave a user name and and password for the egroupware header admin, I am still unable to log in.

(also please note the spelling of occurred)
Title: Re: ebox-egroupware ready for testing
Post by: J. A. Calvo on March 10, 2009, 11:51:42 am
Hi again!

I can't reproduce this on a fresh install and I'm afraid that the information found in your ebox.log is not very useful.

Could you please enable the debug mode on /etc/ebox/99ebox.conf and repeat the same process to get more information about the error?

Thanks for your testing and for the spelling correction :)

Regards,

J.A. Calvo
Title: Re: ebox-egroupware ready for testing
Post by: JAK on March 10, 2009, 01:36:42 pm
Hello

I enabled debug mode in "/etc/ebox/99ebox.conf".
When enabling egroupware and trying to open egroupware module in eBox I get the same error "An internal error has...".

Here is the output of /var/log/ebox/ebox.log:
Quote
Error output:
Command output: .
Exit value: 1
2009/03/10 14:20:41 INFO> Module.pm:155 EBox::Module::save - Restarting service for module: egroupware
2009/03/10 14:21:42 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName VMailDomain does not exist.
2009/03/10 14:21:46 DEBUG> LogFiltering.pm:70 EBox::Events::Model::Watcher::LogFiltering::new - Missing argument: tableInfo
2009/03/10 14:21:46 WARN> Events.pm:623 EBox::Events::__ANON__ - model EBox::Events::Model::Watcher::LogFiltering cannot be instantiated
2009/03/10 14:21:47 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName DefaultApplications does not exis
2009/03/10 14:21:47 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName PermissionTemplates does not exis
2009/03/10 14:21:47 ERROR> ModelProvider.pm:243 EBox::Model::ModelProvider::AUTOLOAD - Undefined method isImapEnabled

With regards
Jüri Kirch
Title: Re: ebox-egroupware ready for testing
Post by: J. A. Calvo on March 10, 2009, 01:50:58 pm
Could you please paste also the previous lines above "Error output:" to see which command is failing?

Regards,

J.A. Calvo
Title: Re: ebox-egroupware ready for testing
Post by: shortbus on March 10, 2009, 02:13:17 pm
I tried it once again, clean install from the ebox install Ubuntu 8.04 LTS iso.

Same error and unable to log into eGroupware header admin even though I gave a user name and password during the ebox-egroupware configuration.

Attached in my entire ebox.log with debugging turned on. I hope this helps.

One thought, what is the proper order to install and then configure ebox and egroupware? Before I tried ebox-egroupware, I tried ebox and installed RoundCube on my test machine, that worked great but I really want the egroupware features. Installing eGroupware normally worked but didn't integrate properly with ebox. ebox-egroupware does not work at all.

Shortbus
Title: Re: ebox-egroupware ready for testing
Post by: JAK on March 10, 2009, 02:38:07 pm
Hello

Here is the output:

Code: [Select]
2009/03/10 14:20:29 INFO> Manager.pm:601 EBox::ServiceModule::Manager::__ANON__ - File /etc/amavis/conf.d/amavisd.conf does not exist. So we won't compute it
2009/03/10 14:20:35 INFO> Global.pm:360 EBox::Global::saveAllModules - Saving config and restarting services: firewall mailfilter egroupware
2009/03/10 14:20:35 INFO> Module.pm:155 EBox::Module::save - Restarting service for module: firewall
2009/03/10 14:20:38 DEBUG> LogFiltering.pm:70 EBox::Events::Model::Watcher::LogFiltering::new - Missing argument: tableInfo
2009/03/10 14:20:38 WARN> Events.pm:623 EBox::Events::__ANON__ - model EBox::Events::Model::Watcher::LogFiltering cannot be instantiated
2009/03/10 14:20:40 INFO> Module.pm:155 EBox::Module::save - Restarting service for module: mailfilter
2009/03/10 14:20:40 ERROR> Sudo.pm:185 EBox::Sudo::_rootError - root command /usr/bin/test -f /var/lib/ebox/tmp//trainSpam failed.
Error output:
Command output: .
Exit value: 1
2009/03/10 14:20:41 INFO> Module.pm:155 EBox::Module::save - Restarting service for module: egroupware
2009/03/10 14:21:42 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName VMailDomain does not exist.
2009/03/10 14:21:46 DEBUG> LogFiltering.pm:70 EBox::Events::Model::Watcher::LogFiltering::new - Missing argument: tableInfo
2009/03/10 14:21:46 WARN> Events.pm:623 EBox::Events::__ANON__ - model EBox::Events::Model::Watcher::LogFiltering cannot be instantiated
2009/03/10 14:21:47 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName DefaultApplications does not exis
2009/03/10 14:21:47 DEBUG> CompositeManager.pm:393 EBox::Model::CompositeManager::_inferModuleFromComposite - compositeName PermissionTemplates does not exis
2009/03/10 14:21:47 ERROR> ModelProvider.pm:243 EBox::Model::ModelProvider::AUTOLOAD - Undefined method isImapEnabled
2009/03/10 14:37:38 DEBUG> LogFiltering.pm:70 EBox::Events::Model::Watcher::LogFiltering::new - Missing argument: tableInfo
2009/03/10 14:37:38 WARN> Events.pm:623 EBox::Events::__ANON__ - model EBox::Events::Model::Watcher::LogFiltering cannot be instantiated
2009/03/10 14:41:58 ERROR> Sudo.pm:185 EBox::Sudo::_rootError - root command test -e /etc/amavis/conf.d/amavisd.conf failed.
Error output:
Command output: .
Exit value: 1
2009/03/10 14:41:58 INFO> Manager.pm:601 EBox::ServiceModule::Manager::__ANON__ - File /etc/amavis/conf.d/amavisd.conf does not exist. So we won't compute it
2009/03/10 14:42:02 INFO> Global.pm:360 EBox::Global::saveAllModules - Saving config and restarting services: firewall mailfilter
2009/03/10 14:42:02 INFO> Module.pm:155 EBox::Module::save - Restarting service for module: firewall
2009/03/10 14:42:05 DEBUG> LogFiltering.pm:70 EBox::Events::Model::Watcher::LogFiltering::new - Missing argument: tableInfo
2009/03/10 14:42:05 WARN> Events.pm:623 EBox::Events::__ANON__ - model EBox::Events::Model::Watcher::LogFiltering cannot be instantiated
2009/03/10 14:42:07 INFO> Module.pm:155 EBox::Module::save - Restarting service for module: mailfilter
2009/03/10 14:42:07 ERROR> Sudo.pm:185 EBox::Sudo::_rootError - root command /usr/bin/test -f /var/lib/ebox/tmp//trainSpam failed.

BR
Jüri Kirch
Title: Re: ebox-egroupware ready for testing
Post by: javi on March 10, 2009, 04:24:33 pm
shortbus,

Would it be possible for you to join #ebox on irc.freenode.net to try track down your issue?
Title: Re: ebox-egroupware ready for testing
Post by: shortbus on March 10, 2009, 05:15:34 pm
Javi,

I looked for you there. Let's make a time...

Shortbus
Title: Re: ebox-egroupware ready for testing
Post by: shortbus on March 11, 2009, 01:05:22 am
Thanks for all your help! Here was the trick for anyone else with the same problem.

You can't install the ebox-egroupware module on ebox stable!

I did a fresh install on Hardy LTS with the unstable repository and eGroupware is installed automatically.
Getting everything to work right was a trick and I still can't customize eGroupware like I can with a normal install but it does work.

I'll tune into the chat more often.

Shortbus
Title: Re: ebox-egroupware ready for testing
Post by: cheesyking on March 18, 2009, 06:52:21 pm
Does anyone else see an advantage to modifying the filemanager in egroupware so that it looks at the users' samba home directories (or somewhere configurable like that) so that egroupware integrates into ebox's file/PDC server roles?

Strikes me that giving users web access to their My Docs (or whatever) would be a nice feature.

I'm an absolute beginner with egroupware so I've no idea how possible that would be...

it looks like the file manager just reads the directory structure of the /var/lib/egroupware/default/files/home/$USER directory each time you click refresh so it's not like samba would have to make an entry in the database for new files or anything.

BTW the egroupware install worked perfectly for me  ;D
Title: Re: ebox-egroupware ready for testing
Post by: J. A. Calvo on March 19, 2009, 04:30:16 pm
Hi chessyking!

Thanks for your suggestion, it will be considered for future versions.

Regards,

J. A. Calvo
Title: Re: ebox-egroupware ready for testing
Post by: jason_xtreme on March 20, 2009, 03:32:35 pm
Has any1 been able to update this to 1.6 version of egroupware once installed? i setup egroupware manually at the office but im looking to do the same setup for some1 else would be nice to have egroupware 1.6 integrated into the full system.
Title: Re: ebox-egroupware ready for testing
Post by: newuser44 on March 21, 2009, 03:14:29 am
This is great news!

I was trying to get ebox and egroupware to work together before, but had problems with ldap.

I guess I missed this announcement, so I'm really looking forward to trying this new module out.

Are there any plans to make this module available for Intrepid?
Title: Re: ebox-egroupware ready for testing
Post by: J. A. Calvo on March 21, 2009, 03:18:00 pm
Yes, we hope to have all the eBox 1.0 modules available for Intrepid soon.
Title: Re: ebox-egroupware ready for testing
Post by: JAK on March 26, 2009, 10:28:43 am
Hello

I can report that the upgrade from eBox 0.12.3 to 1.0 went well and as you might imagine it also resolved the eGroupware module error problem that I was having.

But now I'm puzzled with a question how to reset the eGroupware admin password for access at
"http://localserver/egroupware/setup" ?
I tried:
Code: [Select]
sudo dpkg-reconfigure ebox-egroupwareBut that seemed to restart a few eBox modules and did not ask for the administrative account credentials as it was on the first time when installing ebox-egroupware.

BR
Jüri Kirch
Title: Re: ebox-egroupware ready for testing
Post by: J. A. Calvo on March 26, 2009, 01:28:10 pm
Well, the question that you answer when you do a dpkg-reconfigure, as it occurs when configuren other packages as ldap, is useless. eBox generates the password for you, and you can found it at /var/lib/ebox/conf/ebox-egroupware.passwd.

You can also edit that file and restart egroupware modle if you want to change the password.

Best regards,

J.A. Calvo
Title: Re: ebox-egroupware ready for testing
Post by: newuser44 on April 02, 2009, 05:28:07 am
I just did a reinstall from scratch using the ebox 1.0 hardy iso and the egroupware setup was great. This is so much easier than doing a manual install of egroupware.

Thank you!!!!

I was wondering about a few things though, as I've been using egroupware 1.2 up until now.

- What/where is the "header admin" name and password? I tried using the one at /var/lib/ebox/conf/ebox-egroupware.passwd but it doesn't work.

- The main egroupware menu had little fly-out menus for the applications that didn't fit, but this version doesn't, so I can't seem to access all the available apps. Is this something that will be fixed with the permissions template update?

Thanks again.

Title: Re: ebox-egroupware ready for testing
Post by: J. A. Calvo on April 02, 2009, 10:26:52 am
Hi newuser44!

The header admin name is "admin", the domain admin name is "ebox", the password is the same in both cases and is located at /var/lib/ebox/conf/ebox-egroupware.passwd as you said.

Regarding the menus... please try to change the theme, the default theme is "idots" but we changed it to "jerryr" which seems to be nicer. Try to change it back again to see if you have the same problem. The permissions update doesn't affect to this (it was only a problem applying permissions to a group).

Hope this helps!

Regards,

J. A. Calvo
Title: Re: ebox-egroupware ready for testing
Post by: newuser44 on April 02, 2009, 03:41:00 pm
Thanks J.A.

I guess I should have tried "admin"....Doh!

I forgot that you have to setup the template preferences to show the slider effects. I like the idots theme with the side menus in autohide mode, and to limit the number of icons on the main top menu bar, as well as icons only mode. I just find that it is less cluttered looking.

The Jerryr theme isn't bad when using autohide, but the side menu slide-out arrow is easy to miss for new users.

Thanks, and keep up the great work!
Title: Re: ebox-egroupware ready for testing
Post by: spott on June 13, 2009, 12:25:53 pm
How to install this package to Ubuntu Jaunty?
Title: Re: ebox-egroupware ready for testing
Post by: J. A. Calvo on June 13, 2009, 12:44:24 pm
There are no eBox packages for jaunty at the moment, we're sorry.
Title: Re: ebox-egroupware ready for testing
Post by: guazap on July 03, 2009, 07:56:03 pm
Same problme here with some other mysql errors:
Code: [Select]
2009/07/03 11:39:14 ERROR> PgDBEngine.pm:165 EBox::PgDBEngine::insert - Error inserting data: INSERT INTO firewall ( fw_dpt, fw_spt, fw_in, fw_src, event, fw_dst, fw_out, fw_proto, timestamp) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?)
ERROR:  invalid input syntax for integer: ""

2009/07/03 11:39:14 DEBUG> PgDBEngine.pm:161 EBox::PgDBEngine::insert - Error inserting data: INSERT INTO firewall ( fw_dpt, fw_spt, fw_in, fw_src, event, fw_dst, fw_out, fw_proto, timestamp) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?)
ERROR:  invalid input syntax for integer: ""

2009/07/03 11:39:14 ERROR> PgDBEngine.pm:165 EBox::PgDBEngine::insert - Error inserting data: INSERT INTO firewall ( fw_dpt, fw_spt, fw_in, fw_src, event, fw_dst, fw_out, fw_proto, timestamp) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?)
ERROR:  invalid input syntax for integer: ""

2009/07/03 11:40:21 WARN> Logs.pm:309 EBox::Logs::getModTableInfos - tableInfo() in openvpnmust return a reference to a list of hashes not the hash itself
2009/07/03 11:40:21 WARN> Logs.pm:309 EBox::Logs::getModTableInfos - tableInfo() in squidmust return a reference to a list of hashes not the hash itself
2009/07/03 11:40:21 DEBUG> LogFiltering.pm:70 EBox::Events::Model::Watcher::LogFiltering::new - Missing argument: tableInfo
2009/07/03 11:40:21 WARN> Events.pm:572 EBox::Events::__ANON__ - model EBox::Events::Model::Watcher::LogFiltering cannot be instantiated
2009/07/03 11:40:32 INFO> Global.pm:360 EBox::Global::saveAllModules - Saving config and restarting services: firewall mailfilter
2009/07/03 11:40:32 INFO> Module.pm:159 EBox::Module::save - Restarting service for module: firewall
2009/07/03 11:40:48 WARN> Logs.pm:309 EBox::Logs::getModTableInfos - tableInfo() in openvpnmust return a reference to a list of hashes not the hash itself
2009/07/03 11:40:48 WARN> Logs.pm:309 EBox::Logs::getModTableInfos - tableInfo() in squidmust return a reference to a list of hashes not the hash itself
2009/07/03 11:40:48 DEBUG> LogFiltering.pm:70 EBox::Events::Model::Watcher::LogFiltering::new - Missing argument: tableInfo
2009/07/03 11:40:48 WARN> Events.pm:572 EBox::Events::__ANON__ - model EBox::Events::Model::Watcher::LogFiltering cannot be instantiated
2009/07/03 11:41:15 INFO> Module.pm:159 EBox::Module::save - Restarting service for module: mailfilter
2009/07/03 11:41:15 ERROR> Sudo.pm:185 EBox::Sudo::_rootError - root command /usr/bin/test -f '/var/lib/ebox/tmp//trainSpam' failed.
Error output:
Command output: .
Exit value: 1
2009/07/03 11:41:19 ERROR> Sudo.pm:185 EBox::Sudo::_rootError - root command /usr/bin/test -e '/var/run/p3scan/p3scan.pid' failed.
Error output:
Command output: .
Exit value: 1
2009/07/03 11:41:19 DEBUG> PgDBEngine.pm:161 EBox::PgDBEngine::insert - Error inserting data: INSERT INTO firewall ( fw_dpt, fw_spt, fw_in, fw_src, event, fw_dst, fw_out, fw_proto, timestamp) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?)
ERROR:  invalid input syntax for integer: ""

2009/07/03 11:41:19 ERROR> PgDBEngine.pm:165 EBox::PgDBEngine::insert - Error inserting data: INSERT INTO firewall ( fw_dpt, fw_spt, fw_in, fw_src, event, fw_dst, fw_out, fw_proto, timestamp) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?)
ERROR:  invalid input syntax for integer: ""
Title: Re: ebox-egroupware ready for testing
Post by: J. A. Calvo on July 03, 2009, 08:14:28 pm
It seems that you have problems with postgresql in general, that's not related directly with ebox-egroupware. You can try to remove postgresql and install ebox again. (Be careful if you have data that may be lost).

Regards,

J. A. Calvo