postfixadmin-tracker — Postfix Admin tracker notification - READ ONLY!

[postfixadmin:feature-requests] #40 Installer - check perms to create tables etc

[Christian B. <chr...@us...>]

- **status**: open --> closed-works-for-me
- **Comment**:

setup.php comes with a note to use ?debug=1 if something fails, and with that, it will print out all queries it runs.

I know failing ist not really a permission check, but IMHO it's good enough ;-)  Nevertheless, I'll accept patches that do it 100% correct for mysql, postgresql and sqlite ;-)



---

** [feature-requests:#40] Installer - check perms to create tables etc**

**Status:** closed-works-for-me
**Group:** SVN (please specify revision!)
**Created:** Sun Jun 08, 2008 07:39 AM UTC by GingerDog
**Last Updated:** Sun Dec 01, 2013 09:57 PM UTC
**Owner:** nobody


Quite a few users seem to run into problems on installation regarding the ability to create tables within their db.

The installer \(setup.php\) should check to see whether the db user can create tables within the database, and if not, it should write out the SQL to screen for the user to run.
\(Presumably this is just a case of doing "echo $sql" rather than "db\_query\($sql\)"\)

The user can then be responsible for copy & pasting the SQL in as appropriate.


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/feature-requests/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/feature-requests/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:feature-requests] #118 Move to git

[Christian B. <chr...@us...>]

- **status**: open --> closed-fixed
- **Comment**:

As you might have noticed, we officiallly moved development to github after the 3.0.2 release.



---

** [feature-requests:#118] Move to git**

**Status:** closed-fixed
**Group:** SVN (please specify revision!)
**Labels:** git 
**Created:** Mon Sep 22, 2014 10:22 PM UTC by Peter "mash" Morgan
**Last Updated:** Sun Oct 05, 2014 10:45 PM UTC
**Owner:** nobody


Are there any plans to move to git, so submitting and playing with patches is easier.. please ;-)


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/feature-requests/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/feature-requests/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:patches] #121 multiple hash algorithms using system's crypt in pacrypt

[Magnus S. <mst...@us...>]

Same patch for 3.0.2.
Tested on CentOS 7.


Attachments:

- [functions.inc.php.patch](https://sourceforge.net/p/postfixadmin/patches/_discuss/thread/cab097a0/33e3/attachment/functions.inc.php.patch) (3.5 kB; application/octet-stream)


---

** [patches:#121] multiple hash algorithms using system's crypt in pacrypt**

**Status:** open
**Group:** SVN (please specify revision!)
**Created:** Fri Aug 30, 2013 11:34 AM UTC by Magnus Stenman
**Last Updated:** Sun Jul 12, 2015 12:45 PM UTC
**Owner:** nobody
**Attachments:**

- [functions.inc.php.patch](https://sourceforge.net/p/postfixadmin/patches/121/attachment/functions.inc.php.patch) (2.8 kB; text/x-diff)


This patch adds another $CONF['encrypt'] type, 'php_crypt', which uses the PHP crypt() function, which in turn uses the system's crypt() (much like the current 'system' type in postfixadmin-2.3.6)

The difference to the current 'system' type is that you can choose which hash type you want to use for new passwords. (currently DES, MD5, Blowfish, SHA256, SHA512; defaults to )

The current 'system' type only generates MD5 hashes with 2-character salt.


I do not have 'dovecotpw' on my system so that was not an option.

It does not interfere with existing 'encrypt' types, but could be incorporated into the 'system' type.
Tested on CentOS 5 and 6, Dovecot 2 and Postfix.


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/patches/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/patches/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #375 Invalid query: Table 'mail.admin' doesn't exist

[Christian B. <chr...@us...>]

- **status**: open --> closed-invalid
- **Comment**:

I'm afraid I can't help if you don't answer my questions :-(

Feel free to reopen when you can provide the requested information.



---

** [bugs:#375] Invalid query: Table 'mail.admin' doesn't exist**

**Status:** closed-invalid
**Group:** SVN (please specify revision!)
**Created:** Mon Jun 06, 2016 09:01 AM UTC by Wouter Dijk
**Last Updated:** Thu Aug 25, 2016 05:33 PM UTC
**Owner:** nobody


I try to upgrade an existing posfixadmin install to the most recent GIT version, but when executing setup.php?debug=1 I keep getting this error:

~~~
Everything seems fine... attempting to create/update database structure

CREATE TABLE IF NOT EXISTS config ( `id` int(11) not null auto_increment primary key, `name` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', `value` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', UNIQUE name ( `name` ) ) ENGINE = MYISAM COMMENT = 'PostfixAdmin settings'

Updating database:

- old version: 1282; target version: 1835

  (If the update doesn't work, run setup.php?debug=1 to see the detailed error messages and SQL queries.)
updating to version 1283 (MySQL and PgSQL)...

DEBUG INFORMATION:
Invalid query: Table 'mail.admin' doesn't exist

Check your error_log for the failed query.
~~~
My mailserver is working perfectly, but I can't get postfixadmin to work. Can you help me?


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:patches] #133 View logs fix

[Christian B. <chr...@us...>]

- **status**: open --> closed-accepted
- **Comment**:

Nice improvement, hanks for the patch! I commited it to git (67a6d0e27a5b4c9cb843684385eb7a46aea2f9c1), will be in 3.0.3 or 3.1 - whatever number  the next release will have ;-)

FYI: I wrapped $CONF['page_size'] in `intval()` to make sure a broken page_size setting can't break the query.

BTW: On the long term, I'd like to use list.php instead of viewlog.php, but that's a bit more work ;-)



---

** [patches:#133] View logs fix**

**Status:** closed-accepted
**Group:** SVN (please specify revision!)
**Labels:** log 
**Created:** Tue Sep 20, 2016 08:08 AM UTC by Dan
**Last Updated:** Tue Sep 20, 2016 08:08 AM UTC
**Owner:** nobody
**Attachments:**

- [postadmin.patch](https://sourceforge.net/p/postfixadmin/patches/133/attachment/postadmin.patch) (21.7 kB; text/x-patch)


Hello, i created a patch wich replace hard-coded 10 last lines in viewlog and replace it with $CONF[page_size] as defined in config.php. Also i patched all languages files to reflect changes.


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/patches/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/patches/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #379 Setup fails on MySQL with non-Latin1 as default charset

[Christian B. <chr...@us...>]

- **status**: open --> closed-fixed
- **Comment**:

Thanks for the confirmation that the latest upgrade.php works :-)

I'll close this bug as fixed (in 3.0.3 or 3.1, whatever number the next release will have)



---

** [bugs:#379] Setup fails on MySQL with non-Latin1 as default charset**

**Status:** closed-fixed
**Group:** v3.0
**Created:** Sat Sep 17, 2016 11:54 PM UTC by M. Buecher
**Last Updated:** Thu Mar 02, 2017 10:46 PM UTC
**Owner:** nobody


Experienced on Debian 8 with package postfixadmin 2.3.7-1 with MySQL 5.5.
An initial setup of postfixadmin with MySQL fails when a multi-byte charset is used as default (e.g. utf8mb4) due to key length limitiations. UTF8MB4 is need for 100% Unicode support as UTF8 has limitations in MySQL (https://mathiasbynens.be/notes/mysql-utf8mb4).

Error messages:
Invalid query: Specified key was too long; max key length is 767 bytes  (for [InnoDB key column](http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html))
Invalid query: Specified key was too long; max key length is 1000 bytes  (for [MyISAM table key](http://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html))

Please consider adding settings in config.inc.php to specify the lengths of the following fields:
* domain
* username
* address
* alias_domain
* email

This will allow users to reduce the character length to keep the byte count under the key length limitation, while keeping a multi-byte charset as default for names, texts, etc.
Additionally remove please the LATIN1 definitions for complete tables (see list at the end of the report).


Otherwise specify LATIN1 on these fields in the CREATE statements of function upgrade_1_mysql() of upgrade.php, while keeping the MySQL default charset on the table and other fields.
Additionally please remove the LATIN1 definitions for complete tables and replace it with a LATIN1 definition only for the above mentions fields.
upgrade_1_mysql(): vacation table
upgrade_5_mysql(): all tables
upgrade_81_mysql(): vacation
upgrade_473_mysql: all tables



---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] Re: #379 Setup fails on MySQL with non-Latin1 as default charset

[Paul P. <pa...@us...>]

I did make a mistake. I forgot to insert "<?php" in the first line of config.local.php ...

Now the admin got created with setup.php and I can login. 

Perfect!


---

** [bugs:#379] Setup fails on MySQL with non-Latin1 as default charset**

**Status:** open
**Group:** v3.0
**Created:** Sat Sep 17, 2016 11:54 PM UTC by M. Buecher
**Last Updated:** Thu Mar 02, 2017 10:46 PM UTC
**Owner:** nobody


Experienced on Debian 8 with package postfixadmin 2.3.7-1 with MySQL 5.5.
An initial setup of postfixadmin with MySQL fails when a multi-byte charset is used as default (e.g. utf8mb4) due to key length limitiations. UTF8MB4 is need for 100% Unicode support as UTF8 has limitations in MySQL (https://mathiasbynens.be/notes/mysql-utf8mb4).

Error messages:
Invalid query: Specified key was too long; max key length is 767 bytes  (for [InnoDB key column](http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html))
Invalid query: Specified key was too long; max key length is 1000 bytes  (for [MyISAM table key](http://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html))

Please consider adding settings in config.inc.php to specify the lengths of the following fields:
* domain
* username
* address
* alias_domain
* email

This will allow users to reduce the character length to keep the byte count under the key length limitation, while keeping a multi-byte charset as default for names, texts, etc.
Additionally remove please the LATIN1 definitions for complete tables (see list at the end of the report).


Otherwise specify LATIN1 on these fields in the CREATE statements of function upgrade_1_mysql() of upgrade.php, while keeping the MySQL default charset on the table and other fields.
Additionally please remove the LATIN1 definitions for complete tables and replace it with a LATIN1 definition only for the above mentions fields.
upgrade_1_mysql(): vacation table
upgrade_5_mysql(): all tables
upgrade_81_mysql(): vacation
upgrade_473_mysql: all tables



---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #379 Setup fails on MySQL with non-Latin1 as default charset

[Paul P. <pa...@us...>]

Thank you for your fast reply.

I copied the new upgrade.php into /usr/share/postfixadmin.

The setup now runs through: Database is up to date


In /etc/postfixadmin I created a new config.local.php and inserted the shown:

$CONF['setup_password'] = 'xxx'

The problem I have now is that this inserted one line phrase from that file is shown as the first line on the login or setup web pages.

And .. I cannot login with the newly created admin e-mail address and my password. I don't think that I made a mistake ...


---

** [bugs:#379] Setup fails on MySQL with non-Latin1 as default charset**

**Status:** open
**Group:** v3.0
**Created:** Sat Sep 17, 2016 11:54 PM UTC by M. Buecher
**Last Updated:** Thu Mar 02, 2017 06:09 PM UTC
**Owner:** nobody


Experienced on Debian 8 with package postfixadmin 2.3.7-1 with MySQL 5.5.
An initial setup of postfixadmin with MySQL fails when a multi-byte charset is used as default (e.g. utf8mb4) due to key length limitiations. UTF8MB4 is need for 100% Unicode support as UTF8 has limitations in MySQL (https://mathiasbynens.be/notes/mysql-utf8mb4).

Error messages:
Invalid query: Specified key was too long; max key length is 767 bytes  (for [InnoDB key column](http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html))
Invalid query: Specified key was too long; max key length is 1000 bytes  (for [MyISAM table key](http://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html))

Please consider adding settings in config.inc.php to specify the lengths of the following fields:
* domain
* username
* address
* alias_domain
* email

This will allow users to reduce the character length to keep the byte count under the key length limitation, while keeping a multi-byte charset as default for names, texts, etc.
Additionally remove please the LATIN1 definitions for complete tables (see list at the end of the report).


Otherwise specify LATIN1 on these fields in the CREATE statements of function upgrade_1_mysql() of upgrade.php, while keeping the MySQL default charset on the table and other fields.
Additionally please remove the LATIN1 definitions for complete tables and replace it with a LATIN1 definition only for the above mentions fields.
upgrade_1_mysql(): vacation table
upgrade_5_mysql(): all tables
upgrade_81_mysql(): vacation
upgrade_473_mysql: all tables



---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #379 Setup fails on MySQL with non-Latin1 as default charset

[Christian B. <chr...@us...>]

- **Comment**:

Can you please test with the latest upgrade.php from https://github.com/postfixadmin/postfixadmin ? I fixed several issues with overlong indexes (caused by utf8mb4) some days ago and at least one user confirmed that it works for him now.



---

** [bugs:#379] Setup fails on MySQL with non-Latin1 as default charset**

**Status:** open
**Group:** v3.0
**Created:** Sat Sep 17, 2016 11:54 PM UTC by M. Buecher
**Last Updated:** Wed Mar 01, 2017 10:10 PM UTC
**Owner:** nobody


Experienced on Debian 8 with package postfixadmin 2.3.7-1 with MySQL 5.5.
An initial setup of postfixadmin with MySQL fails when a multi-byte charset is used as default (e.g. utf8mb4) due to key length limitiations. UTF8MB4 is need for 100% Unicode support as UTF8 has limitations in MySQL (https://mathiasbynens.be/notes/mysql-utf8mb4).

Error messages:
Invalid query: Specified key was too long; max key length is 767 bytes  (for [InnoDB key column](http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html))
Invalid query: Specified key was too long; max key length is 1000 bytes  (for [MyISAM table key](http://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html))

Please consider adding settings in config.inc.php to specify the lengths of the following fields:
* domain
* username
* address
* alias_domain
* email

This will allow users to reduce the character length to keep the byte count under the key length limitation, while keeping a multi-byte charset as default for names, texts, etc.
Additionally remove please the LATIN1 definitions for complete tables (see list at the end of the report).


Otherwise specify LATIN1 on these fields in the CREATE statements of function upgrade_1_mysql() of upgrade.php, while keeping the MySQL default charset on the table and other fields.
Additionally please remove the LATIN1 definitions for complete tables and replace it with a LATIN1 definition only for the above mentions fields.
upgrade_1_mysql(): vacation table
upgrade_5_mysql(): all tables
upgrade_81_mysql(): vacation
upgrade_473_mysql: all tables



---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #379 Setup fails on MySQL with non-Latin1 as default charset

[Paul P. <pa...@us...>]

New deployment of version 3.02 on Debian Stretch with setup.php?debug=1 shows this:
...

Running software:

    PHP version 7.0.15-1
    Apache/2.4.25 (Debian)
...
   Depends on: MySQL 4.1 - OK
...
Everything seems fine... attempting to create/update database structure

CREATE TABLE IF NOT EXISTS config ( `id` int(11) not null auto_increment primary key, `name` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', `value` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', UNIQUE name ( `name` ) ) ENGINE = MYISAM COMMENT = 'PostfixAdmin settings'

Updating database:

- old version: 0; target version: 1835
  (If the update doesn't work, run setup.php?debug=1 to see the detailed error messages and SQL queries.)

updating to version 1 (MySQL)...

CREATE TABLE IF NOT EXISTS admin ( `username` varchar(255) NOT NULL default '', `password` varchar(255) NOT NULL default '', `created` datetime NOT NULL default '2000-01-01 00:00:00', `modified` datetime NOT NULL default '2000-01-01 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`username`) ) ENGINE=MyISAM COMMENT='Postfix Admin - Virtual Admins';

DEBUG INFORMATION:
Invalid query: Specified key was too long; max key length is 1000 bytes 


Changing the function to "upgrade_1_mysql_DISABLED()" does not help:

Now the output is like this:

Updating database:

- old version: 1; target version: 1835
  (If the update doesn't work, run setup.php?debug=1 to see the detailed error messages and SQL queries.)

updating to version 2 (MySQL)...

DEBUG INFORMATION:
Invalid query: Table 'postfixadmin.domain' doesn't exist 


---

** [bugs:#379] Setup fails on MySQL with non-Latin1 as default charset**

**Status:** open
**Group:** v3.0
**Created:** Sat Sep 17, 2016 11:54 PM UTC by M. Buecher
**Last Updated:** Sat Dec 17, 2016 08:21 PM UTC
**Owner:** nobody


Experienced on Debian 8 with package postfixadmin 2.3.7-1 with MySQL 5.5.
An initial setup of postfixadmin with MySQL fails when a multi-byte charset is used as default (e.g. utf8mb4) due to key length limitiations. UTF8MB4 is need for 100% Unicode support as UTF8 has limitations in MySQL (https://mathiasbynens.be/notes/mysql-utf8mb4).

Error messages:
Invalid query: Specified key was too long; max key length is 767 bytes  (for [InnoDB key column](http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html))
Invalid query: Specified key was too long; max key length is 1000 bytes  (for [MyISAM table key](http://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html))

Please consider adding settings in config.inc.php to specify the lengths of the following fields:
* domain
* username
* address
* alias_domain
* email

This will allow users to reduce the character length to keep the byte count under the key length limitation, while keeping a multi-byte charset as default for names, texts, etc.
Additionally remove please the LATIN1 definitions for complete tables (see list at the end of the report).


Otherwise specify LATIN1 on these fields in the CREATE statements of function upgrade_1_mysql() of upgrade.php, while keeping the MySQL default charset on the table and other fields.
Additionally please remove the LATIN1 definitions for complete tables and replace it with a LATIN1 definition only for the above mentions fields.
upgrade_1_mysql(): vacation table
upgrade_5_mysql(): all tables
upgrade_81_mysql(): vacation
upgrade_473_mysql: all tables



---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:patches] #134 Optional Version Number in Footer

[Christian B. <chr...@us...>]

I just accepted https://github.com/postfixadmin/postfixadmin/pull/19 which allows to hide the "check for updates" footer using a line of custom CSS.

I know this is not exactly what this patch asked for, but still - is this "good enough" for you? ;-)

@Rob: if the Debian packaging is still an issue for you in 3.0.2, please open a new issue on github to make sure it doesn't get lost.


---

** [patches:#134] Optional Version Number in Footer**

**Status:** open
**Group:** SVN (please specify revision!)
**Created:** Fri Sep 30, 2016 10:24 PM UTC by Daniel Laxar
**Last Updated:** Sat Nov 05, 2016 12:09 AM UTC
**Owner:** nobody
**Attachments:**

- [optional_version_in_footer.diff](https://sourceforge.net/p/postfixadmin/patches/134/attachment/optional_version_in_footer.diff) (1.5 kB; application/octet-stream)


Hi, 

I felt unsure about displaying the version number of PostfixAdmin on the frontpage (even to unauthorized users). That's why I've created the option to disable displaying of the version & update link.

The version and update link will remain in the footer **by default**. However this can now be changed using:
~~~
$CONF['show_version_in_footer'] = 'NO';
~~~

I've also changed indentation in the template file to use spaces on the codeblocks I've changed.

Thanks for considering this patch,
dlaxar





---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/patches/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/patches/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #366 Vacation.pl email subject for non ascii

[Christian B. <chr...@us...>]

- **status**: open-fixed --> closed-fixed



---

** [bugs:#366] Vacation.pl email subject for non ascii**

**Status:** closed-fixed
**Group:** v2.92 (3.0 beta2)
**Created:** Tue Mar 08, 2016 03:09 PM UTC by czbg
**Last Updated:** Wed Feb 08, 2017 08:37 PM UTC
**Owner:** nobody


If using $SUBJECT string to include original subject in reply, if email contains encoded subject (that is any email not originated from English speaking countries), it will be replied with a garbage subject, e.g. =?koi8-r?Q?FW:_=D3ritical_error?=

To fix this I only added two lines to vacation.pl:
use Encode; at the beginning

$orig_subject = decode("mime-header", $orig_subject); right before the line: my $subject = $row[0];

Please include this fix in the next release.


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #382 deb package has wrong dependencies for Jessie 8.0

[Christian B. <chr...@us...>]

- **status**: open-fixed --> closed-fixed



---

** [bugs:#382] deb package has wrong dependencies for Jessie 8.0**

**Status:** closed-fixed
**Group:** v3.0
**Labels:** deb 
**Created:** Wed Sep 21, 2016 08:51 PM UTC by Sebastian Günther
**Last Updated:** Wed Feb 08, 2017 08:35 PM UTC
**Owner:** nobody


See the following output:

~~~
dpkg -i postfixadmin_3.0.1-1_all.deb 
(Reading database ... 29888 files and directories currently installed.)
Preparing to unpack postfixadmin_3.0.1-1_all.deb ...
Unpacking postfixadmin (3.0.1-1) over (3.0.1-1) ...
dpkg: dependency problems prevent configuration of postfixadmin:
 postfixadmin depends on libapache2-mod-php | php-cgi | php; however:
  Package libapache2-mod-php is not installed.
  Package php-cgi is not installed.
  Package php is not installed.
 postfixadmin depends on php-imap; however:
  Package php-imap is not installed.
 postfixadmin depends on php-mysql | php-pgsql | php-mysqlnd | php-sqlite3; however:
  Package php-mysql is not installed.
  Package php-pgsql is not installed.
  Package php-mysqlnd is not installed.
  Package php-sqlite3 is not installed.

dpkg: error processing package postfixadmin (--install):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 postfixadmin
~~~

We do not have php-imap or alike on jessie, it is more like php**5**-imap.

Die you build this against stretch? And beware this is PHP 7.0 in stretch.


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #371 Apache Configuration File Not Created

[Christian B. <chr...@us...>]

- **status**: open-fixed --> closed-fixed



---

** [bugs:#371] Apache Configuration File Not Created**

**Status:** closed-fixed
**Group:** v2.3.8
**Created:** Thu Apr 21, 2016 07:02 PM UTC by Rob
**Last Updated:** Wed Feb 08, 2017 08:37 PM UTC
**Owner:** nobody


I installed this via dpkg on Debian 8.4 it did not install an Apache configuration file in /etc/apache2/conf-available or conf-enabled.


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #376 Cleanup /usr/share/postfixadmin/templates_c on update

[Christian B. <chr...@us...>]

- **status**: open-fixed --> closed-fixed



---

** [bugs:#376] Cleanup /usr/share/postfixadmin/templates_c on update**

**Status:** closed-fixed
**Group:** v2.93 (3.0 beta3)
**Created:** Mon Jun 06, 2016 10:42 PM UTC by Andreas Gockel
**Last Updated:** Wed Feb 08, 2017 08:36 PM UTC
**Owner:** nobody


After upgrading from 2.92 to 2.93 (via .deb) i was unable to open the domain overview (404 list-domain.php). After searching the package, i've found no leftover from the old url. Then after looking at the installed stuff, i've found the /usr/share/postfixadmin/templates_c diretory still comtaining the old stuff. After cleaning up that directory, the domain overview worked again.

b.t.w.: that directory should be placed under /var as it contains cache data.


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #366 Vacation.pl email subject for non ascii

[GingerDog <gin...@us...>]

- **status**: open --> open-fixed
- **Comment**:

will presumably be in the 3.0.2 release.



---

** [bugs:#366] Vacation.pl email subject for non ascii**

**Status:** open-fixed
**Group:** v2.92 (3.0 beta2)
**Created:** Tue Mar 08, 2016 03:09 PM UTC by czbg
**Last Updated:** Thu Aug 25, 2016 07:03 PM UTC
**Owner:** nobody


If using $SUBJECT string to include original subject in reply, if email contains encoded subject (that is any email not originated from English speaking countries), it will be replied with a garbage subject, e.g. =?koi8-r?Q?FW:_=D3ritical_error?=

To fix this I only added two lines to vacation.pl:
use Encode; at the beginning

$orig_subject = decode("mime-header", $orig_subject); right before the line: my $subject = $row[0];

Please include this fix in the next release.


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #371 Apache Configuration File Not Created

[GingerDog <gin...@us...>]

- **status**: open --> open-fixed
- **Comment**:

not a problem in 3.0.2... probably fixed in 3.0.0?



---

** [bugs:#371] Apache Configuration File Not Created**

**Status:** open-fixed
**Group:** v2.3.8
**Created:** Thu Apr 21, 2016 07:02 PM UTC by Rob
**Last Updated:** Thu May 05, 2016 02:58 PM UTC
**Owner:** nobody


I installed this via dpkg on Debian 8.4 it did not install an Apache configuration file in /etc/apache2/conf-available or conf-enabled.


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #376 Cleanup /usr/share/postfixadmin/templates_c on update

[GingerDog <gin...@us...>]

- **status**: pending --> open-fixed
- **Comment**:

fixed in 3.0.2... (and probably 3.0.1)



---

** [bugs:#376] Cleanup /usr/share/postfixadmin/templates_c on update**

**Status:** open-fixed
**Group:** v2.93 (3.0 beta3)
**Created:** Mon Jun 06, 2016 10:42 PM UTC by Andreas Gockel
**Last Updated:** Wed Dec 21, 2016 09:33 PM UTC
**Owner:** nobody


After upgrading from 2.92 to 2.93 (via .deb) i was unable to open the domain overview (404 list-domain.php). After searching the package, i've found no leftover from the old url. Then after looking at the installed stuff, i've found the /usr/share/postfixadmin/templates_c diretory still comtaining the old stuff. After cleaning up that directory, the domain overview worked again.

b.t.w.: that directory should be placed under /var as it contains cache data.


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #382 deb package has wrong dependencies for Jessie 8.0

[GingerDog <gin...@us...>]

- **status**: open --> open-fixed
- **Comment**:

should be fixed in 3.0.2....



---

** [bugs:#382] deb package has wrong dependencies for Jessie 8.0**

**Status:** open-fixed
**Group:** v3.0
**Labels:** deb 
**Created:** Wed Sep 21, 2016 08:51 PM UTC by Sebastian Günther
**Last Updated:** Wed Dec 21, 2016 09:20 PM UTC
**Owner:** nobody


See the following output:

~~~
dpkg -i postfixadmin_3.0.1-1_all.deb 
(Reading database ... 29888 files and directories currently installed.)
Preparing to unpack postfixadmin_3.0.1-1_all.deb ...
Unpacking postfixadmin (3.0.1-1) over (3.0.1-1) ...
dpkg: dependency problems prevent configuration of postfixadmin:
 postfixadmin depends on libapache2-mod-php | php-cgi | php; however:
  Package libapache2-mod-php is not installed.
  Package php-cgi is not installed.
  Package php is not installed.
 postfixadmin depends on php-imap; however:
  Package php-imap is not installed.
 postfixadmin depends on php-mysql | php-pgsql | php-mysqlnd | php-sqlite3; however:
  Package php-mysql is not installed.
  Package php-pgsql is not installed.
  Package php-mysqlnd is not installed.
  Package php-sqlite3 is not installed.

dpkg: error processing package postfixadmin (--install):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 postfixadmin
~~~

We do not have php-imap or alike on jessie, it is more like php**5**-imap.

Die you build this against stretch? And beware this is PHP 7.0 in stretch.


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #294 Postfix admin does not check 'postfix' as a dependency.

[GingerDog <gin...@us...>]

- **status**: open --> closed-wont-fix



---

** [bugs:#294] Postfix admin does not check 'postfix' as a dependency.**

**Status:** closed-wont-fix
**Group:** v2.3.6
**Created:** Mon Jun 24, 2013 06:42 AM UTC by Dotan Cohen
**Last Updated:** Wed Jun 26, 2013 04:55 PM UTC
**Owner:** nobody


It seems that postfixadmin does not check that postfix is actually installed when checking dependencies. This should be checked!

I'm not really sure how a non-root user could check, possibly only by grepping /usr/sbin for the existence of 'postfix'. The postfix binary does not even allow version checking for non-root users.     


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:patches] #136 Vacation.pl relies upon deprecated Mail::Sender

[GingerDog <gin...@us...>]

Shame you didn't submit a patch.

Changing the #!/usr/bin/perl -w first line to be #!/usr/bin/perl -X is a nasty hack that at least makes it work.



---

** [patches:#136] Vacation.pl relies upon deprecated Mail::Sender**

**Status:** open
**Group:** SVN (please specify revision!)
**Created:** Fri Dec 02, 2016 03:06 PM UTC by Sylvain Tissot
**Last Updated:** Fri Dec 02, 2016 03:06 PM UTC
**Owner:** nobody


The `Mail::Sender` Perl module used to send the vacation email is [deprecated](http://matrix.cpantesters.org/?dist=Mail-Sender) and should be replacd by `Email::Sender::Simple`


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/patches/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/patches/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[postfixadmin:bugs] #314 redirect to login.php after loggin in

[Tim <ta...@us...>]

This was still happening for me even after the fix. Here is why in case anyone else is still having the problem. 
I eventually traced it down to the favicon.ico call being redirected to the login.php which would end the session right after logging in.
The cause? A .htaccess in the parent directory that enabled the rewriteengine for another site and postfixadmin was inheriting it. 

When the favicon.ico wasn't found, the redirect rule was sending the browser to login.php.

Once I disabled the apache rewriteengine in the postfixadmin directory the problem went away.


---

** [bugs:#314] redirect to login.php after loggin in**

**Status:** closed-fixed
**Group:** v2.91 (3.0 beta1)
**Labels:** bug 
**Created:** Mon May 12, 2014 12:23 PM UTC by Felix
**Last Updated:** Sun May 22, 2016 04:59 PM UTC
**Owner:** nobody


I updated from version 2.3.6 to 2.9.1. My database is up to date.
I can login with my known credentials but after clicking on any link or reloading the site I see after loggin in I ALWAYS get redirected to login.php.


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[ postfixadmin-Bugs-3601866 ] MySQL schema of postfixadmin lacks of foreign keys

[SourceForge.net <no...@so...>]

Bugs item #3601866, was opened at 2013-01-23 04:30
Message generated for change (Comment added) made by gingerdog
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=3601866&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: v2.3.5
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Ondřej Kunc ()
Assigned to: Nobody/Anonymous (nobody)
Summary: MySQL schema of postfixadmin lacks of foreign keys

Initial Comment:
Hi all,

I have recently discovered when migrating some mailboxes to postfixadmin, that schema created by 2.3.5 installer doesn't have any foreign keys (except of on_vacation). This at least causes some caveeats when doing some manual modifications/imports into database. You can end up with mailboxes without domain and similar problems. I recommend adding foreign keys there.

I you want, I can create patch for this.
Please write me if you want it.

Ondrej Kunc

----------------------------------------------------------------------

>Comment By: GingerDog (gingerdog)
Date: 2013-01-23 04:38

Message:
I've not looked at the mysql schema lately, but it used to use MyISAM
tables, which don't support foreign keys (or never used to).

I don't think there would be a problem migrating the tables to InnoDB, as
there aren't any fulltext indexes (afaik).

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=3601866&group_id=191583

[ postfixadmin-Bugs-3601866 ] MySQL schema of postfixadmin lacks of foreign keys

[SourceForge.net <no...@so...>]

Bugs item #3601866, was opened at 2013-01-23 04:30
Message generated for change (Tracker Item Submitted) made by 
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=3601866&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: v2.3.5
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Ondřej Kunc ()
Assigned to: Nobody/Anonymous (nobody)
Summary: MySQL schema of postfixadmin lacks of foreign keys

Initial Comment:
Hi all,

I have recently discovered when migrating some mailboxes to postfixadmin, that schema created by 2.3.5 installer doesn't have any foreign keys (except of on_vacation). This at least causes some caveeats when doing some manual modifications/imports into database. You can end up with mailboxes without domain and similar problems. I recommend adding foreign keys there.

I you want, I can create patch for this.
Please write me if you want it.

Ondrej Kunc

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=3601866&group_id=191583

[ postfixadmin-Feature Requests-3601801 ] Logo link to main.php

[SourceForge.net <no...@so...>]

Feature Requests item #3601801, was opened at 2013-01-22 11:32
Message generated for change (Tracker Item Submitted) made by z0l0ft
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937967&aid=3601801&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: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Z0l0ft (z0l0ft)
Assigned to: Nobody/Anonymous (nobody)
Summary: Logo link to main.php

Initial Comment:
By convention; add link to postfixadmin-root/main.php on logo

<img id="login_header_logo" src="images/logo-default.png" />

Perhaps rather pedantic; but as it is the convention on most interfaces I thought to mention it :)

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937967&aid=3601801&group_id=191583