#121  
Old 10th April 2007, 22:52
radim_h radim_h is offline
Senior Member
 
Join Date: Jan 2007
Location: Prague, Czech
Posts: 404
Thanks: 33
Thanked 23 Times in 18 Posts
Send a message via ICQ to radim_h
Default Roundcube outside ISPconfig

Hello!

i'd like to run Roudcube outside ISPconfig (on site under regular Apache instance, configured in /etc/httpd/https.conf, not just https://admin.mysite.tld/roundcube )
because i'd like to use rewrites as descibed in http://www.howtoforge.com/forums/showthread.php?t=4964 (originally for Squirrell)
so all customers can use it as http://mail.anyuserdomain.tld
------------
<VirtualHost 192.168.1.1:80>
ServerName mail.*:80
ServerAdmin webmaster@domain.com
DocumentRoot /var/www/webmail
RewriteEngine On
RewriteCond %{HTTP_HOST} ^webmail..+..+$ [NC]
RewriteCond %{HTTP_HOST} !^mail.domain.com$
RewriteRule ^(.*)$ https://webmail.domain.com$1 [R=301]
</VirtualHost>
---------------------

i just copied directory /home/admispconfig/ispconfig/web/roundcubemail to /var/www/webmail , changed permissions for apache (also tried chmod 777 to be sure there is no problem with permissions)

but i'm still getting message:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

http error log record is : [Tue Apr 10 22:46:51 2007] [error] an unknown filter was not added: PHP
But php is working on the site


I'm i missing something important??

Thanks for any pointer

Radim

Last edited by radim_h; 10th April 2007 at 23:50.
Reply With Quote
Sponsored Links
  #122  
Old 10th April 2007, 23:11
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,256
Thanks: 210
Thanked 648 Times in 294 Posts
Send a message via Skype™ to Hans
Default

This howto might help you:
http://www.howtoforge.com/roundcube_webmail_ispconfig

Just install it within your /webfolder if you do not want a sepearate site like http://roundcube.yourdomain.com/
__________________
Hans

BB-Hosting | Quality Web Hosting since 2005
Reply With Quote
  #123  
Old 10th April 2007, 23:33
radim_h radim_h is offline
Senior Member
 
Join Date: Jan 2007
Location: Prague, Czech
Posts: 404
Thanks: 33
Thanked 23 Times in 18 Posts
Send a message via ICQ to radim_h
Default Thank you, but.....

thanks for links.
I'm just still not getting why configuration copied from .pkg for ISPconfig doesn't work under different apache virtual host name.
I did same thing with squirrelmail and it worked...
Reply With Quote
  #124  
Old 11th April 2007, 06:13
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,256
Thanks: 210
Thanked 648 Times in 294 Posts
Send a message via Skype™ to Hans
Default

I did not create the .pkg, so i can not give you the right answer.
You have an alternative now to get it working.
__________________
Hans

BB-Hosting | Quality Web Hosting since 2005
Reply With Quote
  #125  
Old 11th April 2007, 18:19
radim_h radim_h is offline
Senior Member
 
Join Date: Jan 2007
Location: Prague, Czech
Posts: 404
Thanks: 33
Thanked 23 Times in 18 Posts
Send a message via ICQ to radim_h
Default works great

everything works now, thanks!

just missing one thing, is it possible to create imap subfolders in Roundcube?
Reply With Quote
  #126  
Old 19th April 2007, 23:12
aqua aqua is offline
Member
 
Join Date: Mar 2006
Posts: 60
Thanks: 4
Thanked 3 Times in 3 Posts
Default sqlite or mysql?

Hello:

I want to update roundcube to the latest pkg package. Many people complained that the sender field was empty, and many pointed to the roundcube's FAQ, which states that this table must be altered

ALTER TABLE identities ADD `html_signature` tinyint( 1 ) NOT NULL default '0';


Falko pointed out that Roundcube uses ispconfig's db, which is the default one for me, db_ispconfig.

I looked inside db_ispconfig, but i cannot find a table called identities.

I also looked at the current installation of roundcube, in:

/home/admispconfig/ispconfig/web/roundcubemail/config/db.inc.php

and found the lines:

$rcmail_config['db_dsnw'] = 'sqlite://./sqlite.db?mode=0646';
// postgres example: 'pgsql://roundcubeass@localhost/roundcubemail';
// sqlite example: 'sqlite://./sqlite.db?mode=0646';

which means roundcube is using the sqlite database. I am confused now. Which database should I update? and what does this db store anyway?

Thanks,
aqua
Reply With Quote
  #127  
Old 21st April 2007, 13:12
ADM ADM is offline
Junior Member
 
Join Date: Apr 2007
Posts: 23
Thanks: 1
Thanked 0 Times in 0 Posts
Default Roundcube

I have a working ISPConfig install and installed roundcube from http://area51.archtechnologies.net/R...-beta2-461.pkg

I'm unable to login, this is mail.log line:
imapd: chdir Maildir: No such file or directory

I login with webNN_name and password
I view a file inside /var/mail that is webNN_name

Any hint?


EDIT:
My fault, it was not enabled Maildir in Management -> Server -> Settings -> Email

Last edited by ADM; 21st April 2007 at 13:32.
Reply With Quote
  #128  
Old 21st April 2007, 16:35
radim_h radim_h is offline
Senior Member
 
Join Date: Jan 2007
Location: Prague, Czech
Posts: 404
Thanks: 33
Thanked 23 Times in 18 Posts
Send a message via ICQ to radim_h
Default hints .)

Not Existing Maildir format (mast be enabled in postfix or your mailserver) ?
Have you sent some mail into your mailbox? I'm not sure, but maybe mailbox si created with first incomming message.. Welcome message for new user can be set in ISPConfig

Last edited by radim_h; 21st April 2007 at 16:55.
Reply With Quote
  #129  
Old 25th April 2007, 18:08
radim_h radim_h is offline
Senior Member
 
Join Date: Jan 2007
Location: Prague, Czech
Posts: 404
Thanks: 33
Thanked 23 Times in 18 Posts
Send a message via ICQ to radim_h
Default

Quote:
Originally Posted by aqua
Hello:

I want to update roundcube to the latest pkg package. Many people complained that the sender field was empty, and many pointed to the roundcube's FAQ, which states that this table must be altered

ALTER TABLE identities ADD `html_signature` tinyint( 1 ) NOT NULL default '0';


Falko pointed out that Roundcube uses ispconfig's db, which is the default one for me, db_ispconfig.

I looked inside db_ispconfig, but i cannot find a table called identities.

I also looked at the current installation of roundcube, in:

/home/admispconfig/ispconfig/web/roundcubemail/config/db.inc.php

and found the lines:

$rcmail_config['db_dsnw'] = 'sqlite://./sqlite.db?mode=0646';
// postgres example: 'pgsql://roundcubeass@localhost/roundcubemail';
// sqlite example: 'sqlite://./sqlite.db?mode=0646';

which means roundcube is using the sqlite database. I am confused now. Which database should I update? and what does this db store anyway?

Thanks,
aqua

Thank you,
ALTER TABLE identities ADD `html_signature` tinyint( 1 ) NOT NULL default '0';
did help me with My Roundube, but it is for Roundcube working with Mysql.
The installation is very easy, just read README.

Last edited by radim_h; 29th April 2007 at 12:31.
Reply With Quote
  #130  
Old 29th April 2007, 12:30
radim_h radim_h is offline
Senior Member
 
Join Date: Jan 2007
Location: Prague, Czech
Posts: 404
Thanks: 33
Thanked 23 Times in 18 Posts
Send a message via ICQ to radim_h
 
Default how to make roundcube using email adresses for login to IMAP server?

Well readme doesn't work for everything

I changed users logging to dovecot and postfix as decribed here:
http://www.howtoforge.com/forums/showthread.php?t=12308,
So users can set login in email clients in formatr user@domain.tld, which is great
But now i can't log into Roudcube, it stil translating user@domain.tld to domain.tld_user format, so it cant log into imap server
(imap-login: Disconnected: user=<_mydomain.cz_test>)

When i change main.inc.php line
$rcmail_config['virtuser_file'] = '/etc/postfix/virtusertable';
to
$rcmail_config['virtuser_file'] = ' '; or uncomment this line

it is still sending to dovect login "domain.tld_user" so no one can log into webmail

what should i change in config to make roudcube use email adresses for login to dovecot and translate it from /etc/postfix/virtusertable ???
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
Getting RoundCube to work in ISPConfig networkguru00 Installation/Configuration 1 7th April 2006 23:59


All times are GMT +2. The time now is 10:50.


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