1 (edited by it-support 2015-04-29 17:57:08)

Topic: Email Alias added via MySQL are not visible under iRedAdmin-Pro(MySQL)

================ Required information ====
- iRedMail version: iRedAdmin-Pro-MySQL-1.9.2
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Linux/BSD distribution name and version: Scientific Linux release 6.6 (Carbon)
- Related log if you're reporting an issue:
====

Hi,

Until recently, we were using iRedAdmin open source edition.
As per http://www.iredmail.org/forum/topic2364 … dmail.html
We used MySQL command line to add/maintain Email Aliases.

Now we have upgraded to iRedAdmin-Pro-MySQL-1.9.2

Using iRedAdmin-Pro Admin panel, at
https://********/iredadmin/domains

we can see correct number of Aliases (e.g. 87)
Refer to screen-shot-1 (redadmin-screen-shot-1.PNG)

But when go through (for that particular domain name)
https://********/iredadmin/aliases/domain.name
we don't see any Alias listings. It's empty.
Refer to screen-shot-2 (iredadmin-screen-shot-2.PNG)


Please help

Post's attachments

iredadmin-screen-shot-1.PNG
iredadmin-screen-shot-1.PNG 75.5 kb, file has never been downloaded. 

iredadmin-screen-shot-2.PNG
iredadmin-screen-shot-2.PNG 58.36 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Email Alias added via MySQL are not visible under iRedAdmin-Pro(MySQL)

The formatting of your Aliases may be good enough for Postfix but might not be exactly how iRedAdmin-Pro manages it. Could you show us an example of a line or few of these alias entries so we can tell you what's wrong with them/give you a Query to repair them?

3

Re: Email Alias added via MySQL are not visible under iRedAdmin-Pro(MySQL)

Do you have column 'islist=1' in SQL table 'vmail.alias' for these mail alias accounts?

It's better to show us how you create a mail alias account, then we can tell you what the problem is.

4

Re: Email Alias added via MySQL are not visible under iRedAdmin-Pro(MySQL)

Aliases were created as follows:

mysql> USE vmail;

mysql> INSERT INTO alias (address, goto, domain, created, active) VALUES ('name.surname@domain.it, 'my_user@gmail.com', 'domain.it', NOW(), 1);

Sample query as follows:

mysql> SELECT * FROM alias WHERE address ='vanessa@domain.it';
+-------------------+--------------------------+------+------------+--------------+----------------+--------+---------------------+---------------------+---------------------+--------+
| address           | goto                     | name | moderators | accesspolicy | domain         | islist | created             | modified            | expired             | active |
+-------------------+--------------------------+------+------------+--------------+----------------+--------+---------------------+---------------------+---------------------+--------+
| vanessa@domain.it | vanessa@domain.external  |      | NULL       |              | domain.it      |      0 | 2015-01-29 15:00:01 | 0000-00-00 00:00:00 | 9999-12-31 00:00:00 |      1 |
+-------------------+--------------------------+------+------------+--------------+----------------+--------+---------------------+---------------------+---------------------+--------+

5

Re: Email Alias added via MySQL are not visible under iRedAdmin-Pro(MySQL)

islist should be 1 for the aliases, this seems to be why iRedAdmin-Pro cannot see them