Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-08-15 Thread Matt Brown
tags 379796 pending thanks bts sean finney wrote: cool! could i nitpick and ask that they be called dbc_dbfile_foo, or something similar, just so that it's more clear what they are used for? Done since you and thijs are both reporting success with this now, go ahead and merge this into

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-08-14 Thread Matt Brown
Thijs Kinkhorst wrote: On Thu, 2006-08-10 at 10:53 -0400, sean finney wrote: there are some hinting variables which you can use to specify the defaults. i believe they're dbc_generate_include_owner and dbc_generate_include_mode, though don't trust my memory. there should also be something

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-08-14 Thread sean finney
hey matt, thijs, On Mon, Aug 14, 2006 at 06:47:14PM +1200, Matt Brown wrote: New packages at http://www.mattb.net.nz/debian/dists/sid/main/source/admin/ now have two variables dbc_owner and dbc_perms modeled off the dbc_generate_include_ versions to allow you to hint at the desired settings.

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-08-14 Thread Thijs Kinkhorst
On Mon, 2006-08-14 at 18:47 +1200, Matt Brown wrote: Thijs Kinkhorst wrote: On Thu, 2006-08-10 at 10:53 -0400, sean finney wrote: there are some hinting variables which you can use to specify the defaults. i believe they're dbc_generate_include_owner and dbc_generate_include_mode, though

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-08-10 Thread Thijs Kinkhorst
Hello Matt, Both errors were caused by a simple typo in the function that checked whether a database existed. I've also made a few other tidy ups and merged in the changes from trunk. I've built new packages (1.8.19~sqlite0) and put them at:

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-08-10 Thread Matt Brown
Thijs Kinkhorst wrote: Sure, thanks for the quick response. I've checked it out and it works good, except for the fact that the database is owned by root:root and filemode 0640. That makes it unreadable for my webapp. Would there be a way to specify the file owner to be www-data, or would I

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-08-10 Thread sean finney
hey guys, On Thu, Aug 10, 2006 at 10:06:02PM +1200, Matt Brown wrote: Thijs Kinkhorst wrote: Sure, thanks for the quick response. I've checked it out and it works good, except for the fact that the database is owned by root:root and filemode 0640. That makes it unreadable for my webapp.

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-08-10 Thread Thijs Kinkhorst
On Thu, 2006-08-10 at 10:53 -0400, sean finney wrote: there are some hinting variables which you can use to specify the defaults. i believe they're dbc_generate_include_owner and dbc_generate_include_mode, though don't trust my memory. there should also be something like

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-08-10 Thread Matt Brown
sean finney wrote: oh, sorry, brain fart. yes, i think there should be something similar for that, but i don't think it's there currently. so then there are two issues :) There was but it was implemented as the debconf question rather than hints from the maintainer file. I'll add it back in

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-08-10 Thread sean finney
On Thu, Aug 10, 2006 at 06:54:05PM +0200, Thijs Kinkhorst wrote: Yes, but this is about the database that is created by sqlite, not the include file. Maybe we should have the same set of variables for any backend that creates a database file on the local filesystem, that performs the same

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-08-09 Thread Matt Brown
Hi Thijs, Thijs Kinkhorst wrote: I've done so on a new package of mine. It took a while to get it working, because as it seems sqlite is very picky (or even buggy) on SQL syntax. I've now transformed my inserts into a format that all database types will accept. Thanks for helping out with

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-08-06 Thread Thijs Kinkhorst
Hello Matt, Sean, On Fri, 2006-07-28 at 22:16 +1200, Matt Brown wrote: I've built a package based on the current state of the branch and placed it at: http://www.mattb.net.nz/debian/dists/sid/main/source/admin/ Feel free to use it for testing. I've done so on a new package of mine. It took

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-07-28 Thread Matt Brown
sean finney wrote: if there are 2 or 3 packages that can already make use of it, i suggest that we do the following: Sounds like a good plan to me. - build yourself a dbconfig package from the sqlite branch - set up your sqlite-using package to use dbconfig I've built a package based on the

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-07-27 Thread sean finney
hi guys, On Wed, Jul 26, 2006 at 06:37:21PM +0200, Thijs Kinkhorst wrote: It just waiting on a bit more testing before I prompt sean again to get it into the proper release. That's good news - I'll check it out soon. If it works then I suggest to merge it into dbconfig-common soon, I can

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-07-26 Thread Thijs Kinkhorst
On Wed, 2006-07-26 at 09:41 +1200, Matt Brown wrote: I've recently added SQLite support to dbconfig-common because I need it for the phpwiki package. It's in the svn repository in a branch called sqlite http://svn.debian.org/wsvn/dbconfig-common/branches/sqlite/?rev=0sc=0 It just waiting

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-07-25 Thread Thijs Kinkhorst
Package: dbconfig-common Version: 1.8.17 Severity: wishlist Hello Sean, I see that you've mentioned this already in your TODO file in the package, but I'd like to register still that we (the phpgedview maintainers) would appreciate to see sqlite support in dbconfig-common. Since sqlite operation

Bug#379796: dbconfig-common: Please support sqlite as a database type

2006-07-25 Thread Matt Brown
tag 379796 + patch thanks Hi Thijs, Thijs Kinkhorst wrote: I see that you've mentioned this already in your TODO file in the package, but I'd like to register still that we (the phpgedview maintainers) would appreciate to see sqlite support in dbconfig-common. Since sqlite operation is