Koozali.org: home of the SME Server

My Addressbook databases ?

Offline wyron

  • *
  • 275
  • +0/-0
    • http://www.ideast.dk
My Addressbook databases ?
« on: April 18, 2004, 08:26:09 AM »
Can anyone give me a hint on where to look for Hordes 'My Addressbook' databases ?
After a fresh install and manual restore this is the only thing missing, and I have searched high and low for them in the restore library.
Greetings
wyron
...

ergozd

My Addressbook databases ?
« Reply #1 on: April 18, 2004, 08:44:43 AM »
They should be stored in horde horde database and turba_objects table.

You can check by running
[root@erginsme04 root]# mysqlshow horde
Database: horde
+-----------------------------+
|           Tables            |
+-----------------------------+
| horde_categories            |
| horde_categories_categories |
| horde_prefs                 |
| horde_users                 |
| kronolith_events            |
| mailaddr                    |
| mnemo_memos                 |
| nag_tasks                   |
| policy                      |
| turba_objects               |
| userpref                    |
| users                       |
| wblist                      |
+-----------------------------+

Access to table is handled by sources.php in
# /home/httpd/html/horde/turba/config

$cfgSources['localsql'] = array(
    'title' => 'My Addressbook',
    'type' => 'sql',
    'params' => array(
        'phptype' => 'mysql',
        'hostspec' => 'localhost',
        'username' => 'horde',
        'password' => '**********',
        'database' => 'horde',
        'table' => 'turba_objects'
.........................

Good luck.


make sure you have the correct username & password

Offline wyron

  • *
  • 275
  • +0/-0
    • http://www.ideast.dk
My Addressbook databases ?
« Reply #2 on: April 18, 2004, 10:25:29 AM »
Thanks for the tip, ergozd.
I compared the turba_objects tables in restore library and current config, and to be sure there was a difference in filesize.
A copy didn't reveal the missing addresses, though.
Too bad !
But thanks again.
Greetings
wyron
...