Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Feature Requests

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 15th April 2009, 05:45
Horfic Horfic is offline
Senior Member
 
Join Date: Mar 2009
Location: Austria
Posts: 324
Thanks: 55
Thanked 93 Times in 58 Posts
Send a message via Skype™ to Horfic
Default

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
__________________
web wack creations - We create your custom web application
Mailuser interface for ISPConfig 3

Last edited by Horfic; 15th April 2009 at 06:59.
Reply With Quote
The Following User Says Thank You to Horfic For This Useful Post:
edge (15th April 2009)
Sponsored Links
  #12  
Old 15th April 2009, 11:15
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,033
Thanks: 261
Thanked 149 Times in 130 Posts
Default

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.
Reply With Quote
  #13  
Old 15th April 2009, 11:50
Horfic Horfic is offline
Senior Member
 
Join Date: Mar 2009
Location: Austria
Posts: 324
Thanks: 55
Thanked 93 Times in 58 Posts
Send a message via Skype™ to Horfic
Default

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.
__________________
web wack creations - We create your custom web application
Mailuser interface for ISPConfig 3

Last edited by Horfic; 15th April 2009 at 11:54.
Reply With Quote
  #14  
Old 15th April 2009, 12:21
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,033
Thanks: 261
Thanked 149 Times in 130 Posts
Default

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.
Reply With Quote
  #15  
Old 15th April 2009, 19:52
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,033
Thanks: 261
Thanked 149 Times in 130 Posts
Default

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.
Reply With Quote
  #16  
Old 16th April 2009, 04:29
Horfic Horfic is offline
Senior Member
 
Join Date: Mar 2009
Location: Austria
Posts: 324
Thanks: 55
Thanked 93 Times in 58 Posts
Send a message via Skype™ to Horfic
Default

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
__________________
web wack creations - We create your custom web application
Mailuser interface for ISPConfig 3

Last edited by Horfic; 16th April 2009 at 04:34.
Reply With Quote
  #17  
Old 16th April 2009, 09:46
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,033
Thanks: 261
Thanked 149 Times in 130 Posts
Default

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.
Reply With Quote
  #18  
Old 16th April 2009, 13:26
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,033
Thanks: 261
Thanked 149 Times in 130 Posts
Default

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!

Last edited by edge; 16th April 2009 at 13:55.
Reply With Quote
  #19  
Old 17th April 2009, 17:09
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,726 Times in 2,565 Posts
Default

Did you check the Apache error logs?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #20  
Old 17th April 2009, 17:10
Horfic Horfic is offline
Senior Member
 
Join Date: Mar 2009
Location: Austria
Posts: 324
Thanks: 55
Thanked 93 Times in 58 Posts
Send a message via Skype™ to Horfic
 
Default

I think it has something to do with the htaccess file, which trys to change some php settings with php flag.
__________________
web wack creations - We create your custom web application
Mailuser interface for ISPConfig 3
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
RoundCube 0.2-stable available for ISPConfig 2 Hans General 37 16th March 2009 22:15
Uninstall roundcube createch Installation/Configuration 4 18th January 2009 10:42
RoundCube Webmail "AllowOverride Options" Location fdsg72-lux Installation/Configuration 1 13th November 2008 12:25
RoundCube 0.2 Beta available for ISPConfig 2 Hans General 20 9th October 2008 14:29
FTP access to roundcube pkg install directories dancn General 4 11th August 2008 19:03


All times are GMT +2. The time now is 04:13.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.