summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2018-07-06Teach varnish purging code about xkey purgesMagnus Hagander
It's just another type of purge, so it's added as an extra option with 'K' as the key (as 'X' was already taken).
2018-07-06Fix function signatures of varnish sql funcs in dev envMagnus Hagander
This should be the same as are used in the prodiction. We don't use them in a way that has any effect on this today, but in case we do in the future.
2017-12-10Add ability for cauth sites to download ssh public keysMagnus Hagander
This removes the last need to directly access the upstream database (from the git server), so remove that view as well.
2017-12-10Remove community authentication 1.0Magnus Hagander
Community authentication 1.0 relied on PostgreSQL connections between all servers, and hasn't been used for years. This includes removing the code that migrates users from the old community authentication system to the new one. This means that any user who has not logged in since 2011 will no longer be able to user their oan account, and have to create a new one.
2016-05-14Replace pgq with trivial local queue implementationMagnus Hagander
The queue used for varnish purges has so few entries that it's really not worth paying the management overhead for skytools/pgq. Instead we can use a very simple local deamon using LISTEN/NOTIFY to fire them off. Now include a proper nagios plugin in this package, so we can get rid of the not-very-nice munin plugin currently used in the deployment.
2012-10-03Add support for varnish purging based on expressionsMagnus Hagander
Previously we would only purge based on URLs, but some of the upcoming new work requires arbitrary expression purging. NOTE! Require the creation of the new SQL procecure in the database, either from varnish.sql or varnish_local.sql depending on if it's prod or dev.
2012-08-21Don't include old ssh keys when new ones existMagnus Hagander
This would cause a UNIQUE violation on the git server...
2012-05-23Fixes in developer install instructions and scriptsMagnus Hagander
Per Josh Kupershmidt
2012-05-16mediawiki seems to require a community_login_exists() - the existing only ↵Stefan Kaltenbrunner
considers the "new" user table, make it also look at the "old" one
2011-12-20Usernames must be checked case insensitivelyDave Page
2011-12-11Add a varnish_purge() function to be used in local installsMagnus Hagander
2011-11-27Add view used to dump ssh keys for git serviceMagnus Hagander
2011-11-27Migrate ssh keys and store them in a UserProfile tableMagnus Hagander
2011-11-20Make community_login() look users up in the old system as wellMagnus Hagander
Instead of requiring all users to log in to the main website once, this allows them to keep using their old password on any aux sites that uses the community login system. We might want to consider actually migrating the accounts to the new system at some point in the future, but for now, just allow logins against the old tables, and have migration only happen when the user logs into the main website.
2011-08-20Add required table iptocountry, for downloadsMagnus Hagander
2011-08-17Fix login functions to be compatible with pg 9.0Magnus Hagander
2011-06-14Implement basic varnish purgingMagnus Hagander
This allows all models inherited from PgModel to specify which URLs to purge by either setting a field or defining a function called purge_urls, at which point they will be purged whenever the save signal is fired. Also implements a form under /admin/purge/ that allows for manual purging. This should probably be extended in the future to show the status of the pgq slaves, but that will come later. Includes a SQL function that posts the expires to a pgq queue. For a local deployment, this can be replaced with a simple void function to turn off varnish purging.
2010-06-22Enforce lowercase usernames everywhere.Magnus Hagander
2010-01-13community login API implementation on top of django authenticationMagnus Hagander