[Sqlgrey-users] database configuration

[Paweł Madej]

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

[Dan Faerch]

Post by Paweł Madej
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

[Paweł Madej]

Post by Dan Faerch
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

[Lionel Bouton]

The Sun, 03 Oct 2010 22:27:02 +0200,

[...] 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

[Paweł Madej]

On Sun, 3 Oct 2010 22:52:07 +0200, Lionel Bouton

Post by Lionel Bouton
The Sun, 03 Oct 2010 22:27:02 +0200,

[...] 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