[turba] Readonly flag

[Claude Tompers]

On 09/11/2012 06:54 PM, Michael J Rubinsky wrote:
>
> Quoting Claude Tompers <claude.tompers at restena.lu>:
>
>> On 09/11/2012 02:57 PM, Michael J Rubinsky wrote:
>>>
>>> Quoting Claude Tompers <claude.tompers at restena.lu>:
>>>
>>>> On 09/11/2012 10:34 AM, Claude Tompers wrote:
>>>>> Hi,
>>>>>
>>>>> I just had a user complaining about an error message : QUERY FAILED:
>>>>> INSERT command denied to user ...
>>>>>
>>>>> backends.local.php sets $cfgSources['restena']['readonly'] = true;
>>>>> for
>>>>> this addressbook.
>>>>>
>>>>> Why is turba still trying to do an insert query with that flag set ?
>>>
>>> Do you have any other sources defined? In either backends.local.php or
>>> backends.php?
>> Only the standard 'localsql' Horde Addressbook.
>
> Well, then it's very likely that this is the source that the write is
> being attempted to, and your database's 'horde' user does not have
> INSERT permissions granted. You'll have to get the exact SQL statement
> being performed to be sure.
I'm sorry, I don't know if I made the setup very clear. There are in
fact 2 sources :

1) localsql for users personal addressbooks, where they can read and write
2) restena, containing all our users, but this is readonly.

The mysql user performing queries on the restena addressbook has only
select rights and should not need more as the addressbook is readonly
anyway.

Now one of our users selected restena addressbook as standard to add
contact via IMP. That's where he's got the error message containing the
query.

From a gui point of view, in my opinion, readonly addressbooks shouldn't
even be in a users list of addressbooks to add contacts to.

regards,
Claude

-- 
Claude Tompers
Ingénieur réseau et système
Fondation RESTENA - Réseau Téléinformatique de l'Education Nationale et de la Recherche
6, rue Richard Coudenhove-Kalergi
L-1359 Luxembourg

Tel: +352 424409 1
Fax: +352 422473


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 259 bytes
Desc: OpenPGP digital signature
URL: <http://lists.horde.org/archives/turba/attachments/20120912/80ea6a42/attachment.bin>