92d6259cd0
possibly fix PGSQL PDO DSN to be unicode aware; see #243
5 years ago
c71dd25afa
fix setup db_connect_with_errors PDO exceptions were not caught
5 years ago
583b8958c7
psalm
5 years ago
7838e85ff0
fix formatting
5 years ago
5db463b35c
improve docs
5 years ago
cef2ba5598
Merge remote-tracking branch 'origin/master' into feature-try-pdo
5 years ago
e347b4677b
Fix for MySQL 8
...
The keyword ROW became reserved in MySQL 8.0.2
https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-R
5 years ago
803e2342f8
fix psalm issues; reformat; rename new db functions
5 years ago
1176c9ce78
reformat; fix some transition bugs
5 years ago
ea33d9951a
try migrating to pdo
5 years ago
8798a65a06
remove db_array() function (not in use); use Config::read_string(..) more
6 years ago
cdacb5697f
improve formatting of error message; remove use of db_array (to be removed).
6 years ago
2ea829eb7a
fix postgresql compatability - see #227
6 years ago
b2e814967f
try and get working under travis ...
6 years ago
590c80f0bc
add more unit tests; re-enable random_int warning in functions.inc.php for old php versions etc etc
6 years ago
e8acb609c2
reformat
6 years ago
20b1eb842e
fix sqlite display of password expired check for mailboxes
6 years ago
1dfb03ea32
fix sqlite query for mailbox password_expiry
6 years ago
4fcdba9cf4
run php-cs-fixer (code reforamt)
6 years ago
19cda31849
remove psalm warnings from code; fix password_expiry behaviour when enabled/disabled on MySQL
6 years ago
74002bbf57
psalm fixes
6 years ago
7408a3b30a
fix safepost doc
6 years ago
69e234f668
Merge pull request #200 from doktoil-makresh/master
...
Support for password expiration, managed in PostFix Admin
6 years ago
87472af5ba
add Date header into smtp_from(...) function - see #203
6 years ago
b1795ab596
phpdoc
6 years ago
1e158245d6
try and fix #30 - cope with timestamp and numeric field number comparison better for PostgreSQL.
6 years ago
a8b02cfc05
Default to default values
6 years ago
77d1b6c2e7
rename sql fields to just have mailbox.password_expiry and domain.password_expiry
6 years ago
8115d8d047
Reverting unexpected changes
6 years ago
84533224ba
Adds colored indicators for password expired, account disabled and vacation enabled accounts
6 years ago
b33d79125c
Merge branch 'master' of github.com:doktoil-makresh/postfixadmin
6 years ago
d809e0fbf7
Adds colored indicators for password expired, account disabled and vacation enabled accounts
6 years ago
72dddbc93b
Adds colored indicators for password expired, account disabled and vacation enabled accounts
6 years ago
ce60b9fa59
Now password expiration is managed through Postfix Admin GUI
6 years ago
e786609aa9
Adding support for password expiration. Please read README.password_expiration for more details
6 years ago
563b8c7636
phpdoc fixes (psalm)
6 years ago
318ac048d5
psalm fixes
6 years ago
2df4348f09
Typo fix
6 years ago
48c19a1cbd
Combine encrypt CONF-keys
...
Went through the old PR #25 , updated the encrypt rounds/cost setting to be in the encrypt -configuration key as per suggestion from @cboltz
6 years ago
c1b5e66e27
Add missing global
...
... you should never edit with the GitHub web GUI, lazy me.
6 years ago
b676e8337f
Allow empty $CONF['encrypt_difficulty'] for defaults
6 years ago
9c2161a549
Added support for password generation cost/rounds
...
$CONF["php_crypt_difficulty"], only for php_crypt:BLOWFISH, php_crypt:SHA256 and php_crypt:SHA512
6 years ago
3754381f0e
Merge pull request #175 from racerxdl/master
...
'row' is a reserved word in MySQL 8.0
6 years ago
11f9680963
'row' is a reserved word in MySQL 8.0
6 years ago
2eb5a7ed60
simplify function_exists() checks for random_int()
...
It's easier to define a compat function than to have function_exists()
checks all over the code.
6 years ago
b4849b8431
bump minimum db version
6 years ago
4c6bcdbc39
update version
6 years ago
5b7f4cda48
add phpdoc comments, default php_crypt hash to use SHA512 rather than MD5
6 years ago
7282928e6d
update generate_password() to allow length to be specified; update test
6 years ago
a3feba7c73
change default for php_crypt to SHA512
...
(+ a few whitespace changes)
6 years ago
b48f99d4c6
reformat (phpcs)
6 years ago
e7f9d536d9
change default salt method with php_crypt
6 years ago
f543c7d403
use random_int() if available
6 years ago
7c0cb82be8
use random_int if it is available
6 years ago
11f0ceb615
added php_crypt scheme
6 years ago
9a07772626
remove commented out echo
6 years ago
30c61e81b3
better comment for pacol() parameter
6 years ago
50ac4c7597
Fixed "Incorrect integer value: 'Array' for column" error in updates.
6 years ago
d57aa46eb5
remove explode()
6 years ago
2a1d8daeba
remove unused variables
6 years ago
b79ad2ae28
composer format ...
6 years ago
6446f3f6cc
split up pacrypt() into different functions; add some minimal test coverage
6 years ago
6ed1527497
fix phpdoc
6 years ago
cb34da4f46
phpcs reformat
6 years ago
43a2493876
remove unused code.
6 years ago
4dec9cd24e
refactor (reduce nesting)
6 years ago
d088651fd6
Drop db_commit(), db_rollback(), db_begin() functions (unused).
6 years ago
0b66cd6bd2
Do not try to db_escape() an SQL field.
6 years ago
4e9d166765
use db_assoc() rather than db_array() as we're depending on an assoc array afterall.
6 years ago
45a1073b97
change to use foreach($a as $k => $v) { ... }
6 years ago
8ac94394cb
improve phpdoc
6 years ago
e2b1233269
Use filter_var($x, FILTER_VALIDATE_EMAIL) as an extra check if we can in check_email(...)
6 years ago
5e1855632a
allow local aliases - see #134
6 years ago
15df6c1d7b
Reformat everything with PHP-Cs-Fixer
6 years ago
a320b67508
possible fix for issue in #112 - PostgreSQL does not like backticks (only do them for MySQL)
7 years ago
977f335a0f
Fix quoting in table_by_key()
...
This fixes a regression introduced by
https://github.com/postfixadmin/postfixadmin/pull/112
which became only visible when using a $CONF['database_prefix']
7 years ago
7b8626ca81
Update functions.inc.php
...
I found that Mysql 8 don't like table names without `` in requests. So i make changes in function table_by_key in functions.inc.php and in upgrade.php . Now it works. FreeBSD 11.1 Apache/2.4.29 (FreeBSD) PHP/7.1.11 Mysql 8
7 years ago
ebbd9025e4
Add support for MySQL connections over SSL
7 years ago
ffb84283c2
Harden password reset process
...
The improvements are:
- Die with an explicit message when a user is trying to reset his lost password and the option is disabled in config
- Redirect user to main page after password change using relative URL
- Don't leak info whether user exists or has recovery info defined
- Throttle password reset requests to prevent brute force attacks
- Show phone/alt email fields in mailbox/admin edit form only when the password reset option is enabled
- Make database upgrade code compatible with other databases types
- Use the existing password generator to generate OTP. It is now stored in database, unique to each user, valid only for 1 hour and can only by used once.
7 years ago
4b999b3f6b
improve mysqli connection settings - see https://github.com/postfixadmin/postfixadmin/issues/73
7 years ago
9c9ba64a7f
Allows a user or admin to reset his/her forgotten password with a code sent by email/SMS #18
7 years ago
be5fafa9fb
changelog update etc. for 3.1 release
7 years ago
64f1593818
revert "support unicode domain names - see #47"
...
Unicode support is a much bigger can of worms (see the discussion in #47 ),
and having just a little part of unicode support in is a bad idea.
You can of course use the xn--whatever notation for unicode domains ;-)
7 years ago
a09a3fa3b0
support unicode domain names - see #47
7 years ago
88bd9bfd19
drop $db_conn parameter from escape_string()
...
Connection caching is now done in db_connect() which is a much better
place.
This reverts most of c253ef7dbd
7 years ago
846dcb756c
Remove unnecessary code
7 years ago
e28f3f5959
Fix for mysqli_connect()
7 years ago
2dea9fadd4
Remove whitespace
7 years ago
c253ef7dbd
allow escape_string() to take a db connection as a parameter; should improve performance when there are a large number of things to escape
7 years ago
28703935b3
3.0.2 release
...
git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@1894 a1433add-5e2c-0410-b055-b7f2511e0802
7 years ago
16e1407621
db_where_clause(): allow NULL and NOTNULL searchmodes
...
git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@1878 a1433add-5e2c-0410-b055-b7f2511e0802
8 years ago
bbec3e9f0e
pacrypt(): allow switching between dovecot:* password schemes
...
Dovecot password hashes include a {SCHEME} prefix, so it's possible to
switch the scheme while still accepting passwords hashed using the
previous dovecot:* scheme.
This patch adds the code needed to find out the used hashing scheme
from the hash and ensures it gets used to validate the password.
Patch by Aaron Lindsay <aaron AT aclindsay com> (sent to the ML)
git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@1875 a1433add-5e2c-0410-b055-b7f2511e0802
8 years ago
6eda18fcde
prepare PostfixAdmin 3.0 release
...
git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@1861 a1433add-5e2c-0410-b055-b7f2511e0802
8 years ago
2a6247a6d9
db_connect(): drop unused variable $succes(s)
...
One of the variable names had a typo [1], and since those variables are
unused, the best way is to drop them.
[1] reported by tfarina, https://github.com/postfixadmin/postfixadmin/issues/15
git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@1858 a1433add-5e2c-0410-b055-b7f2511e0802
8 years ago
13cdd50d0a
Add checks to login.php and cli to ensure database layout is up to date
...
- add check_db_version() to functions.inc.php
- add $min_db_version (needs to be updated at least before the release)
- call check_db_version in login.php, users/login.php and CLI - they'll
error out if the database layout is outdated
- change setup.php to use check_db_version()
git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@1853 a1433add-5e2c-0410-b055-b7f2511e0802
8 years ago
a00e8a811d
functions.inc.php:
...
- check_domain(): someone had the great idea to allow punicode
even in TLDs, so we better allow it.
https://sourceforge.net/p/postfixadmin/feature-requests/93/
git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@1839 a1433add-5e2c-0410-b055-b7f2511e0802
8 years ago
a0151bd5a1
functions.inc.php:
...
- pacrypt(): don't stripslashes($pw) because this breaks passwords with
backslashes. This stripslashes() existed since forever, but probably
became harmful with all the rewrites in the last years.
https://sourceforge.net/p/postfixadmin/bugs/349/
git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@1838 a1433add-5e2c-0410-b055-b7f2511e0802
8 years ago
9335232024
functions.inc.php:
...
- fix db_quota_text() for postgresql (concat() vs. ||)
https://sourceforge.net/p/postfixadmin/bugs/370/
git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@1834 a1433add-5e2c-0410-b055-b7f2511e0802
8 years ago
d3ca74af0d
merge github pull request into svn manually - 3e62d3975a - adding configurable smtp helo (CONF["smtp_client"])
...
git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@1832 a1433add-5e2c-0410-b055-b7f2511e0802
8 years ago
b261db86c7
Merge pull request #9 from phyrog/master
...
Add sqlite backend option (thank you @phyrog for doing this)
(imported from github)
git-svn-id: https://svn.code.sf.net/p/postfixadmin/code/trunk@1824 a1433add-5e2c-0410-b055-b7f2511e0802
8 years ago
David Goodwin