Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
SMS Forum Index » SMS User Support

Post new topic   Reply to topic
egroupware reconfig Goto page 1, 2  Next
View previous topic :: View next topic  
Author Message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Tue Apr 22, 2008 7:47 pm    Post subject: egroupware reconfig Reply with quote

I tried to configure egroupware to use mysql instead of ldap, and it appears to have taken the changes, but when I try to use email I get can not connect to imap server. Is there some change I need to make in dovecot?

If I disable ldap, and tell egroupware to use mysql for data repository, what is the storage path? Is that /var/lib/mysql/egroupware?

Also, if this doesn't work, then I need to create a new configuration for egroupware and ldap. In egroupware, would I login to setup and go to admin section and create a new database and user?

For ldap, could you point me to what doc you used to configure main repository?

thanks
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Tue Apr 22, 2008 8:43 pm    Post subject: Reply with quote

You must reconfigure dovecot and postfix to be able to auth users, including sasl to work with mysql.

It's quite simple to reconfigure egroupware using SMS's preconfigured ldap configuration. So simple just as typing
'sed -e "s,dc=sms,dc=yourdomain,g"'
to all configs (dovecot,postfix,sasl,ldap) and creating of course new ldap database.

main repository?

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Thu Apr 24, 2008 2:27 am    Post subject: Reply with quote

Are you saying that if you execute script, and subsitute sms for cliqn, it will replace all instances of sms and reconfigure postfix,dovecot, egroupware, and ldap?


I ran script but nothing changed. Are you sure that is correct syntax? Smile
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Thu Apr 24, 2008 5:52 am    Post subject: Reply with quote

An example
Code:
sed -e "s,dc=sms,dc=yourdomain,g" -i /etc/openldap/slapd.conf


gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Thu Apr 24, 2008 7:05 am    Post subject: Reply with quote

thanks - will give it a try.

BTW, running SMS on my notebook. Not bad.
Back to top
View user's profile Send private message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Thu May 01, 2008 6:48 pm    Post subject: Reply with quote

well I ran your reconfig script against dovecot, openldap, postfix. Went into egroupware config and changed info from dc=sms to dc=cliqn. Saved and then got this:

Error: Can't bind to LDAP server: cn=manager,dc=sms,dc=org! common::ldapConnect / accounts_backend::accounts_backend / accounts::accounts / CreateObject(phpgwapi.accounts) / setup::setup_account_object / setup::add_account
Error: Error connecting to LDAP server cliqn!

also logged in to phpLDAPadmin and it still defaults to dc=sms, dc=org. Obviously, I've missed some conf files but don't know where.
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Thu May 01, 2008 7:29 pm    Post subject: Reply with quote

You must also edit egroupware configuration to bind to clign.org instead of sms.org that is already setup for, including cn=Manager,dc=sms,dc=org to cn=Manager,dc=clign,dc=org.

Phpldapadmin
/var/www/htdocs/phpldapadmin/config/config.php at line 194
edit
$ldapservers->SetValue($i,'login','dn','cn=Manager,dc=sms,dc=org');
to
$ldapservers->SetValue($i,'login','dn','cn=Manager,dc=clign,dc=org');

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Thu May 01, 2008 8:12 pm    Post subject: Reply with quote

This is the message I am now getting:

ldap_add(,cn=Default,ou=groups,o=egroupware,dc=cliqn,dc=com,Array ( [objectclass] => Array ( [0] => top [1] => posixgroup ) [gidnumber] => 1009 [cn] => Default ) ) Object class violationldap_add(,cn=Admins,ou=groups,o=egroupware,dc=cliqn,dc=com,Array ( [objectclass] => Array ( [0] => top [1] => posixgroup ) [gidnumber] => 1010 [cn] => Admins ) ) Object class violation

Error in group-creation !!!

Should I just create a new egroupware setup?
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Thu May 01, 2008 8:31 pm    Post subject: Reply with quote

Creating a new egroupware setup it's the best solution...
Egroupware has 1.4.004 now so I believe it's better to install 1.4.004 from scratch.

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Thu May 01, 2008 8:39 pm    Post subject: Reply with quote

thanks - will do.

BTW, the forum keeps logging me out after a few minutes. I know I am a pain in the butt, but really Wink
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Thu May 01, 2008 8:59 pm    Post subject: Reply with quote

baboo wrote:
thanks - will do.

BTW, the forum keeps logging me out after a few minutes. I know I am a pain in the butt, but really Wink


That has to do with your browser and cookie and session management, I don't have any problems with that...
Did you tick [Log me on automatically each visit:] option on login?

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Fri May 02, 2008 2:16 pm    Post subject: Reply with quote

I have used the script that you supplied to reconfigure ldap, dovecot,postfix, and egroupware. After using script to make changes, I greped for 'dc=sms,dc=org,' and found none, so I think I must have found all.

However, when I go to egroupware setup and make changes here is the error messages.

Error: Can't bind to LDAP server: cn=manager,dc=cliqn,dc=com! common::ldapConnect / accounts_backend::accounts_backend / accounts::accounts / CreateObject(phpgwapi.accounts) / setup::setup_account_object / setup::add_account
Error: Error connecting to LDAP server cliqn!
ldap_add(,cn=Default,ou=groups,o=egroupware,dc=cliqn,dc=com,Array ( [objectclass] => Array ( [0] => top [1] => posixgroup ) [gidnumber] => 1010 [cn] => Default ) ) ldap_add(,cn=Admins,ou=groups,o=egroupware,dc=cliqn,dc=com,Array ( [objectclass] => Array ( [0] => top [1] => posixgroup ) [gidnumber] => 1011 [cn] => Admins ) )
Error in group-creation !!!

That is from install without re-installing egroupware or creating new database.

The next error message is from creating a new install of egroupware and new database:

ldap_add(,cn=Default,ou=groups,o=egroupware,dc=cliqn,dc=com,Array ( [objectclass] => Array ( [0] => top [1] => posixgroup ) [gidnumber] => 10$
class violationldap_add(,cn=Admins,ou=groups,o=egroupware,dc=cliqn,dc=com,Array ( [objectclass] => Array ( [0] => top [1] => posixgroup ) [gi$
Admins ) ) Object class violation

Error in group-creation !!!

So, either approach results in errors. It appears to me that changes have worked except in egroupware. Any thoughts?
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Fri May 02, 2008 3:16 pm    Post subject: Reply with quote

Did you flushed LDAP Database completely, on clean install and get errors?
On new install you must flush all ldap db and egroupware will recreate tables upon setup.
Don't confuse mysql db with LDAP db.
You only need to import your modded egroupware.ldif through phpldapadmin before egroupware installation.

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Fri May 02, 2008 4:49 pm    Post subject: Reply with quote

I thought it might be something like that. I've spent all this time since you posted looking for command to flush ldap db and could not find it. You would think a search of 'flush ldap db' would turn it up.

Could you please point me to command?

thanks for the answer - I am looking forward to having my community site up and working with sms.
Back to top
View user's profile Send private message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Fri May 02, 2008 5:16 pm    Post subject: Reply with quote

haven't flushed db yet, still don't know how. But I tried to import egroupware.ldif and got this message:

LDIF text import
Could not add object: dc=cliqn,dc=com
LDAP said: LDAP_NAMING_VIOLATION
A naming violation occurred. This usually means that you tried to change the value of an attribute that is used in the DN. For example, if you change the 'cn' value of an entry whose DN is 'cn=Bob Jones,dc=example,dc=com', you must also rename the entry to reflect the change.

Is this because I haven't flushed db? Just trying to learn.

If I need to rename, what field do I need to rename?

thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » SMS User Support All times are GMT + 2 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

SMS - Superb! Mini Server Project © 2016
Powered by phpBB © 2001, 2002 phpBB Group
iCGstation v1.0 Template By Ray © 2003, 2004 iOptional