aboutsummaryrefslogtreecommitdiff
path: root/src/odbc (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-01-12Update year of ProcessOne copyright from 2009 to 2010 (EJAB-1159)Badlop7-7/+7
SVN Revision: 2891
2009-12-29Add +export_all to EFLAGS if: make debug=true (thanks to Marcin ↵Badlop1-1/+1
Owsiany)(EJAB-1134) SVN Revision: 2842
2009-11-04Fix ProcessOne name in comments.Badlop1-1/+1
SVN Revision: 2724
2009-09-10Add a "created_at" column to some tables in the MySQL schema to storeJérôme Sautret1-6/+12
a timestamp (thanks to Pedro Melo, EJAB-376). SVN Revision: 2593
2009-09-10Fix pubsub tables constraints in MySQL schema creation script.Jérôme Sautret1-6/+6
SVN Revision: 2592
2009-08-27remove INFO_MSG call inside sql_query_internalChristophe Romain1-1/+1
SVN Revision: 2556
2009-08-07typo fix on subscriptionsChristophe Romain2-2/+2
SVN Revision: 2438
2009-08-07initial merge of pubsub odbc, compilation pass okChristophe Romain2-0/+106
SVN Revision: 2437
2009-08-06Support for roster versioning (EJAB-964)Pablo Polvorin4-1/+44
Introduces two options for mod_roster and mod_roster_odbc: - {versioning, true | false} Enable or disable roster versioning on ejabberd. - {store_current_id, true | false} If true, the current roster version is stored on DB (internal or odbc). Otherwise it is calculated on the fly each time. Performance: Setting store_current_id to true should help in reducing the load for both ejabberd and the DB. Details: If store_current_id is false, the roster version is a hash of the entire roster. If store_current_id is true, the roster version is a hash, but of the current time (this has to do with transactional semantics; we need to perform both the roster update and the version update on the same transaction, but we don't have the entire roster when we are changing a single item on DB. Loading it there requires significant changes to be introduced, so I opted for this simpler approach). In either case, there is no difference for the clients, the roster version ID is opaque. IMPORTANT: mod_shared_roster is not compatible with the option 'store_current_id'. Shared roster and roster versioning can be both enabled, but store_current_id MUST be set to false. SVN Revision: 2428
2009-08-06* src/odbc/ejabberd_odbc_sup.erl: make requests return a timeout ifJérôme Sautret2-18/+43
connections to the database cannot be established (EJABS-990). * src/odbc/ejabberd_odbc.erl: cosmetic changes. SVN Revision: 2427
2009-08-06* src/odbc/ejabberd_odbc.erl: fix keepalive query, broken by r2092.Jérôme Sautret1-1/+2
SVN Revision: 2425
2009-07-28EJAB-940: Implements reliable ODBC transaction nesting.Geoff Cant1-111/+139
SVN Revision: 2397
2009-06-09Add forgotten copyright and license notices. Fix blackspaces.Badlop1-1/+1
SVN Revision: 2151
2009-05-21* trunk/src/odbc/ejabberd_odbc.erl: Fix typo (EJABS-859) (EJAB-940) (CR-EJAB-10)Mickaël Rémond1-1/+1
* branches/road-to-exmpp/src/odbc/ejabberd_odbc.erl: Likewise. SVN Revision: 2095
2009-05-21* trunk/src/odbc/ejabberd_odbc.erl: Move trace to debug loglevel (EJAB-940) ↵Mickaël Rémond1-1/+1
(EJABS-859) (CR-EJAB-10) SVN Revision: 2093
2009-05-21* trunk/src/odbc/ejabberd_odbc.erl: Support for nested transaction ↵Mickaël Rémond1-68/+106
(EJABS-859) (EJAB-940) (CR-EJAB-10) SVN Revision: 2092
2009-05-06Replace TYPE/1 with is_TYPE/1 (EJAB-922)Badlop1-1/+1
SVN Revision: 2057
2009-04-24fix minor pubsub init glitch, and allow ejabberd_odbc to execute bloc of ↵Christophe Romain1-0/+28
queries without transaction SVN Revision: 2038
2009-01-23* src/odbc/mysql.sql: Fix complain about comment syntaxBadlop2-3/+3
* src/odbc/pg.sql: Likewise SVN Revision: 1850
2009-01-12* src/odbc/ejabberd_odbc.erl: Fixed processing of UPDATE resultsAlexey Shchepin1-0/+2
with pgsql SVN Revision: 1808
2009-01-12* doc/guide.tex: Update copyright date 2008 to 2009 (EJAB-842)Badlop7-7/+7
* doc/guide.html: Likewise * src/*/*.erl: Likewise * src/*/*.erl: Remove unneeded blankspaces in license text SVN Revision: 1804
2008-12-29* src/odbc/odbc_queries.erl: replaced string:join/2 function.Evgeniy Khramtsov1-11/+16
Removed ugly "catch" statement from update_t/4. WARNING: this change requires last version of mysql driver. You can update it from ejabberd-modules repository. SVN Revision: 1762
2008-12-29* src/odbc/ejabberd_odbc.erl: Print meaningful error message whenEvgeniy Khramtsov1-12/+22
an SQL transaction exceeds number of restarts. Also rollbacks this transaction to prevent deadlocks. SVN Revision: 1761
2008-12-26* src/odbc/ejabberd_odbc.erl: get rid of SERIALIZABLE isolation level on ↵Evgeniy Khramtsov2-68/+181
MySQL connections. * src/odbc/odbc_queries.erl: replaces all delete->insert chains with update->insert. * src/mod_privacy_odbc.erl: moved sql queries to odbc_queries.erl. * src/mod_roster_odbc.erl: changed interface for odbc_queries.erl. SVN Revision: 1755
2008-12-23* src/odbc/odbc_queries.erl: Fix removal of private_storage of anBadlop1-1/+1
account when the account is removed * src/mod_privacy.erl: Remove privacy lists of an account when the account is removed (EJAB-720) * src/mod_privacy_odbc.erl: Likewise SVN Revision: 1742
2008-12-03* src/odbc/ejabberd_odbc.erl: close MySQL connections on terminate (needs ↵Jérôme Sautret1-1/+9
mysql r829) SVN Revision: 1700
2008-10-13* src/odbc/ejabberd_odbc.erl: log MySQL driver messages.Jérôme Sautret1-2/+12
SVN Revision: 1652
2008-10-06* src/ejabberd_rdbms.erl: fix SQL database reconnectionJérôme Sautret2-34/+47
issues (EJAB-764) and add odbc_start_interval configuration directive (default to 30 seconds). * src/odbc/ejabberd_odbc.erl: likewise. * src/odbc/ejabberd_odbc_sup.erl: likewise. * doc/guide.tex: likewise. SVN Revision: 1600
2008-10-03* src/odbc/odbc_queries.erl: Fix empty query that fail on MySQL.Jérôme Sautret1-2/+2
SVN Revision: 1597
2008-10-03* src/mod_vcard_odbc: added vCard support for MS SQL Server 2005.Jérôme Sautret2-98/+341
* src/odbc/odbc_queries.erl: likewise. * src/odbc/mssql2005.sql: likewise. SVN Revision: 1595
2008-09-30* src/*/Makefile.win32: Provide explicit beam filenames becauseBadlop1-2/+1
nmake does not accept wildcards (thanks to Attila Vangel)(EJAB-543) SVN Revision: 1588
2008-09-02* src/odbc/mssql2000.sql: Script for MSSQL 2000Mickaël Rémond2-0/+1053
* src/odbc/mssql2005.sql: Script for MSSQL 2005 * src/odbc/mssql.sql: removed SVN Revision: 1558
2008-08-04* src/odbc/ejabberd_odbc.erl: Restart the database connection when it's lost ↵Jérôme Sautret1-8/+27
or it reaches timeout. Set transaction isolation level to SERIALIZABLE when establishing connection. SVN Revision: 1510
2008-07-31* doc/guide.tex: Update Process-one name to ProcessOne (EJAB-708)Badlop6-6/+6
* doc/guide.html: Likewise * doc/api/overview.edoc: Likewise * src/*/*.erl: Likewise * src/*/*.hrl: Likewise * src/*/*.c: Likewise * src/odbc/*.sql: Likewise SVN Revision: 1499
2008-07-22* src/odbc/odbc_queries.erl: Fixed a typoAlexey Shchepin1-1/+1
SVN Revision: 1467
2008-07-16* src/*.hrl: Get back all ejabberd header files to their originalBadlop1-1/+1
placement in src/ subdirectories (EJAB-696) * src/*/*.erl: Likewise * src/*/Makefile.in: Likewise * src/Makefile.in: Install header files in system include/ dir, reproducing the subdirectory structure of src/ SVN Revision: 1453
2008-07-13* src/configure.ac: Update installation permissions (EJAB-402)Badlop1-1/+3
* src/configure: Likewise * src/Makefile.in: The mnesia, ebin and priv dirs are now installed in different locations. Install header files and documentation (EJAB-696) * doc/guide.tex: Likewise * doc/guide.html: Likewise * include/*.hrl: Place for all ejabberd header files (EJAB-696) * src/*/*.erl: Update references to header files * src/*/Makefile.in: Include the include/ dir SVN Revision: 1441
2008-05-31* src/odbc/odbc_queries.erl (del_user_return_password): ReturnBadlop1-4/+5
password (thanks to Oleg Palij) SVN Revision: 1343
2008-03-13* src/odbc/ejabberd_odbc.erl: Start ODBC explicitely becauseBadlop1-0/+1
Erlang R12 doesn't start automatically like in R11 and older (thanks to Sergei Golovan)(EJAB-541) SVN Revision: 1231
2008-02-19add pgsql driver monitoringChristophe Romain1-0/+1
SVN Revision: 1200
2008-02-12* odbc_queries: fix list_users queries with limit/offset.Jérôme Sautret1-2/+2
SVN Revision: 1188
2008-02-12* odbc_queries: fix list_users query with prefix.Jérôme Sautret1-11/+11
SVN Revision: 1187
2008-01-15* doc/guide.tex: Updated copyright dates to 2008Badlop6-6/+6
* src/*: Likewise SVN Revision: 1153
2007-12-24* Applied copyright patch 3.Mickaël Rémond6-12/+128
SVN Revision: 1113
2007-12-20User count performance improvementsChristophe Romain1-7/+16
SVN Revision: 1086
2007-12-17* src/ejabberd_zlib/Makefile.win32: CompileBadlop1-7/+5
all erl files found in the directory, so it isn't needed to provide an explicit list of target files * src/eldap/Makefile.win32: Likewise * src/mod_irc/Makefile.win32: Likewise * src/mod_muc/Makefile.win32: Likewise * src/mod_proxy65/Makefile.win32: Likewise * src/mod_pubsub/Makefile.win32: Likewise * src/odbc/Makefile.win32: Likewise * src/stringprep/Makefile.win32: Likewise * src/tls/Makefile.win32: Likewise * src/web/Makefile.win32: Likewise SVN Revision: 1076
2007-12-17* src/ejabberd_zlib/Makefile.in: Compile all erl files found inBadlop1-11/+7
the directory, so it isn't needed to provide an explicit list of target files * src/eldap/Makefile.in: Likewise * src/mod_irc/Makefile.in: Likewise * src/mod_muc/Makefile.in: Likewise * src/mod_proxy65/Makefile.in: Likewise * src/mod_pubsub/Makefile.in: Likewise * src/odbc/Makefile.in: Likewise * src/pam/Makefile.in: Likewise * src/stringprep/Makefile.in: Likewise * src/tls/Makefile.in: Likewise * src/web/Makefile.in: Likewise SVN Revision: 1075
2007-12-17mssql specific issue bugfixChristophe Romain1-4/+3
SVN Revision: 1074
2007-12-11first patch to mssql quety, still one patch to be doneChristophe Romain1-1/+9
SVN Revision: 1066
2007-12-06* src/acl.erl and other 64 files: Remove Erlang module attributeBadlop2-2/+0
'vsn' because it doesn't provide any worth feature, and it difficults hot code update (EJAB-440) SVN Revision: 1044