View Single Post
  #2  
Old 20th April 2011, 18:47
Croydon Croydon is offline
ISPConfig Developer
 
Join Date: Jul 2007
Location: Koblenz, Germany
Posts: 922
Thanks: 16
Thanked 258 Times in 206 Posts
Default

I just completed changing my local repository copy of ispconfig the way I mentioned above.

There are a lot of files that needed to be changed, so I did not want to commit to the svn repository without being sure to keep everything working.

At some points I was not sure whether to change a line or not:
Code:
user_query = SELECT email AS user, maildir AS home, CONCAT('*:storage=', quota , 'B') AS quota_rule FROM mail_user WHERE login = '%u' AND disable%Ls = 'n'
I changed the WHERE column from email to login but I left the SELECT column as is.
Is that correct or do I have to change it to "SELECT login AS user" ?
I do not exactly know what the user_query user column is used for.


The diffstat program states the following files as changed on my local copy:

config/courier/authmysqlrc
install/sql/ispconfig3.sql
install/sql/incremental/upd_0009.sql (new file)
install/tpl/authmysqlrc.master
install/tpl/debian6_dovecot-sql.conf.master
install/tpl/debian_dovecot-sql.conf.master
install/tpl/fedora_dovecot-sql.conf.master
install/tpl/mysql-virtual_mailboxes.cf.master
install/tpl/opensuse_dovecot-sql.conf.master
install/tpl/pamd_smtp.master
install/tpl/sasl_smtpd.conf.master
interface/web/mail/form/mail_user.tform.php
interface/web/mail/lib/lang/de_mail_user.lng
interface/web/mail/lib/lang/de_mail_user_list.lng
interface/web/mail/lib/lang/en_mail_user.lng
interface/web/mail/lib/lang/en_mail_user_list.lng
interface/web/mail/list/mail_user.list.php
interface/web/mail/mail_user_edit.php
interface/web/mail/templates/mail_user_list.htm
interface/web/mail/templates/mail_user_mailbox_edit.htm
19 files changed, 69 insertions(+), 25 deletions(-)

I only have a debian squeeze server with courier to test and on that server it works as intended.
Reply With Quote