77 Commits
Author SHA1 Message Date
Rodrigo Cortés Cano a1724aa59a Reconcile 3.3 MySQL upgrades on 4.x (#1088)
fix regression in MySQL schema upgrade from 3.3 where vacation.domain, vacation.email and quota2.username had the wrong collation. (Thanks @TrapoSAMA + @knofte)
2026-07-28 16:25:09 +01:00
Christian Boltz 4b20d2be2b Fix hardcoded table name mailbox_app_password
... which exploded when using custom table names.
2025-09-11 22:39:57 +02:00
David Goodwin b97d89c280 try and only moan about db drivers missing if the specific driver is in the config, try and improve rendering of warnings/errors etc 2025-05-26 19:40:08 +01:00
David Goodwin 72c0dd1184 token code refactor 2025-05-26 15:53:33 +01:00
David Goodwin 4c01abf440 try and ensure core db tables are InnoDB format for MySQL users upgrading. 2025-05-26 15:51:48 +01:00
David Goodwin 5f46bdedaf respect db prefix stuff for the TOTP database tables. 2025-05-26 15:49:29 +01:00
James Lucas III dce68cdf50 Update upgrade.php (#906)
fix upgrade.php - admin.totp_secret field was not being added in the right place which caused an error. 

see also #899, thanks @jimlucas
2025-02-23 20:21:27 +00:00
David Goodwin 8461afb4ff add {BOOLEAN_TRUE} for pgsql, see #891 2025-01-18 09:01:35 +00:00
David Goodwin 9ac03371ce formatting 2025-01-17 11:20:22 +00:00
David Goodwin f61266cd7d see https://github.com/postfixadmin/postfixadmin/issues/891 - fix addition of mailbox.smtp_active to work on postgresql, add {BOOLEAN_TRUE} placeholder for mysql (not sure how this did not exist) 2025-01-17 10:43:20 +00:00
David Goodwin f01274ec94 try relaxing composer dependencies to allow php8.2 dev support, reformat so composer format passes 2024-04-22 21:02:01 +01:00
David Goodwin 45557a6ed4 code formatting fix 2024-01-11 08:57:27 +00:00
David Goodwin c700f3c9c7 update mailbox - add smtp_active for #796 2024-01-10 10:02:07 +00:00
David Goodwin 0829e032d4 try and fix db schema for app password stuff for Sqlite 2023-12-27 16:17:55 +00:00
David Goodwin 015d4ec9cd reindent / reformat; add type hints for some of the app password stuff; try and make sure someone can only remove their own app password (see revokeAppPassword() ) 2023-12-23 21:43:31 +00:00
David Goodwin 4d17aa6ef9 manaul merge in of verdigado:master (see #753) (MFA/TOTP support) 2023-12-23 17:05:52 +00:00
David Goodwin fcf14f0165 rename some tables so someone migrating from 3.3.x to 3.4 (?) should not have problems 2022-12-08 20:46:47 +00:00
David Goodwin d3e101e9d8 Merge remote-tracking branch 'origin/master' into feature/dkim 2022-07-18 08:55:07 +01:00
David Goodwin 38549c48ad composer format 2022-07-17 21:16:47 +01:00
David Goodwin 64bb52d0e3 fix pgsql schema generation for dkim 2022-07-17 21:07:57 +01:00
Adrien Crivelli a97771adfd Automatic code style fixes 2022-07-15 11:29:55 +02:00
David Goodwin 2d6ded2786 PSR2 -> PSR12 formatting 2022-06-28 13:46:11 +01:00
Fredrik Falk 9e73025058 Add Domain Key handling 2022-06-23 20:40:06 +02:00
David Goodwin 08ce130d58 try and improve mysql db collation fix - see #591 2022-02-14 21:36:33 +00:00
David Goodwin 66c71418a6 mysql does not support DROP CONSTRAINT, looks like it is MariaDB only - see https://github.com/postfixadmin/postfixadmin/issues/591#issuecomment-1021340592 2022-01-25 16:58:35 +00:00
David Goodwin 52ed517f35 also fix collation on domain_admins.domain to be latin1_general_ci - see also #327 (else a domain admin cannot login) 2021-12-07 19:42:49 +00:00
David Goodwin 047774b250 reorder upgrade sql, see #561 2021-11-21 21:32:24 +00:00
David Goodwin 7dcfb00377 composer format 2021-11-10 19:48:20 +00:00
David Goodwin 2ab28e795d fix more collation issues 2021-11-10 19:43:14 +00:00
David Goodwin 1018847cd5 fix formatting 2021-10-21 22:10:49 +01:00
David Goodwin ba825ef3c1 see #506 and #327 - this might unify enough of our textual latin1 columns to resolve collation issues 2021-10-21 22:08:25 +01:00
David Goodwin b271ae8cb8 composer format! 2021-05-13 13:17:07 +01:00
David Goodwin 8518d53906 merge postfixadmin_3.3 into master 2021-05-13 13:15:27 +01:00
David Goodwin 59f0b89233 explode on errors when performing db upgrade; try and fix #498 by updating domain created/modified columns to something MySQL might be happier with 2021-05-08 20:11:58 +01:00
David Goodwin b9ca22c918 change mailbox.name to be utf8mb4 too - see #484 2021-05-07 20:07:18 +01:00
David Goodwin 4e7b69e04c formatting 2021-05-07 19:54:17 +01:00
David Goodwin df34c100ea schema changes for https://github.com/postfixadmin/postfixadmin/pull/484 - changing vacation.subject and vacation.text to be utf8mb4 2021-05-07 19:52:45 +01:00
David Goodwin e8f3c40442 ignore this for sqlite which does not like a pk field being added 2021-04-13 21:26:11 +01:00
David Goodwin 2edabc3e03 phpcs insists on some brace changes 2021-04-13 21:19:16 +01:00
David Goodwin bbec16aac1 see: #475 - add domain_admins.id pk autoincrement field 2021-04-13 21:08:49 +01:00
David Goodwin e7e1ce9c28 fix postgresql test 2021-01-19 16:50:56 +00:00
David Goodwin 2b33e8f3c3 remove conditional; should be unnecessary 2020-11-09 21:50:17 +00:00
David Goodwin ca24ff8300 perhaps improve logging - see : https://github.com/postfixadmin/postfixadmin/issues/364 2020-06-15 17:12:42 +01:00
David Goodwin 3cd62f9f4f update to phpunit v8, try changing coveralls library, update github action 2020-04-14 21:03:10 +01:00
David Goodwin ec2fbfd87f skip this query - for a new database it will run before the domain table has been created and just error 2020-02-12 21:19:49 +00:00
David Goodwin fd35dada38 try and be consistent with MySQL table types/collations - see https://github.com/postfixadmin/postfixadmin/issues/327 2020-02-12 21:15:04 +00:00
David Goodwin 80a0faa633 specify a default table collation / charset for MySQL - might help fix https://github.com/postfixadmin/postfixadmin/issues/327 2020-02-11 20:02:34 +00:00
David Goodwin 87824ef970 psalm fixes/workarounds; require PHP 5.6+ 2019-10-19 20:51:05 +01:00
David Goodwin 06513c2a14 remove quotes around table name which is not necessary as table_by_key does this 2019-02-16 19:46:31 +00:00
David Goodwin fe48b35cfd split multiple queries into single ones to keep pdo/prepared statements happy 2019-02-15 21:59:11 +00:00