cyradm: cyrus can see mailboxes, cyrus@domain.tld cannot

[David Newman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Greetings. Awhile back I set up cyrus and postfix using this excellent
howto:

http://www.wistful.net/wiki/Ed%27s_FreeBSD_Virtual_Mail_How-To

Using cyradm for mailbox maintenance, the 'lm' command only displays all
mailboxes if I log in as 'cyrus' and not 'cyrus at mydomain.com':

lancelot# cyradm --user cyrus at mydomain.com localhost
IMAP Password:
localhost> lm
INBOX (\HasChildren)         INBOX/spam (\HasNoChildren)
localhost> exit
lancelot#
lancelot#
lancelot# cyradm --user cyrus localhost
IMAP Password:
localhost> lm
((HUGE output, from many mailboxes, deleted))

There is a cyrus at mydomain.com account on this machine. I've also pasted
my imapd.conf below.

What's broken here? Where should I look?

many thanks

dn

imapd.conf:
configdirectory: /usr/local/imap
partition-default: /usr/local/imap/spool
unixhierarchysep: yes
servername: mydomain.com
autocreatequota: -1
sasl_pwcheck_method: auxprop
tls_cert_file: /usr/local/imap/server.pem
tls_key_file: /usr/local/imap/server.key
tls_ca_file: /usr/local/imap/cacert.pem
notifysocket: /usr/local/imap/socket/notify
virtdomains: yes
defaultdomain: domain1.tld
allowusermoves: yes
sasl_auxprop_plugin: sql
sasl_sql_user: postfix
sasl_sql_passwd: <shhhhhhh>
sasl_sql_database: postfix
sasl_sql_hostnames: localhost
sasl_sql_select: SELECT password FROM mailbox WHERE username='%u@%r' AND
active='1'
sasl_sql_verbose: yes
sasl_sql_engine: mysql
sasl_mech_list: plain login
sasl_password_format: crypt
createonpost: yes
autocreateinboxfolders: spam
autosubscribeinboxfolders: spam
autocreate_sieve_script: /usr/local/imap/phpscript
generate_compiled_sieve_script: yes
autocreate_sieve_compiledscript: /usr/local/imap/phpscript.bc

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFu4ckyPxGVjntI4IRAr2PAJ9iiyEYOOkQflaRds1qTwBAFEoKSACgtsNq
7PN8qEwC5MzqZ1RAWfntpNg=
=+RV6
-----END PGP SIGNATURE-----