A problem was found with your Postfix virtual maps

first post so hi everyone

prb:
A problem was found with your Postfix virtual maps : No map sources were found in the Postfix configuration

so i’ve configured postfix like in this howto. And it seems to workin i can send and recive messages, create virtual domains, users etc.

in webmin>servers>postfix>mail aliases i’ve setup “Alias databases used by the local delivery agent” to “proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf” the same like virtual_alias_maps in postfix main.cf

i’ve tried to reinstall virtualmin, webmin but it didnt help. I can not reinstall it like in this thread.

can anyone help me with this prb
rgds and sorry for my english

Urgh. Don’t use MySQL maps.

Postfix just needs the following:

virtual_alias_maps = hash:/etc/postfix/virtual

ok I’m new to this as well but, my system is working
why change it if is working.

if i change "proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf" in postfix main.cf

to

virtual_alias_maps = hash:/etc/postfix/virtual

would this mess up my email address I have already created in Mysql
don’t my email users loosing mail.
just being cautious,

Howdy,

Yeah, unless you see all your aliases currently listed in /etc/postfix/virtual, things will definitely break if you changed your virtual_alias_maps like you mentioned above.

You of course could migrate it from MySQL to the virtual file, but I’m not aware of a quick and easy way to do that.
-Eric

is it possible to make a symbolic link to Mysql from virtual

Unfortunately, the MySQL database isn’t akin to how the virtual file would work, it’s not as straight forward as just being able to link from one to the other.

It’s possible that Joe may have a trick up his sleeve for how to handle this, but barring that the only way I’m aware of to solve this would be to manually add all the addresses you have in MySQL to the virtual file (yes, I’m aware of how much that sucks :wink:
-Eric

I’m sure it’s easily scriptable, but there is no standard schema (de facto or RFC-based) for users in MySQL…which is one of the many reasons I consider putting system users into MySQL a really bad idea (I like being able to use standard tools, and users in MySQL is not a standard tools kinda solution).

But, a few minutes with the MySQL command line tool, or Perl or PHP or Python or Ruby (or any language with a reasonable MySQL interface) you should be able to whip something up. Just pull out the list of users and feed it into Virtualmin’s create-mail function, like so:

virtualmin create-user --domain domain.tld --user username --pass password

Since I don’t know the schema in your MySQL users table, I can’t begin to guess what the exact incantation would be to pull out the data you need.