Commit Graph
75 Commits
Author SHA1 Message Date
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
Christian Boltz acf20bbc9e move comments to the beginning of upgrade.php 2019-01-28 00:47:24 +01:00
David Goodwin 66747337f9 fix formatting 2019-01-16 10:31:16 +00:00