Roundcube integration/module for ispconfig 3

[Horfic]

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

# ----------------
#
# 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

[edge]

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://roundcube:pass@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.

[Horfic]

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.

[edge]

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.

[edge]

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.

[Horfic]

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

[edge]

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.

[edge]

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!

[falko]

Did you check the Apache error logs?

[Horfic]

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