Mail Address showing wrong in Auditor Login

[Venkateswarlu Dadagopu]

Mail

From Address showing right

but to address showing in all mails same mail id Please find the screen shot.

but in content its is showing right mail id

what should i do from and to address will need display right

[Janos SUTO]

Please show me the full header of an email.

[Venkateswarlu Dadagopu]

Received: by mail-pa0-f51.google.com with SMTP id ey11so10005571pad.10 for [e-mail]; Mon, 28 Jul 2014 00:19:10 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:delivered-to:domainkey-signature:dkim-signature :message-idfrom:reply-to:to:subject:mime-version:content-type; bh=v5fi3VYdKN7QK92hoZe5+21bzGfsz5aaXt+2TxxOIw4=; b=i3rAsOTKeDUJ4PTMp0p1lKBFsyWs4Na7QxMOcIah8BqnyRgsqd1WhTEJ+lBan2F/Te aE8XRFiMSpwm0dGC41EAY69nRVm791Axsh9/GxP2Va3shUVpLNQp2v3TKjPjeppfAgNv 8iApx7/UrtzcbUZXR0ldI78xHnbuMbAk4ebSIQOvMsJKoaA6DNdMQ475PE1nWPDqaaHs cYSrNJn13hO7CeZERUlzNDB900UjQGyHhHjUzJbecR2PAQPZa5OSNrtV2lnK6DM0GqGX KEMgccaZqM6PgVULZ1w/d6rmY7GpBqEzif5uaPCtoHw7EOCEsbcVjGNP0mo18fQDOhSi s5Lg== X-Received: by 10.68.166.36 with SMTP id zd4mr36695370pbb.54.1406531950428; Mon, 28 Jul 2014 00:19:10 -0700 (PDT) X-Gm-Message-State: ALoCoQk3BsSOgRNUh0M7FjGvDSRYjRFW39JRduefeE32gsNCiUTbKNz23B/luYn83qntCXQxKKNxFVpSfGWAcNbe9MqH8b4wPd7XGYkwbJq5vKrE9R3JJQ/gUNrind/xmNwQLCDjLAwP0jZ5T/79O9iWTwQ+QPCpUQ== X-Received: by 10.68.166.36 with SMTP id zd4mr36695321pbb.54.1406531949750; Mon, 28 Jul 2014 00:19:09 -0700 (PDT) Return-Path: rahuul.m+caf_=rahul=[e-mail] Received: from mail-pa0-x234.google.com (mail-pa0-x234.google.com [2607:f8b0:400e:c03::234]) by mx.google.com with ESMTPS id ma10si1713733pdb.74.2014.07.28.00.19.09 for [e-mail] (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Mon, 28 Jul 2014 00:19:09 -0700 (PDT) Received-SPF: pass (google.com: domain of rahuul.m+caf_=rahul=[e-mail] designates 2607:f8b0:400e:c03::234 as permitted sender) client-ip=2607:f8b0:400e:c03::234; Authentication-Results: mx.google.com; spf=pass (google.com: domain of rahuul.m+caf_=rahul=[e-mail] designates 2607:f8b0:400e:c03::234 as permitted sender) smtp.mail=rahuul.m+caf_=rahul=[e-mail]; dkim=pass header.i=@magicbricks.com Authentication-Results: kolkata.tbsl.in; dkim=neutral (message not signed) header.i=none Received: by mail-pa0-f52.google.com with SMTP id bj1so9978937pad.39 for [e-mail]; Mon, 28 Jul 2014 00:19:09 -0700 (PDT) X-Received: by 10.68.225.133 with SMTP id rk5mr35937785pbc.101.1406531949395; Mon, 28 Jul 2014 00:19:09 -0700 (PDT) X-Forwarded-To: [e-mail] X-Forwarded-For: [e-mail] [e-mail] Delivered-To: [e-mail] Received: by 10.70.61.138 with SMTP id p10csp209673pdr; Mon, 28 Jul 2014 00:19:08 -0700 (PDT) X-Received: by 10.69.20.97 with SMTP id hb1mr848201pbd.150.1406531948710; Mon, 28 Jul 2014 00:19:08 -0700 (PDT) Return-Path: [e-mail] Received: from kolkata.tbsl.in (kolkata.tbsl.in. [115.112.206.193]) by mx.google.com with ESMTP id wz7si16869078pab.5.2014.07.28.00.19.03 for [e-mail]; Mon, 28 Jul 2014 00:19:08 -0700 (PDT) Received-SPF: pass (google.com: domain of [e-mail] designates 115.112.206.193 as permitted sender) client-ip=115.112.206.193; DomainKey-Signature: s=main; d=magicbricks.com; c=nofws; q=dns; h=Authentication-Results:Received:Message-ID:Date:From: Reply-To:To:Subject:MIME-Version:Content-Type:X-Priority; b=PinzxnmTLuhgGUNSzi5FPaSbd/cwwUD+o208EEQxndlUF9g5DNt2ju1D 4J1rA7f4E8BDNwayLWiHqGksLhDMUEZf25sGnt6fjAOjuyi33N8OyBPW9 NjDV7XpPXnGZzOp3yVJg0nd4fHj/Yrl0vSS0kurzPl6lLh83KiEBj79bH k=; DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=magicbricks.com; i=[e-mail]; q=dns/txt; s=main; t=1406531945; x=1438067945; h=received:message-idfrom:reply-to:to:subject: mime-version:content-type:x-priority: authentication-results; z=Received:=20from=20unknown=20(HELO=20MB-BatchMailer)=20( [192.168.206.146])=0D=0A=20=20by=20kolkata.tbsl.in=20with =20ESMTP=3B=2028=20Jul=202014=2012:46:58=20+0530 |Message-ID:=20<1001763761.2503061406551210910.JavaMail.r oot@MB-BatchMailer>|Date:=20Mon,=2028=20Jul=202014=2018:1 0:10=20+0530=20(IST)|From:=20MagicBricks=20<alerts@magicb ricks.com>|Reply-To:=[e-mail]|To:=20rahu [e-mail]|Subject:=20New=20Projects=20in=20Hyderabad =20Prajay=20Megapolis-=20Starting=20at=20Rs=2030.9=0D=0A =20Lac(s)=20&=20Vasathi=20Anandi|MIME-Version:=201.0 |Content-Type:=20multipart/mixed=3B=20=0D=0A=09boundary =3D"----=3D_Part_250278_1753960767.1406551210910" |X-Priority:=203|Authentication-Results:=20kolkata.tbsl.i n=3B=20dkim=3Dneutral=20(message=20not=20signed)=20header .i=3Dnone; bh=9oBzpXsxgSJhKpnMGkcRR7l6OskiZPFN1t52zxjiesg=; b=BSMZaJkxsJO8aVvVCMz3BDTBZK69t/2DXQKUU5DXN5EZDwdU4I+jtgD1 Ozmb7Nu1o2DPAwwI63/blxB8HDz6+rj1bHa7im2pJNKSf8k/tkTgVLiMY ueYdSBUadrPA/OP2zYtiP7klROBhX2Pw3/xyqiO4l3KfhsbbSFbj+pwzC w=; Received: from unknown (HELO MB-BatchMailer) ([192.168.206.146]) by kolkata.tbsl.in with ESMTP; 28 Jul 2014 12:46:58 +0530 Message-ID: 1001763761.2503061406551210910.JavaMail.root@MB-BatchMailer Date: Mon, 28 Jul 2014 18:10:10 +0530 (IST) From: MagicBricks [e-mail] Reply-To: [e-mail] To: [e-mail] Subject: New Projects in Hyderabad Prajay Megapolis- Starting at Rs 30.9 Lac(s) & Vasathi Anandi MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_250278_1753960767.1406551210910" X-Priority: 3

[Janos SUTO]

OK, and please also show me: "pilerconf -q hostid" as well

[Venkateswarlu Dadagopu]

[root@archive ~]# pilerconf -q hostid hostid=archive.carehoospitals.com

[Venkateswarlu Dadagopu]

hostid=archive.carehoospitals.com

[Venkateswarlu Dadagopu]

hostid=archive.carehoospitals.com Now I changed to hostid=archive.carehospitals.com

[Janos SUTO]

Notice the typo: you have two 'o'-letters, that's what caused the trouble. So fix the name in piler.conf, then reload or restart the piler daemon. Finally execute the following sql query:

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

After that you should see the proper email addresses in the search results.

[Venkateswarlu Dadagopu]

Error Showing

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

[Janos SUTO]

Try this:

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

[Venkateswarlu Dadagopu]

Again Error

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

[Janos SUTO]

The bitbucket form crippled my special characters. I've updated it, see above, I think it will work this time.

[Venkateswarlu Dadagopu]

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

now its worked got it thanks for your support you support is amazing

[Janos SUTO]

You are welcome, I'm glad that it works by now.