postfixadmin-tracker Mailing List for PostfixAdmin (Page 30)
Brought to you by:
christian_boltz,
gingerdog
Menu
▾
▴
postfixadmin-tracker — Postfix Admin tracker notification - READ ONLY!
You can subscribe to this list here.
| 2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(5) |
Oct
(67) |
Nov
(83) |
Dec
(47) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008 |
Jan
(57) |
Feb
(15) |
Mar
(21) |
Apr
(38) |
May
(27) |
Jun
(38) |
Jul
(35) |
Aug
(50) |
Sep
(8) |
Oct
(9) |
Nov
(59) |
Dec
(59) |
| 2009 |
Jan
(27) |
Feb
(42) |
Mar
(63) |
Apr
(46) |
May
(26) |
Jun
(25) |
Jul
(40) |
Aug
(19) |
Sep
(17) |
Oct
(35) |
Nov
(26) |
Dec
(21) |
| 2010 |
Jan
(11) |
Feb
(19) |
Mar
(40) |
Apr
(25) |
May
(23) |
Jun
(17) |
Jul
(10) |
Aug
(18) |
Sep
(21) |
Oct
(12) |
Nov
(10) |
Dec
(22) |
| 2011 |
Jan
(30) |
Feb
(23) |
Mar
(23) |
Apr
(38) |
May
(32) |
Jun
(19) |
Jul
(20) |
Aug
(36) |
Sep
(11) |
Oct
(28) |
Nov
(4) |
Dec
(4) |
| 2012 |
Jan
(6) |
Feb
(3) |
Mar
(16) |
Apr
(28) |
May
(29) |
Jun
(10) |
Jul
(2) |
Aug
(3) |
Sep
|
Oct
(13) |
Nov
(1) |
Dec
(1) |
| 2013 |
Jan
(11) |
Feb
(7) |
Mar
(29) |
Apr
(2) |
May
(3) |
Jun
(15) |
Jul
(8) |
Aug
(5) |
Sep
(5) |
Oct
(4) |
Nov
(27) |
Dec
(81) |
| 2014 |
Jan
(12) |
Feb
(13) |
Mar
(5) |
Apr
|
May
(41) |
Jun
(16) |
Jul
(7) |
Aug
(10) |
Sep
(24) |
Oct
(50) |
Nov
|
Dec
(2) |
| 2015 |
Jan
(5) |
Feb
(2) |
Mar
(7) |
Apr
(20) |
May
(1) |
Jun
(3) |
Jul
(12) |
Aug
(1) |
Sep
(17) |
Oct
(5) |
Nov
(20) |
Dec
(10) |
| 2016 |
Jan
(10) |
Feb
(11) |
Mar
(22) |
Apr
(30) |
May
(33) |
Jun
(3) |
Jul
|
Aug
(12) |
Sep
(20) |
Oct
(11) |
Nov
(15) |
Dec
(8) |
| 2017 |
Jan
(1) |
Feb
(11) |
Mar
(10) |
Apr
|
May
(3) |
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
(1) |
Nov
|
Dec
(3) |
| 2018 |
Jan
(2) |
Feb
|
Mar
(1) |
Apr
|
May
(4) |
Jun
(2) |
Jul
(4) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
|
Feb
|
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: SourceForge.net <no...@so...> - 2009-10-19 00:33:11
|
Feature Requests item #1724759, was opened at 2007-05-24 13:25 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937967&aid=1724759&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Interface Improvements (example) Group: None >Status: Closed >Resolution: Fixed Priority: 1 Private: No Submitted By: superlolo (superlolo) Assigned to: Nobody/Anonymous (nobody) Summary: Show Mailbox disk space Initial Comment: It's possible to have an information for the diskspace quota used for each mailbox (ex: 70% full ...) ? in the old forum, someone have post a solution for this (i think) Sorry for my poor english! ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2009-10-19 02:17 Message: Just going through the feature requests, and I have good news: This feature is available :-) You have to use Dovecot (because it can store quota usage in the database), and you have to enable $CONF['used_quotas'] to enable displaying the quota usage. This feature is available in the latest version of postfixadmin (2.3rc8 or, if you use dovecot >= 1.2, the SVN version or the [to-be-released] 2.3 final). ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2007-12-30 23:04 Message: Logged In: YES user_id=593261 Originator: NO I'm afraid this might become technically difficult. There are two possible solutions: a) login to the mailboxes with IMAP - requires unencrypted passwords b) run "du" in the maildir - needs read access for wwwrun user Both are not good for security :-( (If you find the post in the old forum archive, please add the link here.) [downgrading priority until someone has a good idea how to implement this in a secure way.] ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937967&aid=1724759&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-19 00:32:24
|
Feature Requests item #2881499, was opened at 2009-10-19 02:32 Message generated for change (Tracker Item Submitted) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937967&aid=2881499&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: SVN (please specify revision!) Status: Open Resolution: None Priority: 5 Private: No Submitted By: Christian Boltz (christian_boltz) Assigned to: Nobody/Anonymous (nobody) Summary: check dovecot version in setup.php Initial Comment: setup.php could check the dovecot version (dovecot --version) and and check if $CONF['new_quota_table'] is set accordingly. If the setting does not match the dovecot version, it should print a warning. Possible problems that need to be adressed: - dovecot not installed at all (because Courier etc. is used) - path to dovecot? Or just try without path? (SVN r731) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937967&aid=2881499&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-19 00:28:09
|
Patches item #2545787, was opened at 2009-01-29 16:56 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937966&aid=2545787&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Vacation Group: SVN (please specify revision!) Status: Open Resolution: None Priority: 5 Private: No Submitted By: Rag3Rac3r (rag3rac3r) Assigned to: Nobody/Anonymous (nobody) Summary: Check if notified_at is older than created Initial Comment: This patch really only applies under certain conditions, when PFAs php-script for some reason can't delete the entry from the vacation_notification table (for example if your running MySQL Replication to a off site email server, and you don't like to setup a master<->master replication in MySQL). What it does is that it enables so vacation.pl takes into consideration that the vacation_notification table can contain outdated values (i.e. a user has changed his message and/or come back from vacation and gone on vacation again). It creates a higher amount of sql queries as an conditional query is moved to be an needed sql query, so it should really be used when you only have to. And it should also be combined with an shell script (perl, php, sh) to clean the vacation_notification table. Patch applies to SVN rev. 535 My suggestion to maintainers is to place it into contrib, this should NOT go into the vacation.pl as it still only applies under very special circumstances. ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2009-10-19 02:28 Message: Gingerdog: ping ;-) IMHO the additional query doesn't hurt much - this patch should go into the official vacation.pl (given it does what it should - I only had a look at the query, not at all the code ;-) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2009-01-30 09:14 Message: Thanks; I'll try and review it and add it to SVN shortly. (If I've not done anything in a week, feel free to give me a kick) ---------------------------------------------------------------------- Comment By: Rag3Rac3r (rag3rac3r) Date: 2009-01-30 00:45 Message: Added a example cleanup script for the table in the database that both cleans out active vacations where the notifcation was sent out last time the user was on vacation and where the vacation is inactive and it in normal cases would've been purged by the PFA webscripts. Perl isn't my strong side, if it had been, the script would've been in that ;) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937966&aid=2545787&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-19 00:20:48
|
Patches item #2867629, was opened at 2009-09-26 22:05 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937966&aid=2867629&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: None >Status: Closed >Resolution: Accepted Priority: 5 Private: No Submitted By: wizard (wvolz) Assigned to: Nobody/Anonymous (nobody) Summary: Add support for viewing dovecot v1.2 quotas Initial Comment: Dovecot v1.2 changed the way quota information is stored and so display of used quotas no longer works. This patch adds a config variable "dovecot_version" and modifies list_virtual to work with v1.2 quotas when the config variable is set. This patch also removes some un-needed code specific for postgres and fixes a bug that prevents used quota display when 'vacation_control_admin' is disabled. The patch is against 2.3rc7. ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2009-10-19 02:20 Message: Commited to SVN r730 - thanks for your patch! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937966&aid=2867629&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 23:56:02
|
Bugs item #2858717, was opened at 2009-09-14 19:36 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2858717&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.3 >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: ksb (ksb4ever) Assigned to: Nobody/Anonymous (nobody) Summary: postgresql upgrade script error Initial Comment: Hi folks! 2.3rc7 Got error when sepup script upgrades db structure on postgresql db (adding indexes). Found a buggy line in upgrade.php CODE: if(!_pgsql_object_exists('mailbox_username_active')) { db_query_parsed('CREATE INDEX mailbox_username_active ON $table_mailbox(username,active)'); } $table_mailbox(username,active) not substituted with value, I think need to use double quotes instead. ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2009-10-19 01:55 Message: This was fixed by GingerDog in SVN r719 - but obviously he forgot to close this bugreport ;-) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2858717&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 23:50:27
|
Bugs item #2834441, was opened at 2009-08-09 13:57 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2834441&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Andrey Miheev (miandr) Assigned to: Nobody/Anonymous (nobody) Summary: setting create_mailbox_subdirs doesn't send welcome mail Initial Comment: Setting create_mailbox_subdirs does not set checkbox "Send Welcome mail" checked. This is because of error in create-mailbox.php: string <?php print (isset($CONF['create_mailbox_subdirs'])) ? '' : 'checked'; ?> should be <?php print (isset($CONF['create_mailbox_subdirs'])) ? 'checked' : ''; ?> ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2009-10-19 01:50 Message: Your proposed fix un-checks the "send welcome mail" box if $CONF['create_mailbox_subdirs'] is not used ;-) which is not a solution either. I changed the template to have this always checked. Commited to SVN r731 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2834441&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 23:40:52
|
Bugs item #2793458, was opened at 2009-05-18 18:44 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2793458&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Vacation Group: None >Status: Pending Resolution: None >Priority: 4 Private: No Submitted By: roque moy (roquesao) Assigned to: Nobody/Anonymous (nobody) Summary: bad transport type: user=vacation Initial Comment: i can't configure vacations , my master.cf has this line: vacation unix - n n - - pipe flags=Rq user=vacation argv=/var/spool/vacation/vacation.pl -f ${sender} -- ${recipient} in /var/log/mail.log postfix/master[5154]: fatal: /etc/postfix/master.cf: line 94: bad transport type: user=vacation the file vacation exists in var/spool/vacation/ helpme please !!! excuseme my english , i am from argentina . thanks ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2009-10-19 01:40 Message: I'm using the same line, and it works well. When asking google for your error message, I only find hints about whitespace errors. Please check again that everything from "vacation unix ..." till "${recipient}" is in one line. This line must _not_ start with whitespace. If you can't solve the problem, please upload your master.cf as attachment. ---------------------------------------------------------------------- Comment By: roque moy (roquesao) Date: 2009-05-18 20:35 Message: hello was all on one line, which will not be the problem ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2009-05-18 20:24 Message: Hi, Make sure it's all on one line. If you have a line break, the following line MUST start with whitespace. David. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2793458&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 23:35:09
|
Bugs item #2661366, was opened at 2009-03-04 13:12 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2661366&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed >Resolution: Rejected Priority: 4 Private: No Submitted By: Pavel Volkovitskiy (olfway) Assigned to: Nobody/Anonymous (nobody) Summary: add parameter to disable alias magic Initial Comment: not everyone needs to have alias for every mailbox, so there should be a way to disable automagically alias creating ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2009-10-19 01:35 Message: The query with UNION _is_ tricky, at least in some cases. Imagine you have a mailbox fo...@ex..., but have configured it to forward-only mode. How should postfix know that it should not deliver to this mailbox in this case? Another case are store-and-forward mailboxes which _need_ the alias to work. Regarding your real word problem: > i had to restore mailbox once, after i removed alias and postfixadmin > removes mailbox just in case Then don't remove the alias ;-) Postfixadmin will only display the mailbox (with an "Alias" link in the same line), so it is quite clear that deletion will remove the whole mailbox (including the alias). IMHO your problem was more or less an user error. As you can see in the previous comments, everybody except you votes to leave this as is because the change would add more complexity and would probably cause some problems, without adding something useful. Therefore I'll reject this request. ---------------------------------------------------------------------- Comment By: Pavel Volkovitskiy (olfway) Date: 2009-04-10 14:59 Message: any chances of getting rid of such aliases after 2.3 release? ---------------------------------------------------------------------- Comment By: Charles (libertytrek) Date: 2009-04-10 14:03 Message: Hopefully we can all agree that, since this will add more complexity, it should most *definitely* *not* be added until after 2.3 is released... :) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2009-04-10 09:20 Message: I'm not (yet) in favour of this - my money is on leaving it as it is. ---------------------------------------------------------------------- Comment By: Pavel Volkovitskiy (olfway) Date: 2009-04-10 00:10 Message: select username from mailbox where domain = 'domain.tld' union select address from alias where domain = 'domain.tld'; that's tricky? ---------------------------------------------------------------------- Comment By: Pavel Volkovitskiy (olfway) Date: 2009-04-10 00:01 Message: you can use sql 'union' to merge selects from mailbox and alias table select a from t1 union select a from t2 (can be wrong in details, but it's easy and not tricky at all) one simple selects union vs magic "if removing alias, also removing mailbox, real_alias, force_delete" - union clearly wins imho real word problem: i had to restore mailbox once, after i removed alias and postfixadmin removes mailbox just in case ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2009-04-09 23:52 Message: IIRC, Postfix first checks the alias maps and, if it doesn't find a match, the mailbox maps. This means that you'll never reach a mailbox if your domain has a catchall address. There might be some very tricky SQL query to solve this, but having an alias for every mailbox is the easiest (and easy to understand) solution. Yes, if you delete a mailbox or mailbox alias, postfixadmin removes both the mailbox and its alias. (This is basically a feature because the alias would loop to itsself without the mailbox.) Yes, these aliases add some complexity to the code - but they allow to have a much simpler SQL query in postfix. So it's worth it IMHO. Having an option to disable these aliases would add more complexity ("if $maintain_magic_aliases then run_existing_code"), and until now I'm not sure if there is any benefit. My question remains - did you hit any real-world problem with this? ---------------------------------------------------------------------- Comment By: Pavel Volkovitskiy (olfway) Date: 2009-04-09 23:10 Message: catchall alias can be configured without such alias-for-every-mailbox scheme, at least it works with exim here and i'm sure it can be configured with postfix too magic is bad, with one of previous snapshot it removes mailbox then i removed alias for it also you have to remember about that if you doing some sql updates, especially if they hidden in web gui i think that these aliases just adds unneeded complexity to code by itself (looks in delete.php, for ex delete_alias) it seems it will remove fo...@do... alias if i remove fo...@do... mailbox? ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2009-04-09 22:26 Message: I know that the aliases for every mailbox is not always needed (but you'll need it if you use a catchall alias). OTOH, I'm not aware that it hurts in any situation. The worst thing I'm aware of are some wasted bytes in the alias table ;-) What is the reason for your request? Is there a usecase where the mailbox aliases cause any problems? If these aliases don't cause real-world problems, I'm not in favour of allowing to disable them. There might be some side effects (maybe in postfixadmin, maybe in the postfix configuration) and it adds some unneeded complexity to the code. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2661366&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 23:15:16
|
Bugs item #1865123, was opened at 2008-01-06 16:21 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1865123&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: SVN (please specify revision!) Status: Open Resolution: None >Priority: 4 Private: No Submitted By: Raphael Schmid (sixtyfive) Assigned to: Nobody/Anonymous (nobody) Summary: unclear that Superadmin is the admin of all existing domains Initial Comment: Right now, you have to manually add any new domain to the superadmin. This should be done automatically. (Rev. 286) ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-01-10 20:05 Message: Logged In: NO Hi Christian, what about a simplified version of your idea #2: Idea 2.1: Show "All domains" as the first item of the list box when logged in as superadmin. Cheers, Raphael ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-01-06 22:10 Message: Logged In: YES user_id=593261 Originator: NO Idea 1: Simply add a note "Super admins have access to all domains, can manage domains and admin accounts." Idea 2, more work: radio buttons Domains: ( ) all domains (super admin) *) ( ) the following domains [listbox] *) not really a good text, because superadmins have more permissions (add/delete domains, edit domain settings, manage admins, ...) ---------------------------------------------------------------------- Comment By: Raphael Schmid (sixtyfive) Date: 2008-01-06 21:50 Message: Logged In: YES user_id=658318 Originator: YES Probably yeah... sorry, I might not have looked too closely. This _is_ a UI design problem however... ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-01-06 18:10 Message: Logged In: YES user_id=1761957 Originator: NO Errm.. a superadmin can edit any domain; note the checkbox _overrides_ any domains selected through the edit-admin page. (Perhaps the UI needs modifying to make this obvious however) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1865123&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 23:13:23
|
Bugs item #1951979, was opened at 2008-04-26 00:55 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1951979&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Interface (example) Group: SVN (please specify revision!) Status: Open Resolution: None >Priority: 4 Private: No Submitted By: Christian Boltz (christian_boltz) Assigned to: Nobody/Anonymous (nobody) Summary: create mailbox/admin ignore $CONF['min_password_length'] Initial Comment: create mailbox and create admin don't honor $CONF['min_password_length'] (edit mailbox / admin is OK) Not sure if we should fix it or if we should invest the time to merge edit and create (see fetchmail.php for an example)... (NOT a blocker for 2.2) ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-04-26 00:57 Message: Logged In: YES user_id=593261 Originator: YES (found in SVN r343) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1951979&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 23:13:04
|
Bugs item #2021826, was opened at 2008-07-18 22:39 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2021826&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None >Priority: 4 Private: No Submitted By: Christian Boltz (christian_boltz) Assigned to: Nobody/Anonymous (nobody) Summary: edit-alias allows empty alias when vacation is on Initial Comment: It's possible to set an empty alias goto, see https://sourceforge.net/forum/message.php?msg_id=5104264 for details. Most important is the reproducer: Usually edit-mailbox errors out if you clear all target addresses. But I found a way to work around this safety net :-( Reproducer: - enable vacation - edit the alias for the mailbox, remove us...@ex... (so that only the vacation address remains) - disable vacation -> the alias now has an empty target Possible solutions: - the vacation alias should be ignored when testing if the alias target is empty - the vacation alias should not even be listed in the target list (print a "vacation is on" note instead) Needs to be tested with users/edit-alias also. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2021826&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 23:10:06
|
Bugs item #2782818, was opened at 2009-04-28 14:55 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2782818&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None >Priority: 4 Private: No Submitted By: Christian Boltz (christian_boltz) Assigned to: Nobody/Anonymous (nobody) Summary: search doesn't filter out mailbox aliases Initial Comment: Search results contain the mailbox aliases in the "Aliases" section. They should be filtered out and only be listed in the "Mailboxes" section. Better solution - merge search and list-virtual. Wichout having looked at it, the differences are probably only: - a different WHERE clause ;-) (searching for the entered text, not for a domain) - highlighting of search matches - (maybe: hide the "create alias"/"create mailbox" links) Everything else should work with the same code. Using the code from list-virtual is probably the better idea because it is used/tested more often. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2782818&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 22:59:17
|
Bugs item #2797690, was opened at 2009-05-28 04:27 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2797690&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Core Group: v 2.3 Status: Open Resolution: None >Priority: 6 Private: No Submitted By: Bjorn (bjornnilsen) Assigned to: Nobody/Anonymous (nobody) Summary: When domain is deleted any domain aliases are not removed Initial Comment: When domain is deleted any related domain aliases are not removed. This occurs for both the domain and the aliased domain. I am not sure if this causes any real world problems but it certainly is not tidy :) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2797690&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 22:58:21
|
Bugs item #2821172, was opened at 2009-07-14 09:33 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2821172&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Vacation Group: v 2.3 Status: Open Resolution: None >Priority: 6 Private: No Submitted By: Ulf Simmer (ulfsimmer) Assigned to: Nobody/Anonymous (nobody) Summary: \r\n visible in automatic answer Initial Comment: When enabling vacation, the original sender gets the (automatic) answer with visible \r\n (carriage return, new line). Perl is v5.8.9 2009/07/14 09:14:04 DEBUG> /home/vacation/vacation.pl:401 main::send_vacation_email - Vacation response sent, Mail::Sendmail said : Mail::Sendmail v. 0.79 - Tue Jul 1 4 09:14:04 2009 ---------------------------------------------------------------------- Comment By: Ulf Simmer (ulfsimmer) Date: 2009-07-28 15:18 Message: it's from 2.3rc2 #!/usr/bin/perl -w # # Virtual Vacation 4.0 # $Revision: 535 $ # Originally by Mischa Peters <mischa at high5 dot net> # ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2009-07-28 13:48 Message: any idea of what version of vacation.pl you are using? Is it from e.g. svn or an older release? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2821172&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 22:57:17
|
Bugs item #2835877, was opened at 2009-08-12 00:23 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2835877&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Vacation Group: None Status: Open Resolution: None >Priority: 6 Private: No Submitted By: Stevan Bajic (sbajic) Assigned to: Nobody/Anonymous (nobody) Summary: Small SQL error in vacation Initial Comment: Hello all there is a small error in one of the SQL clauses for vacation. The problem is in this part here: # Recipient has vacation if ($rv == 1) { $realemail = $email; $logger->debug("Found '\$email'\ has vacation active"); } else { $logger->debug("Looking for alias records that \'$email\' resolves to with vacation turned on"); $query = qq{SELECT goto FROM alias WHERE address=? AND (goto LIKE ?,% OR goto LIKE %,? OR goto LIKE %,?,%)}; $stm = $dbh->prepare($query) or panic_prepare($query); $stm->execute($email,$email,$email,$email) or panic_execute($query,"address='$email'"); $rv = $stm->rows; That should be: # Recipient has vacation if ($rv == 1) { $realemail = $email; $logger->debug("Found '\$email'\ has vacation active"); } else { my $vemail = $email; $vemail =~ s/\@/#/g; $logger->debug("Looking for alias records that \'$email\' resolves to with vacation turned on"); $query = qq{SELECT goto FROM alias WHERE address=? AND (goto LIKE ? OR goto LIKE ? OR goto LIKE ?)}; $stm = $dbh->prepare($query) or panic_prepare($query); $stm->execute($email,$vemail.",%","%,".$vemail,"%,".$vemail.",%") or panic_execute($query,"address='$email'"); $rv = $stm->rows; ---------------------------------------------------------------------- Comment By: Stevan Bajic (sbajic) Date: 2009-08-12 08:39 Message: It's morning and I make to much errors. The message should be: ------ Hallo gingerdog The $vemail is needed. Let me explain: Normal email: us...@do... Vacation domain: myvacation.local Now Postfix.Admin will add this alias if vacation is active: user#dom...@my... So we need to replace in the original email the @ with an # in order to be able to match against it. And then the SQL clause checking that should be: SELECT goto FROM alias WHERE address='us...@do...' AND (goto LIKE 'user#domain.com@%' OR goto LIKE '%,user#domain.com@%' ) ------ ---------------------------------------------------------------------- Comment By: Stevan Bajic (sbajic) Date: 2009-08-12 08:36 Message: Halo gingerdog The $vemail is needed. Let me explain: Normal email: us...@do... Vacation domain: myvacation.local Now Postfix.Admin will add this alias if vacation is active: user#dom...@my... And then the SQL clause checking that should be: SELECT goto FROM alias WHERE address='us...@do...' AND (goto LIKE 'user#domain.com@%' OR goto LIKE '%,us...@do...@%' ) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2009-08-12 08:21 Message: Err.. I can see the initial problem with the comma's being placed outside of the bound parameters... and this should be fixed. What are you doing with the $vemail parameter though? ---------------------------------------------------------------------- Comment By: Stevan Bajic (sbajic) Date: 2009-08-12 07:59 Message: Aggrr! Again wrong. This one is the right one: # Recipient has vacation if ($rv == 1) { $realemail = $email; $logger->debug("Found '\$email'\ has vacation active"); } else { my $vemail = $email; $vemail =~ s/\@/#/g; $logger->debug("Looking for alias records that \'$email\' resolves to with vacation turned on"); $query = qq{SELECT goto FROM alias WHERE address=? AND (goto LIKE ? OR goto LIKE ?)}; $stm = $dbh->prepare($query) or panic_prepare($query); $stm->execute($email,$vemail."@%","%,".$vemail."@%") or panic_execute($query,"address='$email'"); $rv = $stm->rows; ---------------------------------------------------------------------- Comment By: Stevan Bajic (sbajic) Date: 2009-08-12 07:58 Message: I looked again at the SQL clause and my above posted code is wrong. The fixed code should be: # Recipient has vacation if ($rv == 1) { $realemail = $email; $logger->debug("Found '\$email'\ has vacation active"); } else { my $vemail = $email; $vemail =~ s/\@/#/g; $logger->debug("Looking for alias records that \'$email\' resolves to with vacation turned on"); $query = qq{SELECT goto FROM alias WHERE address=? AND (goto LIKE ? OR goto LIKE ??)}; $stm = $dbh->prepare($query) or panic_prepare($query); $stm->execute($email,$vemail."@%","%,".$vemail."@%") or panic_execute($query,"address='$email'"); $rv = $stm->rows; ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2835877&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 22:52:45
|
Bugs item #1830742, was opened at 2007-11-13 00:14 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1830742&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: SVN (please specify revision!) >Status: Closed >Resolution: Out of Date Priority: 1 Private: No Submitted By: Christian Boltz (christian_boltz) Assigned to: Nobody/Anonymous (nobody) Summary: unused column "quota" in domain table Initial Comment: (split off from https://sourceforge.net/tracker/index.php?func=detail&aid=1829511&group_id=191583&atid=937964) It seems the "quota" field in domain table is not used anywhere. The actual quota is stored in "maxquota". -> we should drop the column after 2.2 is released ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2009-10-19 00:52 Message: This column will be used by the upcoming "total quota per domain" feature. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-05-19 23:57 Message: Logged In: NO Quota is being used in the SVN version in the mailbox table. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1830742&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 22:44:45
|
Bugs item #2794247, was opened at 2009-05-20 09:41 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2794247&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.3 >Status: Closed >Resolution: Fixed Priority: 9 Private: No Submitted By: wizard (wvolz) Assigned to: Nobody/Anonymous (nobody) Summary: users are not shown when initial email is not sent Initial Comment: The database query used when "vacation_control_admin" and "used_quotas" are enabled will not show a new user if the admin unchecks the send welcome email option. In particular the issue is that "quota/storage" doesn't exist. Query for reference: $query = "SELECT $table_mailbox.*, $table_vacation.active AS v_active, $table_quota.current FROM $table_mailbox LEFT JOIN $table_vacation ON $table_mailbox.username=$table_vacation.email LEFT JOIN $table_quota ON $table_mailbox.username=$table_quota.username WHERE $table_mailbox.domain ='$fDomain' AND $table_quota.path='quota/storage' ORDER BY $table_mailbox.username LIMIT $page_size OFFSET $fDisplay"; ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2009-10-19 00:44 Message: Fixed in SVN r730 - thanks for reporting this issue! ---------------------------------------------------------------------- Comment By: wizard (wvolz) Date: 2009-09-11 03:16 Message: The initial title was correct. If a email is not sent to a newly created account the user does not show up in postfixadmin even though they exist in the database. There is a thread on the mailing list where users are talking about this as well, see https://sourceforge.net/mailarchive/message.php?msg_name=alpine.LFD.2.00.0904270925190.4731%40tigger.tntechs.com. ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2009-08-25 01:14 Message: (original summary was: "New accounts are not shown when welcome email is not sent") The table "quota" is not created by upgrade.php - it's hidden in DOCUMENTS/DOVECOT.txt. Create database in mysql: create table quota ( username varchar(255) not null, path varchar(100) not null, current integer, primary key (username, path) ); IMHO this query should be changed/extended a bit to avoid the usual problems: CREATE TABLE {IF_NOT_EXISTS} `quota` ( `username` VARCHAR(255) {LATIN1} NOT NULL, `path` VARCHAR(100) {LATIN1} NOT NULL, `current` BIGINT(20), # allow quota > 2 GB PRIMARY KEY `username_path` (username, path) ) TYPE=MyISAM ; GingerDog, what's the query for postgresql? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2794247&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 07:29:18
|
Patches item #2856577, was opened at 2009-09-10 19:11 Message generated for change (Settings changed) made by wvolz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937966&aid=2856577&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Core Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: wizard (wvolz) Assigned to: Nobody/Anonymous (nobody) >Summary: Add domain quota in addition to max mailbox size Initial Comment: This patch changes the behavior of the domain quota from per mailbox to per domain. Users are shown how much they have to allocate between mailboxes when editing and creating new mailboxes. The only change needed is a flag to enable this behavior. ---------------------------------------------------------------------- Comment By: wizard (wvolz) Date: 2009-10-18 01:28 Message: New patch. This version of the previous patch adds the ability to set a maximum mailbox size and/or a domain quota. You can also have combinations of the two. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937966&aid=2856577&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-10-18 07:28:09
|
Patches item #2856577, was opened at 2009-09-10 19:11 Message generated for change (Comment added) made by wvolz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937966&aid=2856577&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Core Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: wizard (wvolz) Assigned to: Nobody/Anonymous (nobody) Summary: Modify quota to be for the whole domain Initial Comment: This patch changes the behavior of the domain quota from per mailbox to per domain. Users are shown how much they have to allocate between mailboxes when editing and creating new mailboxes. The only change needed is a flag to enable this behavior. ---------------------------------------------------------------------- >Comment By: wizard (wvolz) Date: 2009-10-18 01:28 Message: New patch. This version of the previous patch adds the ability to set a maximum mailbox size and/or a domain quota. You can also have combinations of the two. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937966&aid=2856577&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-09-26 20:05:44
|
Patches item #2867629, was opened at 2009-09-26 14:05 Message generated for change (Tracker Item Submitted) made by wvolz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937966&aid=2867629&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: wizard (wvolz) Assigned to: Nobody/Anonymous (nobody) Summary: Add support for viewing dovecot v1.2 quotas Initial Comment: Dovecot v1.2 changed the way quota information is stored and so display of used quotas no longer works. This patch adds a config variable "dovecot_version" and modifies list_virtual to work with v1.2 quotas when the config variable is set. This patch also removes some un-needed code specific for postgres and fixes a bug that prevents used quota display when 'vacation_control_admin' is disabled. The patch is against 2.3rc7. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937966&aid=2867629&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-09-24 11:55:56
|
Bugs item #2864890, was opened at 2009-09-23 11:52 Message generated for change (Comment added) made by mikaelost You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2864890&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Interface (example) Group: v 2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Mikael Österberg (mikaelost) Assigned to: Nobody/Anonymous (nobody) Summary: Save alias edit Initial Comment: Warning: in_array() [function.in-array]: Wrong datatype for second argument in /var/www-webmail/postfixadmin/edit-alias.php on line 129 Warning: Cannot modify header information - headers already sent by (output started at /var/www-webmail/postfixadmin/edit-alias.php:129) in /var/www-webmail/postfixadmin/edit-alias.php on line 165 ---------------------------------------------------------------------- >Comment By: Mikael Österberg (mikaelost) Date: 2009-09-24 13:55 Message: $CONF['default_aliases'] = array ( 'abuse' => 'ab...@ro...', 'hostmaster' => 'hostmasterArocksolidDOTse', 'postmaster' => 'postmasterArocksolidDOTse', 'webmaster' => 'webmasterArocksolidDOTse' ); No SPMA 4me: In file A is @, DOT is . ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2009-09-24 13:49 Message: edit-alias.php, line 129 is: if (in_array($address, $CONF['default_aliases'])) continue; What is your setting in $CONF['default_aliases'] ? (see config.inc.php / config.local.php) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2864890&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-09-24 11:49:12
|
Bugs item #2864890, was opened at 2009-09-23 11:52 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2864890&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Interface (example) Group: v 2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Mikael Österberg (mikaelost) Assigned to: Nobody/Anonymous (nobody) Summary: Save alias edit Initial Comment: Warning: in_array() [function.in-array]: Wrong datatype for second argument in /var/www-webmail/postfixadmin/edit-alias.php on line 129 Warning: Cannot modify header information - headers already sent by (output started at /var/www-webmail/postfixadmin/edit-alias.php:129) in /var/www-webmail/postfixadmin/edit-alias.php on line 165 ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2009-09-24 13:49 Message: edit-alias.php, line 129 is: if (in_array($address, $CONF['default_aliases'])) continue; What is your setting in $CONF['default_aliases'] ? (see config.inc.php / config.local.php) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2864890&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-09-23 09:52:53
|
Bugs item #2864890, was opened at 2009-09-23 11:52 Message generated for change (Tracker Item Submitted) made by mikaelost You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2864890&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Interface (example) Group: v 2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Mikael Österberg (mikaelost) Assigned to: Nobody/Anonymous (nobody) Summary: Save alias edit Initial Comment: Warning: in_array() [function.in-array]: Wrong datatype for second argument in /var/www-webmail/postfixadmin/edit-alias.php on line 129 Warning: Cannot modify header information - headers already sent by (output started at /var/www-webmail/postfixadmin/edit-alias.php:129) in /var/www-webmail/postfixadmin/edit-alias.php on line 165 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2864890&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-09-16 22:15:29
|
Bugs item #2860326, was opened at 2009-09-17 00:15 Message generated for change (Tracker Item Submitted) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2860326&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: SVN (please specify revision!) Status: Open Resolution: None Priority: 5 Private: No Submitted By: Christian Boltz (christian_boltz) Assigned to: Nobody/Anonymous (nobody) Summary: Domain "ALL" is shown after manually modifying the database Initial Comment: SVN r718 Reproducer: - fresh database (existing database should also work) - create admin "a@b" with setup.php - DELETE FROM 'admin' WHERE username = "a@b" directly in MySQL / pgsql - create admin "a@b" with setup.php again Results: - list-domains shows domain "ALL" twice - a@b is not recognized as superadmin The reason for the first domain is the query for domain admins in list-domain.php which does not exclude 'ALL'. The reason for the second problem is the code in setup.php: $result = db_query ("SELECT * FROM $table_domain_admins WHERE username='$fUsername' AND domain='ALL' AND active='1'"); if ($result['rows'] == 1) (hint: 2 != 1) The correct fix is to add an UNIQUE index on (username,domain) in domain_admins to avoid duplicate entries. (To be fixed after 2.3 release because it is a corner case and adding the index might break if the database was manually modified as described before.) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2860326&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2009-09-15 09:43:34
|
Bugs item #2859165, was opened at 2009-09-15 12:43 Message generated for change (Tracker Item Submitted) made by ksb4ever You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2859165&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: ksb (ksb4ever) Assigned to: Nobody/Anonymous (nobody) Summary: domain list incorrect SELECT Initial Comment: Hi! 2.3rc7 For me list-domain.php gives an error: DEBUG INFORMATION: Invalid query: ERROR: column "domain.uid" must appear in the GROUP BY clause or be used in an aggregate function So as I have uid and gid columns (used by dovecot) in domain and mailboxes tables (now filled with default values) error comes out. Backend - ppostgresql. # fetch domain data and number of mailboxes # (PgSQL requires the extensive GROUP BY statement, https://sourceforge.net/forum/message.php?msg_id=7386240) $query = " SELECT domain.* , COUNT( DISTINCT mailbox.username ) AS mailbox_count FROM domain LEFT JOIN mailbox ON domain.domain = mailbox.domain $where GROUP BY domain.domain, domain.description, domain.aliases, domain.mailboxes, domain.maxquota, domain.quota, domain.transport, domain.backupmx, domain.created, domain.modified, domain.active ORDER BY domain.domain "; $result = db_query($query); Good comment, yeah ;) but no so good practice to use "SELECT * " even it isn't postgresql and without GROUP BY clause. I think, best way to resove this problem would be exact select of columns! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2859165&group_id=191583 |
700 messages has been excluded from this view by a project administrator.
