vtiger

[davidc304]

Hello,

Well ive searched and applied everything i know to do to get my INCOMING email to work properly. From the forums, Ive added lines of code, changed things, used port #'s, used ip addresses, bla bla bla. Eveything people have said on here that made their mail system work. To no avail.......

I CAN ping my mail server, i CAN recieve mail.
I CANNOT send mail. I am not using SSL.
V5.0.4 vtiger with PHP/MYSQL bundle package install on Windows 2000 Pro box.

Thanks guys and gals....

[prasad.a]

Hi davidc304,

Turn on logging to see more whats happening:

log4php.properties
Code: log4php.rootLogger = DEBUG, A1

Regards,
Prasad
vtiger Team

[davidc304]

Hello,

I spoke with a gentleman @ your office because i was unsure about this. But, he walked me through where i needed to make the change suggested above.

BUT, what do i do after that? Ive read that i need to view "vtigerCRM.log" right?

I am new to this, but this file appears to be a SETTINGS files only. It just shows me all variables and settings for PHP apache and etc.... im looking at the wrong file i think.....i do not see any errors just settings...

Thanks for helping

[davidc304]

Ok, now i am officially an idiot. Cleared the file, new messages come through, those were apparently my initial install settings.

Here is my problem as best I can tell. On this line of code, heres my error.

03/27/08 16:25:13,979 [664] INFO VT - PearDatabase ->Email id is selected => 'admin@comptechwv.com'

That is NOT the email address i am placing in the box. So, something in PearDatabase is messed up.

[davidc304]

These lines also appear suspicious.

03/27/08 16:25:24,024 [664] DEBUG index - Error in Mail Sending : Error log = 'SMTP Error: Could not connect to SMTP host1111111111=======>.'
03/27/08 16:25:24,026 [664] INFO VT - PearDatabase ->Inside the function getMailError
03/27/08 16:25:24,027 [664] INFO VT - PearDatabase ->Error message ==> connect_host
03/27/08 16:25:24,029 [664] INFO VT - PearDatabase ->return error => connect_host
03/27/08 16:25:24,030 [664] INFO VT - PearDatabase ->Inside getMailErrorString function.
Mail status string ==> admin@comptechwv.com=connect_host&&&
03/27/08 16:25:24,032 [664] INFO VT - PearDatabase ->All Mail status ==>
admin@comptechwv.com=connect_host

03/27/08 16:25:24,033 [664] INFO VT - PearDatabase ->Mail id & status ==> admin@comptechwv.com = connect_host
03/27/08 16:25:24,035 [664] INFO VT - PearDatabase ->Mail error string => 'admin@comptechwv.com=connect_host&&&'
03/27/08 16:25:24,336 [664] INFO VT - PearDatabase ->ADODB disconnect

[davidc304]

Any ideas? Ive exhausted all of mine, thanks.

[prasad.a]

Hi David,

Quote: 03/27/08 16:25:24,024 [664] DEBUG index - Error in Mail Sending : Error log = 'SMTP Error: Could not connect to SMTP host1111111111=======>.'

Outgoing Server name should be a valid SMTP servername/IP.

Try to check if the SMTP server is up and running via command line:
Code: telnet smtp_hostname 25

Regards,
Prasad
vtiger Team

[davidc304]

Oh yeah its running. i can telnet in no problem. any ideas? my log file shows this now, im using a different smtp server versus my incoming mail server. The account "admin@comptechwv.com" exists and the password is correct. I can use outlook to connect this way as well. But, alas, with this software it will not connect. Thanks


03/28/08 19:56:53,764 [2204] DEBUG index - Entering isPermitted(Settings,EmailConfig,) method ...
03/28/08 19:56:53,766 [2204] DEBUG index - Exiting isPermitted method ...
03/28/08 19:56:53,769 [2204] DEBUG index - Entering in function getTagCloudView(3)
03/28/08 19:56:53,770 [2204] DEBUG index - Prepared sql query being executed : select tagcloud_view from vtiger_users where id=?
03/28/08 19:56:53,772 [2204] DEBUG index - Prepared sql query parameters : [3]
03/28/08 19:56:53,775 [2204] DEBUG index - Exiting from function getTagCloudView(3)
03/28/08 19:56:53,804 [2204] INFO VT - PearDatabase ->Inside the parseEmailErrorString function.
encoded mail error string ==> YWRtaW5AY29tcHRlY2h3di5jb209JiYm
03/28/08 19:56:53,806 [2204] INFO VT - PearDatabase ->Original error string => admin@comptechwv.com=&&&
03/28/08 19:56:53,807 [2204] INFO VT - PearDatabase ->Mail id => "admin@comptechwv.com".........status => ""
03/28/08 19:56:53,809 [2204] INFO VT - PearDatabase ->Return Error string =>
03/28/08 19:56:53,810 [2204] DEBUG index - Prepared sql query being executed : select * from vtiger_systems where server_type = ?
03/28/08 19:56:53,811 [2204] DEBUG index - Prepared sql query parameters : [email]
03/28/08 19:56:53,814 [2204] DEBUG index - Entering return_module_language(en_us,Settings) method ...
03/28/08 19:56:53,815 [2204] DEBUG index - Exiting return_module_language method ...

[davidc304]

Someone please help me. I did a fresh install, now my log says this.....
I dont understand why this is such a problem, it should be the easiest part of the program???????

03/29/08 16:07:47,476 [3336] DEBUG index - Exiting isPermitted method ...
03/29/08 16:07:47,478 [3336] DEBUG Tracker - About to retrieve list: SELECT * from vtiger_tracker inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_tracker.item_id WHERE user_id=? and vtiger_crmentity.deleted=0 ORDER BY id DESC
03/29/08 16:07:47,481 [3336] DEBUG index - Prepared sql query being executed : SELECT * from vtiger_tracker inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_tracker.item_id WHERE user_id=? and vtiger_crmentity.deleted=0 ORDER BY id DESC
03/29/08 16:07:47,482 [3336] DEBUG index - Prepared sql query parameters : [1]
03/29/08 16:07:47,486 [3336] INFO VT - PearDatabase ->ADODB fetchByAssoc return null
03/29/08 16:07:47,526 [3336] DEBUG index - Entering isPermitted(Webmails,index,) method ...
03/29/08 16:07:47,528 [3336] DEBUG index - Exiting isPermitted method ...
03/29/08 16:07:47,615 [3336] INFO VT - PearDatabase ->ADODB disconnect
03/29/08 16:07:47,617 [3336] INFO VT - PearDatabase ->Entering MailBox(INBOX)
03/29/08 16:07:47,618 [3336] DEBUG index - Entering getMailServerInfo(admin) method ...
03/29/08 16:07:47,621 [3336] DEBUG index - Prepared sql query being executed : select * from vtiger_mail_accounts where status=1 and user_id=?
03/29/08 16:07:47,622 [3336] DEBUG index - Prepared sql query parameters : [1]
03/29/08 16:07:47,625 [3336] DEBUG index - Exiting getMailServerInfo method ...
03/29/08 16:08:00,316 [5884] INFO VT - PearDatabase ->ADODB disconnect
03/29/08 16:08:00,594 [5884] DEBUG SendReminder - invoked SendReminder
03/29/08 16:08:00,603 [5884] DEBUG SendReminder - Entering return_application_language() method ...
03/29/08 16:08:00,605 [5884] WARN SendReminder - Unable to find the application language file for language:
03/29/08 16:08:00,647 [5884] DEBUG SendReminder - Exiting return_application_language method ...
03/29/08 16:08:00,648 [5884] DEBUG SendReminder - Prepared sql query being executed : select vtiger_crmentity.crmid,vtiger_seactivityrel.crmid as setype,vtiger_activity.*,vtiger_activity_reminder.reminder_time,vtiger_activity_reminder.reminder_sent,vtiger_activity_reminder.recurringid,vtiger_recurringevents.recurringdate from vtiger_activity inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_activity.activityid inner join vtiger_activity_reminder on vtiger_activity.activityid=vtiger_activity_reminder.activity_id left outer join vtiger_recurringevents on vtiger_activity.activityid=vtiger_recurringevents.activityid left outer join vtiger_seactivityrel on vtiger_seactivityrel.activityid = vtiger_activity.activityid where DATE_FORMAT(vtiger_activity.date_start,'%Y-%m-%d, %H:%i:%s') >= '2008-03-29' and vtiger_crmentity.crmid != 0 and vtiger_activity.eventstatus = 'Planned' and vtiger_activity_reminder.reminder_sent = 0 group by vtiger_activity.activityid,vtiger_recurringevents.recurringid
03/29/08 16:08:04,633 [3336] INFO VT - PearDatabase ->Setting Mailbox Name
03/29/08 16:08:04,638 [3336] INFO VT - PearDatabase ->Opening Mailbox
03/29/08 16:08:04,639 [3336] INFO VT - PearDatabase ->Entering getImapMbox()
03/29/08 16:08:04,667 [3336] INFO VT - PearDatabase ->Parsing PHP Modules
03/29/08 16:08:04,668 [3336] INFO VT - PearDatabase ->Building connection string
03/29/08 16:08:04,670 [3336] INFO VT - PearDatabase ->Done Building Connection String.. {mail.comptechwv.com:143/imap2/notls/novalidate-cert/user=admin@comptechwv.com}INBOX Connecting to box
03/29/08 16:08:21,686 [3336] INFO VT - PearDatabase ->CONNECTION ERROR - Could not be connected to the server using imap_open function through the connection strings {mail.comptechwv.com:143/imap2/notls/novalidate-cert/user=admin@comptechwv.com}INBOX and {mail.comptechwv.com/imap2:143}INBOX
03/29/08 16:09:00,330 [6028] INFO VT - PearDatabase ->ADODB disconnect
03/29/08 16:09:00,592 [6028] DEBUG SendReminder - invoked SendReminder
03/29/08 16:09:00,593 [6028] DEBUG SendReminder - Entering return_application_language() method ...
03/29/08 16:09:00,595 [6028] WARN SendReminder - Unable to find the application language file for language:
03/29/08 16:09:00,632 [6028] DEBUG SendReminder - Exiting return_application_language method ...
03/29/08 16:09:00,633 [6028] DEBUG SendReminder - Prepared sql query being executed : select vtiger_crmentity.crmid,vtiger_seactivityrel.crmid as setype,vtiger_activity.*,vtiger_activity_reminder.reminder_time,vtiger_activity_reminder.reminder_sent,vtiger_activity_reminder.recurringid,vtiger_recurringevents.recurringdate from vtiger_activity inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_activity.activityid inner join vtiger_activity_reminder on vtiger_activity.activityid=vtiger_activity_reminder.activity_id left outer join vtiger_recurringevents on vtiger_activity.activityid=vtiger_recurringevents.activityid left outer join vtiger_seactivityrel on vtiger_seactivityrel.activityid = vtiger_activity.activityid where DATE_FORMAT(vtiger_activity.date_start,'%Y-%m-%d, %H:%i:%s') >= '2008-03-29' and vtiger_crmentity.crmid != 0 and vtiger_activity.eventstatus = 'Planned' and vtiger_activity_reminder.reminder_sent = 0 group by vtiger_activity.activityid,vtiger_recurringevents.recurringid

[davidc304]

I really want this to work, but i havent even gotten started with the program due to this "problem". UPDATE: I can no longer RECIEVE or SEND email. With my fresh install, i lost both.