http://hg.code.sf.net:8000/p/roundup/code/atom-log/tip/doc/mysql.txt Mercurial Repository: p/roundup/code: doc/mysql.txt history 2024-12-18T16:24:22-05:00 doc: update version in doc/mysql.txt; remove bdb support for mysql. http://hg.code.sf.net:8000/p/roundup/code/#changeset-3d7292d222d12269f08cf233c6cff4e504411795 John Rouillard rouilj@ieee.org 2024-12-18T16:24:22-05:00 2024-12-18T16:24:22-05:00
changeset 3d7292d222d1
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description doc: update version in doc/mysql.txt; remove bdb support for mysql.

Remove obsolete info from doc and code.
files
feat: issue2550852 - support using a specified PostgreSQL db schema http://hg.code.sf.net:8000/p/roundup/code/#changeset-3071db43bfb6d957b2dab43ae0f9df0e98f86002 John Rouillard rouilj@ieee.org 2023-12-27T22:52:14-05:00 2023-12-27T22:52:14-05:00
changeset 3071db43bfb6
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description feat: issue2550852 - support using a specified PostgreSQL db schema

Finally after 7 years this is closed.

roundup/backends/back_postgresql.py:
Support use of schema when specified in RDBMS_NAME. Stuart McGraws
code is finally merged 8-).

test/test_postgresql.py, test/conftest.py:
Run all postgresql tests in the schema db as well.
Also make sure that db_nuke raises an error when trying to delete
the schema test database. Conftest defines pg_schema mark that can
be used to exclude schema tests with pytest -m "not pg_schema".

roundup/configuration.py:
change doc on RDBMS_NAME to include db.schema form.

.travis.yml, .github/workflows/ci-test.yml:
create schema test db; add user for testing with schema; grant new
user create privs for schema.

doc/installation.txt:
Reference to roundup-admin init deleting schema added.

doc/mysql.txt doc/postgresql.txt:
New documentation on psql/mysql commands to set up a production db.

doc/upgrading.txt:
mention schema support, also document service setting for
selecting connection from pg_service.conf.

doc/reference.txt:
update config.ini documentation for RDBMS_NAME.
files
Add warning rounduptest user: pg;mysql; add db account creation pg http://hg.code.sf.net:8000/p/roundup/code/#changeset-b21ebabeb2ef4484c00285974f85e9589482a7b8 John Rouillard rouilj@ieee.org 2023-05-25T15:11:04-04:00 2023-05-25T15:11:04-04:00
changeset b21ebabeb2ef
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description Add warning rounduptest user: pg;mysql; add db account creation pg
files
typo fix. http://hg.code.sf.net:8000/p/roundup/code/#changeset-fc9e16fe399132a98683921acfa109756bc44752 John Rouillard rouilj@ieee.org 2023-05-10T23:02:12-04:00 2023-05-10T23:02:12-04:00
changeset fc9e16fe3991
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description typo fix.
files
more index entries. http://hg.code.sf.net:8000/p/roundup/code/#changeset-81ae33038ec58bd7a2c6f846ee04941a8aa642af John Rouillard rouilj@ieee.org 2020-05-13T13:01:08-04:00 2020-05-13T13:01:08-04:00
changeset 81ae33038ec5
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description more index entries.
files
Doc updates/indexing. http://hg.code.sf.net:8000/p/roundup/code/#changeset-c2fd254c9257f513a0de7446e549487ed4d51fe3 John Rouillard rouilj@ieee.org 2020-05-13T00:40:14-04:00 2020-05-13T00:40:14-04:00
changeset c2fd254c9257
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description Doc updates/indexing.

doc/admin_guide.txt, doc/customizing.txt, doc/features.txt,
doc/installation.txt, doc/mysql.txt, doc/postgresql.txt: adding
index entries

doc/customizing.txt: reference schema changes later in document in
addition to wiki.

website/www/contents.txt: make wiki url https:.... Remove
indices/tables as they don't show up in web interface. Put
docs/announcement.txt into hidden toctree to silence warning from
sphinx. Announcement.txt is referenced from index.txt so can't
silence by adding to conf.py exclude_patern.

website/www/index.txt: mention security and other improvements in jinja2
templates.

website/www/conf.py: get rid of all warning by using exclude_patterns
to ignore docs that aren't included. Remove exclude_trees using
exclude_pattern instead. Make html_add_permalinks value acceptable
so no warning reported.

website/www/_static/style.css, website/www/_templtes/layout.html:
add prev/next/index links for all doc pages.
files
[maint-1.6] issue2550966: fix suboptimal links in docs. http://hg.code.sf.net:8000/p/roundup/code/#changeset-392f887652f0b32b915fe6023a007a99f3fd38e2 John Rouillard rouilj@ieee.org 2019-06-01T21:39:17-04:00 2019-06-01T21:39:17-04:00
changeset 392f887652f0
branch maint-1.6
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description issue2550966: fix suboptimal links in docs.

I think I got the majority of them. Some links still don't resolve
because they are gone and there is no replacement afaict.

Also the check is picking up example links like: https://.../rest and
http://localhost:8017/... which should not be checked but are.
files
issue2550966: fix suboptimal links in docs. http://hg.code.sf.net:8000/p/roundup/code/#changeset-e48b039b0ec030a3e9dd3b9568fe3ed844e1945f John Rouillard rouilj@ieee.org 2019-06-01T21:39:17-04:00 2019-06-01T21:39:17-04:00
changeset e48b039b0ec0
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description issue2550966: fix suboptimal links in docs.

I think I got the majority of them. Some links still don't resolve
because they are gone and there is no replacement afaict.

Also the check is picking up example links like: https://.../rest and
http://localhost:8017/... which should not be checked but are.
files
[maint-1.6] Changed references to http://issues.roundup-tracker.org to https now http://hg.code.sf.net:8000/p/roundup/code/#changeset-64ceb9c14b287aeb84ab44987a040f6729d55176 John Rouillard rouilj@ieee.org 2019-02-12T21:31:41-05:00 2019-02-12T21:31:41-05:00
changeset 64ceb9c14b28
branch maint-1.6
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description Changed references to http://issues.roundup-tracker.org to https now
that the site is TLS enabled.
files
Changed references to http://issues.roundup-tracker.org to https now http://hg.code.sf.net:8000/p/roundup/code/#changeset-0df5f9eeefd452bc5be7ba03a7554ca95deb063d John Rouillard rouilj@ieee.org 2019-02-12T21:31:41-05:00 2019-02-12T21:31:41-05:00
changeset 0df5f9eeefd4
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description Changed references to http://issues.roundup-tracker.org to https now
that the site is TLS enabled.
files
update link to new mysqlclient module and recommend update in upgrading.txt http://hg.code.sf.net:8000/p/roundup/code/#changeset-e2978ed3b550e2534f7cf7bdbf8c179ec857718f Christof Meerwald cmeerw@cmeerw.org 2018-08-17T22:12:48+01:00 2018-08-17T22:12:48+01:00
changeset e2978ed3b550
branch
bookmark
tag
user Christof Meerwald <cmeerw@cmeerw.org>
description update link to new mysqlclient module and recommend update in upgrading.txt
files
issue2550743 - Reindex with MySQL Server failed. It looks like http://hg.code.sf.net:8000/p/roundup/code/#changeset-98fdc1f98194025f0833f62401a7feb5e8f3b85c John Rouillard rouilj@ieee.org 2016-07-09T14:27:24-04:00 2016-07-09T14:27:24-04:00
changeset 98fdc1f98194
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description issue2550743 - Reindex with MySQL Server failed. It looks like
indexing large documents may require increasing mysql's
max_allowed_packet setting. Documented the issue in doc/mysql.txt.
files
Remove $-cookies that have been misleading since roundup moved off CVS. http://hg.code.sf.net:8000/p/roundup/code/#changeset-33a1f03b9de07ea81c27ae16c0071da69c723103 Eric S. Raymond esr@thyrsus.com 2011-10-31T17:48:11-04:00 2011-10-31T17:48:11-04:00
changeset 33a1f03b9de0
branch
bookmark
tag
user Eric S. Raymond <esr@thyrsus.com>
description Remove $-cookies that have been misleading since roundup moved off CVS.

One of these, a $Date$ cookie, might accidentally expanded correctly by
Subversion *if* keyword expansion was enabled on that file; but judging by
the ancientness of the date, it probably wasn't.

In any case, git doesn't do any keyword expansion at all, so there
isn't an equivalent to translate these into.
files
Docs update for mysql and postgresl: Mentioned test/db_test_base.py because http://hg.code.sf.net:8000/p/roundup/code/#changeset-6a32a2fb95b41cc28006b12aa27a606ba87aa60b Bernhard Reiter Bernhard.Reiter@intevation.de 2011-07-01T14:11:06+00:00 2011-07-01T14:11:06+00:00
changeset 6a32a2fb95b4
branch
bookmark
tag
user Bernhard Reiter <Bernhard.Reiter@intevation.de>
description Docs update for mysql and postgresl: Mentioned test/db_test_base.py because
that is the place where the default database parameters comes from.
files
mysql table creation syntax change http://hg.code.sf.net:8000/p/roundup/code/#changeset-a472391156aeb7cf0ba7c64a0895aaa97a45ca2d Justus Pendleton jpend@users.sourceforge.net 2007-09-28T15:26:10+00:00 2007-09-28T15:26:10+00:00
changeset a472391156ae
branch
bookmark
tag
user Justus Pendleton <jpend@users.sourceforge.net>
description mysql table creation syntax change

The MySQL people gratuitously changed the syntax for specifying the storage
engine a while back and the current alpha drops support for the old syntax.
This patch changes TYPE to ENGINE in the mysql backend and updates the
documentation to show that we require MySQL 4.0.18 because of that. I also
removed a note in the mysql docs about a bug in InnoDB that has been fixed as
of the required version.

This fixes [SF#1727529]
files
more doc updates, not so many TODOs any more http://hg.code.sf.net:8000/p/roundup/code/#changeset-ad4fb8a14a970f5359e9ee40b5a9b5751c0ded80 Richard Jones richard@users.sourceforge.net 2004-11-18T05:05:25+00:00 2004-11-18T05:05:25+00:00
changeset ad4fb8a14a97
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description more doc updates, not so many TODOs any more
files
remove obsolete configuration notes http://hg.code.sf.net:8000/p/roundup/code/#changeset-653c7ffce402c556826377bc076137c84dd75cab Alexander Smishlajev a1s@users.sourceforge.net 2004-11-03T09:23:50+00:00 2004-11-03T09:23:50+00:00
changeset 653c7ffce402
branch
bookmark
tag
user Alexander Smishlajev <a1s@users.sourceforge.net>
description remove obsolete configuration notes
files
[maint-0.7] merge from HEAD http://hg.code.sf.net:8000/p/roundup/code/#changeset-7b2ea468381af6931cee30f946a2d01a3edd61d0 Richard Jones richard@users.sourceforge.net 2004-07-20T04:47:45+00:00 2004-07-20T04:47:45+00:00
changeset 7b2ea468381a
branch maint-0.7
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description merge from HEAD
files
rdbms doc updates http://hg.code.sf.net:8000/p/roundup/code/#changeset-c0d6d5004464b78ce04f2874adcc78632836a9fa Richard Jones richard@users.sourceforge.net 2004-07-20T04:38:54+00:00 2004-07-20T04:38:54+00:00
changeset c0d6d5004464
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description rdbms doc updates
files
merge http://hg.code.sf.net:8000/p/roundup/code/#changeset-096063697f776efb9633318d1b591f6e2a0e20ae Richard Jones richard@users.sourceforge.net 2004-06-09T00:25:32+00:00 2004-06-09T00:25:32+00:00
changeset 096063697f77
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description merge
files
[maint-0.7] some more documentation work http://hg.code.sf.net:8000/p/roundup/code/#changeset-ef226254ef460b92c866a54393942dd6b9d4396d Richard Jones richard@users.sourceforge.net 2004-06-09T00:11:49+00:00 2004-06-09T00:11:49+00:00
changeset ef226254ef46
branch maint-0.7
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description some more documentation work
files
*** empty log message *** http://hg.code.sf.net:8000/p/roundup/code/#changeset-dbb78664e427cc1e6e0cdb52132e12445de58f6a Richard Jones richard@users.sourceforge.net 2004-03-02T22:24:07+00:00 2004-03-02T22:24:07+00:00
changeset dbb78664e427
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description *** empty log message ***
files
clarified minimum version required for MySQL backend (4.0.16) http://hg.code.sf.net:8000/p/roundup/code/#changeset-d929c31a3620b077f8b51eaf1886c6a6a80f563d Richard Jones richard@users.sourceforge.net 2003-11-12T22:34:28+00:00 2003-11-12T22:34:28+00:00
changeset d929c31a3620
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description clarified minimum version required for MySQL backend (4.0.16)
files
fixes for [SF#818339] http://hg.code.sf.net:8000/p/roundup/code/#changeset-2b0ab61db19497b229e366bc0df89030bdc96f13 Richard Jones richard@users.sourceforge.net 2003-11-12T03:42:13+00:00 2003-11-12T03:42:13+00:00
changeset 2b0ab61db194
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description fixes for [SF#818339]

fixes for metakit for the new db unit tests
files
[maint-0.6] Merge back doc changes from HEAD. http://hg.code.sf.net:8000/p/roundup/code/#changeset-5c6f3da9856f8457b70c47e71372d275dbb0f48f Johannes Gijsbers jlgijsbers@users.sourceforge.net 2003-11-06T12:33:55+00:00 2003-11-06T12:33:55+00:00
changeset 5c6f3da9856f
branch maint-0.6
bookmark
tag
user Johannes Gijsbers <jlgijsbers@users.sourceforge.net>
description Merge back doc changes from HEAD.
files
Fix a couple of failures in mysql backend unit tests. http://hg.code.sf.net:8000/p/roundup/code/#changeset-06f5b36b201bb7f7f4f815c8683c67e4c83499fc Richard Jones richard@users.sourceforge.net 2003-10-07T08:52:12+00:00 2003-10-07T08:52:12+00:00
changeset 06f5b36b201b
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description Fix a couple of failures in mysql backend unit tests.

Fix the mysql backend docs

Note requirement of MySQL version 4.0+ with InnoDB or BDB mysql backend
files
rewrite to fix english. http://hg.code.sf.net:8000/p/roundup/code/#changeset-5a28eea9a33c9c3ea07c864e0cad8b6e57052e24 Anthony Baxter anthonybaxter@users.sourceforge.net 2003-06-24T07:06:12+00:00 2003-06-24T07:06:12+00:00
changeset 5a28eea9a33c
branch
bookmark
tag
user Anthony Baxter <anthonybaxter@users.sourceforge.net>
description rewrite to fix english.
files
english nits http://hg.code.sf.net:8000/p/roundup/code/#changeset-1fb2e44d02e34d6e996ac762ee7b996fdb60a26e Anthony Baxter anthonybaxter@users.sourceforge.net 2003-06-24T06:53:17+00:00 2003-06-24T06:53:17+00:00
changeset 1fb2e44d02e3
branch
bookmark
tag
user Anthony Baxter <anthonybaxter@users.sourceforge.net>
description english nits
files
trackers on mysql can be initialised http://hg.code.sf.net:8000/p/roundup/code/#changeset-b953750bdc04ce8b17203f4943490f09cd95f10c Andrey Lebedev kedder@users.sourceforge.net 2003-02-15T23:19:01+00:00 2003-02-15T23:19:01+00:00
changeset b953750bdc04
branch
bookmark
tag
user Andrey Lebedev <kedder@users.sourceforge.net>
description trackers on mysql can be initialised
added mechanism for backends to detect and clear database
files
mysql tests will not be run if there is no chance of passing. http://hg.code.sf.net:8000/p/roundup/code/#changeset-8429095241d786e704d4f954d4821b51c140be93 Andrey Lebedev kedder@users.sourceforge.net 2003-02-15T14:26:38+00:00 2003-02-15T14:26:38+00:00
changeset 8429095241d7
branch
bookmark
tag
user Andrey Lebedev <kedder@users.sourceforge.net>
description mysql tests will not be run if there is no chance of passing.

Notes about mysql backend added
files