summaryrefslogtreecommitdiff
path: root/inc/auth/mysql.class.php
Commit message (Collapse)AuthorAge
* default to UTF-8 client encoding for MySQL backend FS#1527Andreas Gohr2008-11-08
| | | | darcs-hash:20081108225954-7ad00-70ee787910f6410625c3aa1dde39ca58f97903ee.gz
* fix use of unitialised %{user} placeholder in MySQL and PostgreSQL backendsAndreas Gohr2008-10-12
| | | | darcs-hash:20081012180207-7ad00-54ff244124e7ab824c635a550b02310f8163706a.gz
* mysql auth backend: check DB query result correctly FS#1039Andreas Gohr2008-02-23
| | | | darcs-hash:20080223130827-7ad00-3c9ba32b002a34548df1696a26bd92616e763ccc.gz
* spelling fix FS#1220Andreas Gohr2007-08-09
| | | | darcs-hash:20070809212154-7ad00-bde57d95f9b61840f1cdac4d60f89bcd0ae83c4a.gz
* support for setting the MySQL charset for auth backendThomas Koenig2007-04-23
| | | | darcs-hash:20070423155220-3f9f2-62892a6a0d4f170e24a86d385f2c4a1e1f7d25fa.gz
* tf_rename_lower.patchhenning.noren2007-01-03
| | | | | | | Name the TRUE/FALSE-constants consistently as lowercase everywhere. This might also be an tiny optimization in some environments. darcs-hash:20070103205700-d2a3e-e7ec0aedb938d563f583116a2d5b17f3a3fea36c.gz
* fix for php5's more stringent type checking in foreach (auth/mysql.class.php)chris2006-08-04
| | | | | | as described at http://wiki.splitbrain.org/wiki:auth:mysql#using_mysql_5 darcs-hash:20060803231253-9b6ab-bbf06ef1e9141c5ec1d3c79dad7f88481296ad8b.gz
* MySQL 3.23 compatibility issuematthiasgrimm2006-06-11
| | | | | | | MySQL 3.23 doesn't support the keyword OFFSET in the LIMIT statement. This patch changes the code to the second alternative syntax. darcs-hash:20060611164347-7ef76-b38861cebe45604c253bd4436451825733fe7083.gz
* MySQL Bug - PHP warning if query result is emptymatthiasgrimm2006-05-22
| | | | | | | | If a database query has no result, the returned array is not valid. This caused a PHP warning in the user manager if the filter is set in a way that the result list is empty. darcs-hash:20060522162327-7ef76-d8fa89a047a9a159b600f11ccb189e845b2a5b8f.gz
* Postgres backend for new OO authAndreas Gohr2006-03-01
| | | | darcs-hash:20060301223021-7ad00-868d32088de468523c63c4cc7e44869331dfc4b9.gz
* file cleanupsAndreas Gohr2006-02-17
| | | | | | | | | | This patch cleans up the source code to satisfy the coding guidelines (see http://wiki.splitbrain.org/wiki:development#coding_style) It converts files to UNIX lineendings and removes tabs and trailing whitespace. Not all files were cleaned yet. darcs-hash:20060217222040-7ad00-bba3d2bee3b5aa7cbb5184258abd50805cd071bf.gz
* fixed password mailAndreas Gohr2006-02-17
| | | | | | | There was an error which caused the mail aent on registration to contain the crypted password instead of the cleartext one. darcs-hash:20060217180715-7ad00-88b2e8f74ddbad41300ca53bbf79df3d8d8beebc.gz
* MySQL cando updatematthiasgrimm2006-02-08
| | | | | | This patch fixed the cando capabilities array. darcs-hash:20060208185913-7ef76-b6e999ebd2ecfbf3d3b50305cee88d6eb85a3b65.gz
* new way of auth module capability checkingAndreas Gohr2006-02-03
| | | | | | | | | | This changes the way of how the capabilities of the used auth module are checked as suggested as first option in http://www.freelists.org/archives/dokuwiki/01-2006/msg00267.html The MySQL backend WAS NOT TESTED and probably needs some work. darcs-hash:20060203150302-7ad00-c524cafe20499f32e76ad42b4e68d7c635f6a9e9.gz
* optional READ Lockmatthiasgrimm2006-02-01
| | | | | | | | | | | The option TablesToLock is no longer required for read operations. The small risk to feed invalid data into dokuwiki was accepted by the project leader. Nevertheless locks will be used for read operations too, if the option 'TablesToLock' is given. darcs-hash:20060201181422-7ef76-e89c5d9c305ca8c076281a58b6208e60dfce4c9f.gz
* MySQL canDo() patchmatthiasgrimm2006-01-30
| | | | | | | | | | | | | | | This patch adds a canDo() function to the MySQL backend to give higher program levels the opportunity to find out what functions the MySQL backend provides. Furthermore the option encryptPass was renamed to forwardClearPass because the old name was misleading and not clear. Last but not least the mysql.conf.php was reorganized to make clear which SQL statements enable which functions. darcs-hash:20060130192750-7ef76-2ba9388ea56b17e4f26feda74a66b7d9b8da7333.gz
* MySQL getUserCount() optimizsationmatthiasgrimm2006-01-26
| | | | | | | | The function getUserCount() uses SQL_CALC_FOUND_ROWS now if MySQL v4.0 or later is found. This will speed up this query with big user tables. darcs-hash:20060126205715-7ef76-e3a7009ad6be3659002b562bc055e4fe1cbd904a.gz
* MySQL retrieveUsers() use LIMITmatthiasgrimm2006-01-26
| | | | | | | | The function retrieveUsers() uses the SQL statement LIMIT now to select a subset of tupel out of a result table instead of fetching the whole table and filter in PHP. darcs-hash:20060126195109-7ef76-79af82f95282d43b585a67b495bfa86c2f5e3a15.gz
* MySQL modify user patchmatthiasgrimm2006-01-24
| | | | | | | | | | | | | | | | This patch changed the function modifyUser(). Before this update each data change was applied by deleting and re-adding the complete user entry. The new function uses the UPDATE SQL statement. Furthermore all human readable error messages were removed. The calling procedure is in charge now to inform the user about failures. Internal debug messages were added. They can be enabled in the configuration file. Last but not least the module retrieves the database version now to handle incompatible features between different MySQL versions. darcs-hash:20060124190625-7ef76-f6dffabf230155aa51bf3c8569c31fd444634407.gz
* MySQL backend code cleanup fixmatthiasgrimm2006-01-22
| | | | | | This patch make the MySQL backend work again after Andi's code cleanup ;-) darcs-hash:20060122125327-7ef76-5b7a46fa8bc49fc68a11a44fabddc9753e9a1dfb.gz
* streamlining auth backends :!:Andreas Gohr2006-01-21
| | | | | | | | | | | | | | | | | | | | | | | | | | | This patch is a start to make all the auth backend mor alike in configuration and to update all backend to the new OO method. This patch changed some config placeholders and thus may break existing configs! Here is a list of the new place holders used in MySQL and LDAP: %{user} - the login name %{group} - a group name %{pass} - the password (cleartext or crypted) %{dgroup} - the default group %{guid} - a group id %{uid} - a user id %{name} - full name of a user %{email} - email of a user %{dn} - DN for a user (LDAP only) The LDAP backend was enhanced a little bit. The default group now is always added to the list of returned groups. A different Server Port can be configured. More changes will follow. darcs-hash:20060121181149-7ad00-79de68aa7f87aef87dcff9dd7afd50adda859289.gz
* spellfix for mysql auth backendAndreas Gohr2006-01-21
| | | | darcs-hash:20060121152740-7ad00-80eecea2be4754494fef5f11cc91d7f3e4acf1fb.gz
* mysql class password encryption bugfixmatthiasgrimm2006-01-07
| | | | | | | | A syntax error in the checkpass() function prevented the module from using password encryption by the database. It always did the password encryption by itself - fixed. darcs-hash:20060107114635-7ef76-0eeee13b57844097e83f14d85372502e6b1ce10e.gz
* change username fixmatthiasgrimm2005-11-11
| | | | | | | This patch adds support for changing the username in modifyUser() which is needed by the user manager. darcs-hash:20051111185816-7ef76-062a7d949beaa90981d4fef8dfa70edc9d4723e6.gz
* MySQL OO auth module bug fixMatthias Grimm2005-11-10
| | | | | | | This patch fixes some bugs in the MySQL OO auth module regarding modifying user data. darcs-hash:20051110173812-4145d-384877de723b568ccc456f42738a8a5e012fb84d.gz
* MySQL auth module documentationMatthias Grimm2005-11-07
| | | | | | | | | This patch completes the documentation of the MySQL SQL statements that are necessary to run the mysql OO auth module in mysql.conf.php.example. Some pattern names in the code were not in line - fixed. darcs-hash:20051107210740-4145d-cdf140b6d14664ce9c1a85f67e1bf8feb294c17b.gz
* mysql extension for OO auth systemMatthias Grimm2005-11-06
This patch adds the mysql extension to the OO auth system. The SQL statements are defined in conf/mysql.conf.php.example and needs to be adapted to the local database. The set of statements work with the database structure described in conf/mysql.conf.php.example. This module is beta and heavy testing in different environments is recommended. The documentation of the SQL statements is not complete yet darcs-hash:20051106130303-4145d-28acb18584822f8d1eafa1d63e206f2e83f64009.gz