"To:" Field shows the "always_bcc" email address after upgrading to master branch

[Cassio Simões]

I don't know if I did something wrong, but just after I've upgraded from 25rc2 to master branch this started to happen.

Please check attached files.

Thanks

Cassio

[Venkateswarlu Dadagopu]

Run the Mysql Script

delete from rcpt where to='[e-mail]';

Then it will resolve your problem

[Janos SUTO]

Show me

pilerconf -q hostid

, and I assume you copy everything to [e-mail], right?

[Cassio Simões]

That's correct, always_bcc = [e-mail], hostid=piler.cloudsupport.com.br

and the command that worked for me was: delete from rcpt where 'to'='[e-mail]';

I'll check if it solves the problem and post the results.

Thanks!

Cassio

[Cassio Simões]

It's not working, here's the output:

root@piler:~# mysql -u piler -p piler Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7518 Server version: 5.5.38-0+wheezy1 (Debian)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> delete from rcpt where to='[e-mail]'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to='[e-mail]'' at line 1 mysql> delete from rcpt where 'to'='[e-mail]'; Query OK, 0 rows affected (0.00 sec)

mysql> delete from rcpt where 'to'='[e-mail]'; Query OK, 0 rows affected (0.00 sec)

mysql> delete from rcpt where 'to = [e-mail]'; Query OK, 0 rows affected, 2 warnings (0.03 sec)

mysql> delete from rcpt where 'to=[e-mail]'; Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql> delete from rcpt where 'to=[e-mail]'; Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql> use piler Database changed mysql> delete from rcpt where 'to=[e-mail]'; Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql> delete from rcpt where 'to=[e-mail]'; Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql> delete from rcpt where 'to = [e-mail]'; Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql> delete from rcpt where 'to'='[e-mail]'; Query OK, 0 rows affected (0.00 sec)

mysql> delete from rcpt where to='[e-mail]'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to='[e-mail]'' at line 1

I still have the same problem... :/

Thanks for your help

[Venkateswarlu Dadagopu]

show me this

pilerconf -q hostid

[Cassio Simões]

root@piler:~# pilerconf -q hostid hostid=piler.cloudsupport.com.br

[Cassio Simões]

Anyway, I've rebooted, and this issue now seems to have gone away.

Thank you very much.

Cassio

[Janos SUTO]

OK

[Eugene Reuter]

I have same issue I deleted entries from rcpt table for [e-mail] And rebooted server but it did not helped. [root@mailarchiver ~]# pilerconf -q hostid hostid=mailarchiver.localhost

[Venkateswarlu Dadagopu]

Change hostid=mailarchiver.yourdomain.com

and run the script deleted entries from rcpt table for [e-mail]