Am 23.04.2013 08:48, schrieb Thomas Raschbacher:
> hi.
> 
> i was just reading http://dbmail.org/dokuwiki/doku.php/shared-mbox and was 
> wondering .. has anyone tried this on
> dbmail 3.x? do the instructions still apply as-is?
> 
> -- I don't wanna mess up my db because of this ;)

surely, since 2009 and there is no difference to dbmail 2.x nor
can you mess up the database with it, the ACLs do not change any
data

the flag fields are usually set to 1

mysql> show fields from dbmail_acl;
+-----------------+---------------------+------+-----+---------+-------+
| Field           | Type                | Null | Key | Default | Extra |
+-----------------+---------------------+------+-----+---------+-------+
| user_id         | bigint(20) unsigned | NO   | PRI | 0       |       |
| mailbox_id      | bigint(20) unsigned | NO   | PRI | 0       |       |
| lookup_flag     | tinyint(1)          | NO   |     | 0       |       |
| read_flag       | tinyint(1)          | NO   |     | 0       |       |
| seen_flag       | tinyint(1)          | NO   |     | 0       |       |
| write_flag      | tinyint(1)          | NO   |     | 0       |       |
| insert_flag     | tinyint(1)          | NO   |     | 0       |       |
| post_flag       | tinyint(1)          | NO   |     | 0       |       |
| create_flag     | tinyint(1)          | NO   |     | 0       |       |
| delete_flag     | tinyint(1)          | NO   |     | 0       |       |
| administer_flag | tinyint(1)          | NO   |     | 0       |       |
| deleted_flag    | tinyint(1)          | NO   |     | 0       |       |
| expunge_flag    | tinyint(1)          | NO   |     | 0       |       |
+-----------------+---------------------+------+-----+---------+-------+
13 rows in set (0.00 sec)


mysql> select user_id,mailbox_id from dbmail_acl;
+---------+------------+

| user_id | mailbox_id |

+---------+------------+

|     133 |       3369 |

|     154 |       3369 |

|     155 |       1316 |

|     155 |       1317 |

|     155 |       1319 |

|     155 |       2178 |

|     155 |       2201 |

|     155 |       2206 |

|     155 |       2207 |

|     155 |       2212 |
|     155 |       2216 |
|     155 |       2220 |
|     155 |       2221 |
|     155 |       2222 |
|     155 |       2223 |
|     155 |       2224 |
|     155 |       2225 |
|     155 |       2227 |
|     155 |       2228 |
|     155 |       2229 |
|     155 |       2230 |
|     155 |       2231 |
|     155 |       2232 |
|     155 |       2233 |
|     155 |       2283 |
|     155 |       2670 |
|     155 |       2751 |
|     155 |       2784 |
|     155 |       3046 |
|     155 |       3059 |
|     155 |       3097 |
|     155 |       3102 |
|     155 |       3195 |
|     155 |       3196 |
|     155 |       3197 |
|     155 |       3198 |
|     155 |       3369 |
|     158 |       3369 |
|     745 |       3369 |
|     799 |       2730 |
+---------+------------+
40 rows in set (0.00 sec)

Attachment: signature.asc
Description: OpenPGP digital signature

_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to