[SOLVED] nessage store not showing recent messages

[bluebriarrose]

hi,

i'm having a problem understanding how exactly the message store works... below is a copy of mine... it shows all messages till aug 5.. after that it doesn't show anything... ((although the mails are showing in the mailboxes))
do i need to create a new store or something??

zimbra@cccbl:~/store/0> dir
total 0
drwxr-x--- 3 zimbra zimbra 72 Jul 10 13:00 1
drwxr-x--- 3 zimbra zimbra 72 Jul 24 16:31 10
drwxr-x--- 3 zimbra zimbra 72 Aug 3 11:51 12
drwxr-x--- 3 zimbra zimbra 72 Aug 5 17:36 13
drwxr-x--- 3 zimbra zimbra 72 Aug 3 11:52 14
drwxr-x--- 3 zimbra zimbra 72 Aug 5 17:36 16
drwxr-x--- 3 zimbra zimbra 72 Aug 3 15:31 17
drwxr-x--- 3 zimbra zimbra 72 Aug 3 15:41 18
drwxr-x--- 3 zimbra zimbra 72 Aug 4 12:44 2
drwxr-x--- 3 zimbra zimbra 72 Aug 4 10:36 21
drwxr-x--- 3 zimbra zimbra 72 Aug 5 17:36 24
drwxr-x--- 3 zimbra zimbra 72 Aug 5 17:36 25
drwxr-x--- 3 zimbra zimbra 72 Aug 5 17:36 26
drwxr-x--- 3 zimbra zimbra 72 Aug 5 17:36 27
drwxr-x--- 3 zimbra zimbra 72 Aug 5 17:36 28
drwxr-x--- 3 zimbra zimbra 72 Aug 5 17:36 29
drwxr-x--- 3 zimbra zimbra 72 Aug 5 17:36 30
drwxr-x--- 3 zimbra zimbra 72 Jul 10 16:36 4
drwxr-x--- 3 zimbra zimbra 72 Jul 10 16:22 5
drwxr-x--- 3 zimbra zimbra 72 Jul 10 16:22 6
drwxr-x--- 3 zimbra zimbra 72 Jul 10 16:31 7
drwxr-x--- 3 zimbra zimbra 72 Jul 25 11:17 8
drwxr-x--- 3 zimbra zimbra 72 Jul 22 16:53 9


abby

[uxbod]

That is the creation date on the folder; so you would need to look further down the tree.

[bluebriarrose]

what i'm trying to figure out here is on what basis the messages are filed/indexed/categorized.... it seems random to me....... i have 91 mailboxes... how do i find mail for any particular one without oing through each and every mail

abby

[uxbod]

Account mailbox database structure - Zimbra :: Wiki

[bluebriarrose]

that helps... but how do i log into mysql.... i didnt have it on my system earlier & zimbra automatically installed it.... there was password created while installing...

how do i find out which port it's at ??

( newbie abby

[phoenix]

that helps... but how do i log into mysql.... i didnt have it on my system earlier & zimbra automatically installed it.... there was password created while installing...

how do i find out which port it's at ??

Search the wiki for what you need.

[uxbod]

su - zimbra
mysql
show databases;

[bluebriarrose]

su - zimbra
mysql
show databases;

thanks...

that works... one further question... can i set a password for mysql?? how??? will zimbra pick it up automatically or do i have to reconfiure it??

abby

[uxbod]

su - zimbra
zmlocalconfig -s | grep -i mysql

[bluebriarrose]

Hi.. thanks for the reply i have changed the mysql password using the command "zmmypasswd --root newpass" but the thing is im still able to login via guest user of mysql using the command "mysql"... i want to disable guest login and want to allow only root login for the mysql....
also can i change the user of mysql from root to some other?????


Thanks..