sqlgrey-users

[Sqlgrey-users] database configuration

[Paweł M. <paw...@pr...>]

Hello,

Is it possible to reconfigure sqlgrey script to store default tables 
in itself but allow to add table prefixes on my own? also it will be 
helpfull to get db structure in attached file not auto create because 
of permissions to db. I do not want to to give sqlgrey user permissions 
to operate on creating tables indexes and so on. only plain usage on 
previously created tables.

Greets
Pawel Madej

Re: [Sqlgrey-users] database configuration

[Dan F. <da...@ha...>]

On 2010-10-03 09:12, Paweł Madej wrote:
> Hello,
>
> Is it possible to reconfigure sqlgrey script to store default tables 
> in itself but allow to add table prefixes on my own? also it will be 
> helpfull to get db structure in attached file not auto create because 
> of permissions to db. I do not want to to give sqlgrey user permissions 
> to operate on creating tables indexes and so on. only plain usage on 
> previously created tables.
>   
I dont remeber if theres an option for table prefixes.
But as for the second part of your question, cant you just give
permissions to create tables and indexes on first run? Then revoke these
when tables have been created?


- Dan

Re: [Sqlgrey-users] database configuration

[Paweł M. <paw...@pr...>]

On Sun, 03 Oct 2010 15:55:26 +0200, Dan Faerch <da...@ha...> wrote:
> I dont remeber if theres an option for table prefixes.
> But as for the second part of your question, cant you just give
> permissions to create tables and indexes on first run? Then revoke these
> when tables have been created?

I know that there are no prefixes for tables but this was rather
request to developers who I hope subscribe this list, as sqlgrey is
great piece of antispam software. 

Yes I can do this but if there is sqlgrey.sql schema this could be
easier to me to prepare full db schema for all services I use and use
this after loading to mysql server. Now if I want to use my database I
need to edit sqlgrey main file and add prefixes to tables.

If it is possible to change then great, if not I will edit this every
implemented server, but comparing other software which stores data in
mysql its rather common to have above features.

--
Greets
Pawel

Re: [Sqlgrey-users] database configuration

[Lionel B. <lio...@bo...>]

The Sun, 03 Oct 2010 22:27:02 +0200,
Paweł Madej <paw...@pr...> wrote:

> [...] Now if I want to use my database I
> need to edit sqlgrey main file and add prefixes to tables.

I don't see any valid reason why an admin could not use a dedicated
database for SQLgrey. Every officially supported DBMS (PostgreSQL,
MySQL and SQLite) supports multiple databases, it's a core feature
every DBA should expect and use.
For software designed to share a common database (with a set of
commonly used reference tables for example) I can understand prefixes.
In SQLgrey's case it seems to me it's complexity for no good reason.

Lionel

Re: [Sqlgrey-users] database configuration

[Paweł M. <paw...@pr...>]

On Sun, 3 Oct 2010 22:52:07 +0200, Lionel Bouton
<lio...@bo...> wrote:
> The Sun, 03 Oct 2010 22:27:02 +0200,
> Paweł Madej <paw...@pr...> wrote:
> 
>> [...] Now if I want to use my database I
>> need to edit sqlgrey main file and add prefixes to tables.
> 
> I don't see any valid reason why an admin could not use a dedicated
> database for SQLgrey. Every officially supported DBMS (PostgreSQL,
> MySQL and SQLite) supports multiple databases, it's a core feature
> every DBA should expect and use.
> For software designed to share a common database (with a set of
> commonly used reference tables for example) I can understand prefixes.
> In SQLgrey's case it seems to me it's complexity for no good reason.
> 
> Lionel

Hello,

The reason for which I need sqlgrey with prefixed tables is that I got
set foreign keys to other mail tables which manage optin/out and so on.
This if for consistency of my mail database. Prefixes also give me
better readability of tables.

With different tables it isn't possible.
--
Greets
Pawel