Roundcube integration/module for ispconfig 3

hi

I have tried ispconfig 2 and loved roundcube.

Is it possible to integrate it with Ispconfig 3

Thx a lot

 

Is it possible to change mail user password from roundcube webmail interface?

 

No, not in the Standard Package!
YOu would have to fine a password changer patch or write your own patch.

 

Here, I made quick a password changer script.

Just read the Install.txt

 

Horfic, thank you very much! I owe you a beer

 

Anytime you are in Austria.

When you have any questions, just ask.

PS: When you want, I can give you now a verison which also includes Autoreply.

 

i would like to have this version, i also appreciate this

 

Good here you go.
The Password Changer + Autoreply.

PS: The "with" Version also includes a extended Addressbook.
PPS: For further interest look here: Link

 

Hmm I keep getting a DATABASE ERROR: CONNECTION FAILED!
Here is what I've done.

1) Downloaded roundcubemail-0.2.1.tar.gz - Stable release from http://roundcube.net/downloads
2) Downloaded your "ISPConfig3_for_0.2.1_with" file
3) Uploaded roundcubemail-0.2.1.tar.gz, and "un" tar xvfz roundcubemail-0.2.1.tar.gz
4) Unziped your ISPConfig3_for_0.2.1_with, and uploaded the files in the directorys to the corresponding ones from roundcubemail
5) Renamed the db.inc.php.dist to db.inc.php and main.inc.php.dist to main.inc.php
6) changed the line $rcmail_config .... (in db.inc.php) to $rcmail_config['ispconfig_db'] = 'mysql://ispconfigassword@localhost/dbispconfig';
(note that as password in the above line I used the one found in /usr/local/ispconfig/interface/lib/config.inc.php, and that the password is (md5?) encrypted)

Now when accessing my domain/roundcubemail I get a DATABASE ERROR: CONNECTION FAILED!

Did I miss something here?

 

I missed something. The SQL Code you have to add to your roundcube database.
SO SORRRRRYYY!

Code:

# ----------------
#
# Database Additions for contact multiple emails
# Run in PhpMyAdmin on the database that holds the RC Contacts table. Change the table name rc_contacts to your contacts table name:
#
 ALTER TABLE `contacts` ADD `global_contact` TINYINT(1) NOT NULL default '0';
 ALTER TABLE `contacts` ADD `firm` VARCHAR(128) NOT NULL ;
 ALTER TABLE `contacts` ADD `position` VARCHAR(50) NOT NULL ;
 ALTER TABLE `contacts` ADD `p_tel` VARCHAR(30) NOT NULL ;
 ALTER TABLE `contacts` ADD `p_fax` VARCHAR(30) NOT NULL ;
 ALTER TABLE `contacts` ADD `p_mob` VARCHAR(20) NOT NULL ;
 ALTER TABLE `contacts` ADD `p_address` TEXT NOT NULL;
 ALTER TABLE `contacts` ADD `w_tel` VARCHAR(20) NOT NULL ;
 ALTER TABLE `contacts` ADD `w_fax` VARCHAR(20) NOT NULL ;
 ALTER TABLE `contacts` ADD `w_mob` VARCHAR(20) NOT NULL ;
 ALTER TABLE `contacts` ADD `w_address` TEXT NOT NULL;
 ALTER TABLE `contacts` ADD `notice` TEXT NOT NULL;
 ALTER TABLE `contacts` ADD `email2` VARCHAR(128) NOT NULL ;
 ALTER TABLE `contacts` ADD `email3` VARCHAR(128) NOT NULL ;
 ALTER TABLE `contacts` ADD `email4` VARCHAR(128) NOT NULL ;
# -------------------------------------------------------------  

But your problem sounds like that you didn't install Roundcube correctly yet. PLEASE READ THE INSTALL FROM ROUNDCUBE.

PS: The Adressbook comes from Link

 

Okay got it sort of working.
I did do the install as mentioned in the install, but I replaced the "$rcmail_config['db_dsnw'] = 'mysql://roundcubeass@localhost/roundcubemail';" with the one from you!
I should have read your install.txt better as it is saying " Edit the file {Place to roundcubefolder}/config/db.inc.php and add before ?>"

Anyway. I needed to remove the .htaccess file as it was giving my server a hard time with "ERROR 500 - Internal Server Error!".
Did you also needed to remove the .htaccess file to make RoundCube work on ISPconfig3?

An other two things that do not work for me are the Autoreply (it will give me a 500 error when trying to access the page) and changing the password.
I do see the password page, but when I hit "save" I get (like the Autoreply) a 500 error, and the password does also not get changed.

I'm sure it's me!

PS. I did add the new tables to the roundcube DB.

 

No I didn't had to remove the .htaccess file.
I created a sym link to my roundcube folder which is on my debian server at /usr/share/webmail/

I'm at the moment not at home and I will look for a solution as soon I'm at home. Should be tomorrow.

PS: I Use FastCGI php for my server and try to change the ip of the domain to a xxx.xxx.xxx.xxx or to *. ISPConfig seems to have here problems. Maybe that helps.

 

FastCGI php did fix the .htaccess problem.
I do still have the other two problems.

I'll have a go at it later today again.

 

Okay. Small update.

I got it all working!
For some reason the password that I got the 1st time from "/usr/local/ispconfig/interface/lib/config.inc.php" did not match at all in what I used in "/config/db.inc.php"
I'm 100% sure that I did put in the correct password, but again it did not match at all when I had a new look today!

I did do an apt-get update and apt-get upgrade today, but this could not have caused this problem!

Anyway. RoundCube (and the extra two options) are now working great!

Thank you.

 

I'm glad it is working for you.

I have already the solution to make the installation easier. The solution is the remote framework, but until it isn't finished, I get forced to use my own way to change the settings. So that users don't have to wait.

PS: For further development look at LINK

TO EDGE: I would like to know which settings php you had selected other than FastCGi, so I rese.arch that issue

 

At the moment I've set my PHP to FastCGI.
I'll give the other options a test run later today.

Once again thank you for your help and contribution.

 

Okay. Done some more testing.

RoundCube with the .htaccess as is will only work in Fast-CGI PHP mode.
Any of the other options (CGI / Mop-PHP and SuPHP) will give an ERROR 500 - Internal Server Error!

 

Did you check the Apache error logs?

 

I think it has something to do with the htaccess file, which trys to change some php settings with php flag.