Topic: oxadm to Manage Open-Xchange - Bounty $$$???

[wallyrp]

Good Morning,

I've tried to no avail to install oxadm from http://www.panno.com/oxadm/

My gut feeling is that when editing the config.php file, I'm specifying the wrong username that would administer Open-Xchange. According to everything that I read about Open-Xchange, the default administrator username is mailadmin. Well, I can't login as that user into Open-Xchange so I'm not sure that the user exists somewhere in the background.

Now according to oxadm instructions the following must be installed.

4. Be sure that PHP was build with IMAP and LDAP support

Is PHP on SME7 installed like this?

Also, even if I purchase the server software, I am not sure that I could use the administration panel they provide would I?

I'm searching for ideas and suggestions here. I have half a mind to put up a bounty for the development of this but I'm not sure how much to put up. Any interest?

NOTE: There is another administration package out there labeled ATFrogs but it appears to be a bit more difficult to install. I keep breaking my OX install when attempting to install ATFrogs.

[cactus]

Now according to oxadm instructions the following must be installed.

4. Be sure that PHP was build with IMAP and LDAP support

Is PHP on SME7 installed like this?

Try using the phpinfo() command in a php file and access it through your browser it should give you all information for your php configuration, mine says that ldap and imap are enabled (haevily customized SMEServer 7).

[SchulzStefan]

Wally,

if you find a solution, I'm also heavily interested! I also tried to modify the config.php, right now with no success.

Stefan

[jfarschman]

Hey,

  Using the phpinfo to find what you need is a good idea.  You guys know how to do that?  No?  Make a file called test.php in one of your ibays in the html area.  Make sure the ibay is set to allow php.  Place the following inside the time... nothing else:

<?php phpinfo() ?>

Then visit the page.  I think it's configured just fine.

'--with-imap=shared' '--with-imap-ssl' '--with-ldap=shared'

[jfarschman]

Hey...

  Just got the the step where you modify the config file.  Part of the comments in this file are in German... part are in English...  It looks like there are many places to change things.

  A.  Everywhere it says DOMAIN, change this to your domain.
  B.  Change .com if you need to.
  C.  Take a look at /etc/openldap/slapd.conf
  D.  Change the language from de.php to your choice.

But after all this I cannot login.  It says "There was an error by the Login Process"

[wallyrp]

Good Evening,

I only changed the stuff in English. I may be totally wrong doing that but that's all I changed. When I finish changing things and I attempt to login as userid mailadmin and password mailadmin or whatever password OX uses for SQL, it states no object found.

*Edited* 11:12PM CST USA Added one line below:

The rootpw in the slapd.conf, is that the password that needs to go into the config.inc file where it asks?

[SchulzStefan]

Jay,

I think there's a little more work to do. I also tried to modify the config.php with no result. I got an error in Line 309 in the function.php, a login was not possible. I wrote to Peter Panno with the question of a detailed HOW-TO.

Isn't it possible to read the complete open-xchange database with a tool? e.g. phpmyadmin?

[jfarschman]

Hey,

  Well, this is a promising tool, but it dies not work for me.  As for a tool to read the psql DB, they do exist, but I've never loaded one.

  Tell me if Peter writes back.

  About the rootpw.   I do not know which password we should use.  Sorry.

[SchulzStefan]

Jay,

meanwhile I got a reply. Thx to Björn who did the oxadm!

Here are the things to change:
1.) create a group in ox e.g. named admin
2.) add the user admin to this group
3.) edit the config.php
4.) change the mailadmin in admin
5.) change SECRET in your password. NOT ENCRYPTED! WRITE IT CLEARLY!
6.) change DOMAIN in your Domain
7.) change dc=com in your dc=whatever
8.) find the admin for the IMAP. enter name and password

I can login in the webinterface. But I'm still not able to connect to the IMAP. On the left side there is the ox-menu. A few things are working - but right now I cannot change things.

[wallyrp]

Good Morning,

Sounds promising. There is a postgres admin program out there called pgadmin III, I believe. www.pgadmin.org

Now regarding the creation of groups and such. When you state create a group in ox, I'm assuming that your talking about the database itself right? If this is the case, would you then add the existing SME built-in userid of admin to that group?

I'm also assuming that the admin for IMAP would be the same as the SME built-in userid of admin correct?

I'm poking at this on a test box at the house, I'll try your suggestions above this evening when I get home. Thanks for the ideas, I'll go sniffing down those trails.

[wallyrp]

Good Evening,

Ok, how do I find out the IMAP admin username and password? Is it the same as the admin user account created by default by SME?

Attempting to replicate your minor success but I'm not getting anything right now.

[SchulzStefan]

Things are going on...

Some news:

1.) edit the config.php
- change the rootdn. Same as in slapd.conf
- change pass. Same as in slapd.conf
- change admingroup to that group, where the login user belongs to.
- change mailDomain to your domain
- openexchange DB: change DB pass from SECRET to openexchange
- change serverIP to your Server IP
- IMAP: change localhost to localhost:143/notls
- change passwort to your admin passwort. WRITE NOT ENCRYPTED!
- change username to admin
- delete the lines prefix and seperator

2.) edit /oxadm/inc/bin/adduser.sh
- change domain in your domain
- change IMAPUSER to admin
- change IMAPPASS to your admin passwort. WRITE NOT ENCRYPTED!

You should now be able to login as a user who belongs to that group, you defined above.

Now I can
- delete users
- delete groups
- add groups
- add user to groups
- delete users from groups
- create mailboxes

I'm not able to
- add users
- modify users
- see any rights (top button on the left panel)
- delete mailboxes

If you make a tail -f /var/log/messages you'll see what happens.

[wallyrp]

Good Morning,

Regarding the adduser.sh, wouldn't that be adduser_sme.sh instead? I'll poke around with it again this evening and see if I can change anything in oxadm to point to the *_sme.sh scripts. Regarding modifying, I'll continue to use the panel that comes with the Open-Xchange SME contrib. The real point of curiousity(?) is any ability to edit the quota of a specific user.

Thanks for all your efforts.