Re: have everybody use public address book exclusively

Looking at /var/log/messages it seemed that owner_id needs a default value
on a database level:

Apr 24 20:30:29 luna HORDE: [turba] SQL QUERY FAILED: Field 'owner_id'
doesn't have a default value       INSERT INTO turba_objects (object_type,
object_firstname,       object_lastname, object_nameprefix,
object_namesuffix, object_email,       object_homeemail, object_workemail,
object_homephone,       object_homephone2, object_workphone,
object_workphone2,       object_assistantphone, object_homefax,
object_cellphone, object_fax,       object_homestreet, object_homecity,
object_homepostalcode,       object_homecountry, object_workstreet,
object_workpob,       object_workcity, object_workpostalcode,
object_workcountry, object_tz,       object_title, object_role,
object_company, object_department,       object_logo, object_manager,
object_notes, object_url,       object_pgppublickey, object_smimepublickey,
object_uid, object_id)       VALUES ('Object', 'Hans', 'Depp', '', '', '',
'', '', '', '', '', '',       '', '', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '',       '', NULL, '', '', '', '', '',
'20150424183029.rPQk6iCuvsK5ptqa3fx6i
Apr 24 20:30:29 luna HORDE: [turba] Serverfehler beim Hinzufügen der Daten.
[pid 68351 on line 432 of
"/usr/local/www/apache24/data/turba/lib/Driver/Sql.php"]

I resolved to set the default value for owner_id through phpmyadmin and
everything seems cool.

However, if I did this to a productive system I would worry if this was the
best - or at least a clean - way to do it.
For instance, would it make more sense to make the change in a
turba/migration/*.php file?

Regards

  Sebastian


2015-04-24 10:51 GMT+02:00 Sebastian Birnbach <[email protected]>:

> Firstly, I removed all permissions in the admin console, with no success.
> Next, I added turba permissions again and assigned full access to every
> logged-in user.
> Added full access for guests.
> Added full access for creator.
> Added full access for single user.
>
> Added "Sources" permissions to turba permissions. Set the same permissions
> as above.
>
> None of these settings seemed to make a difference.
>
>   Sebastian
>
> 2015-04-24 10:28 GMT+02:00 Jan Schneider <[email protected]>:
>
>>  Zitat von Sebastian Birnbach <[email protected]>:
>>
>>   Hmm, now everybody sees everything and everybody can make changes.
>> However, nobody can add a new contact.
>> Got another nice solution for this?
>>
>> Kind regards
>>
>>   Sebastian
>>
>> 2015-04-24 8:48 GMT+02:00 Sebastian Birnbach <[email protected]>:
>>
>>>  Bingo, thanks again!
>>>
>>>   Sebastian
>>>
>>> 2015-04-24 8:38 GMT+02:00 Jan Schneider <[email protected]>:
>>>
>>>>   *Zitat von Sebastian Birnbach <[email protected]
>>>> <[email protected]>>:*
>>>>
>>>>
>>>> *Thanks again, Jan,  *
>>>>
>>>>
>>>>
>>>>
>>>> *it appears that the now un-shared address book does not support user A
>>>> create a contact and let user B see it. In fact it behaves like a set of
>>>> private address books again, only without the option for sharing. Giving
>>>> permissions for the turba application (turba->sources->shared address
>>>> books) in the admin console to all users did not change things. Any ideas
>>>> on that?  *
>>>>
>>>> *Kind regards  *
>>>> *  Sebastian*
>>>>
>>>> *2015-04-22 9:21 GMT+02:00 Jan Schneider <[email protected]
>>>> <[email protected]>>:*
>>>>
>>>>>
>>>>> *Zitat von Sebastian Birnbach <[email protected]
>>>>> <[email protected]>>:*
>>>>>
>>>>>
>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> *Dear all, in my working environment everybody is supposed to use the
>>>>>> same address book. I therefore created a special user the address book of
>>>>>> who is accessible by any other user. Also, everybody can write into that
>>>>>> special address book. Now I want to remove or disable all personal address
>>>>>> books for everybody else so that for a search or new contact one needs not
>>>>>> select an address book. Any straightforward way to do that?*
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> *You should not use a shared address book then, but just a simple
>>>>> global sql address book. If you don't have a backend defined in
>>>>> backends.php that has 'use_shares' enabled, users won't be able to create
>>>>> or use their own address books. -- Jan Schneider The Horde Project
>>>>> http://www.horde.org/ <http://www.horde.org/>
>>>>> https://www.facebook.com/hordeproject
>>>>> <https://www.facebook.com/hordeproject> -- turba mailing list Frequently
>>>>> Asked Questions: http://wiki.horde.org/FAQ <http://wiki.horde.org/FAQ> To
>>>>> unsubscribe, mail: [email protected]
>>>>> <[email protected]>*
>>>>
>>>>
>>>>
>>>> *Remove the __owner attribute from the backend map.*
>>>>  ------------------------------
>>>>
>>>>
>>>>
>>>> *Jan Schneider The Horde Project http://www.horde.org/
>>>> <http://www.horde.org/> https://www.facebook.com/hordeproject
>>>> <https://www.facebook.com/hordeproject>*
>>>>
>>>
>>
>> You may have incorrect permissions set.
>>  ------------------------------
>> Jan Schneider
>> The Horde Project
>> http://www.horde.org/
>> https://www.facebook.com/hordeproject
>>
>
>
-- 
turba mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [email protected]