Hmm.. AD, PHP, and POP

[joe.jacobson]

I can't seem to get the e-mail parser to work, and i have a host of problems. Been trolling the boards and i can't seem to find a solution.

I'm running II6 on a Win 2003 box. I installed the latest and greatest Support Suite with Zend 2.1 and PHP 5. When i went to run the auto setup, the screen was completly blank. Sent in a ticket to the support folks, who told me to downgrade to php 4.

So i removed php 5, installed 4, and then ran the setup.php for support suite. I need to get the AD support working, and i read on someone's post that you need to have php 5 running for that, so i removed php4 and upgraded to 5. This made all my dashboards/logins blank (as before). I set up my php.ini file as per the directions in the sticky in this forum.

So i guess my first question is... how the heck can i get php5 to run the support suite?

And my second is:

my cron/index.php?_t=parser kicks back an error saying "Invalid remote specification Inbox" I _should_ have my pop settings correct, and the Exchange server is configured to allow the esupport mailbox to be checked with pop3 and/or imap. Am I missing something here? How do i get this to work?

[jamesM]

I have not installed the support suite on windows 2003 only 2000 but I can send you my php.ini if you want or a print out of phpinfo() . I have the owned support suit running under windows 2000 with Exchange 2003 and AD so t does work :-)

[joe.jacobson]

I still havn't been able to run this on PHP 5, but i read in the manual somewhere that if you are getting blank screens you should turn off gzip (set the level to zero). I havn't tried that yet, but it sounds remotely similar to the problem i'm having.

The other issue i'm having is with the exchange email server.

When running the /cron/index.php?_t=parser cron job, it kicks out this message:

array(1) { [0]=> string(105) "Can't open mailbox {(server):993/imap/ssl/novalidate-cert/notls}INBOX: invalid remote specification" } Total Messages
Rejected Messages:
Accepted Messages:

Any Ideas?

**Edit**
POP and IMAP are enabled for the exchange account i created for the Support Suite to use.

[MisterPopularity]

same here (exchange 2003 where pop3 in outlook works fine), only I'm getting this:

Warning: imap_open() [function.imap-open]: Couldn't open stream {mail.mydomain.com:995/pop3/ssl/novalidate-cert/notls}INBOX in D:\path\to\swift\modules\parser\cron_parser.php on line 84
array(1) { [0]=> string(110) "Can't open mailbox {mail.mydomain.com:995/pop3/ssl/novalidate-cert/notls}INBOX: invalid remote specification" } Total Messages
Rejected Messages:
Accepted Messages:

I have IIS 6.0, PHP 5.1.5 and the latest 3.00.90 supportsuite upgraded today. someone PLEASE help

[joshopkins]

This is what i am getting on both imap and pop3 with or without ssl.

Warning: imap_open() [function.imap-open]: Couldn't open stream {10.10.1.10:110/pop3/notls}INBOX in C:\inetpub\wwwroot\modules\parser\cron_parser.php on line 82
array(4) { [0]=> string(49) "Logon failure: unknown user name or bad password." [1]=> string(49) "Logon failure: unknown user name or bad password." [2]=> string(49) "Logon failure: unknown user name or bad password." [3]=> string(23) "Too many login failures" } Total Messages
Rejected Messages:
Accepted Messages:

I have checked the protocols in both outlook and thunderbird and they work.

[MisterPopularity]

i feel for you! Exchange is even more of a bitch to work with

[Varun Shoor]

"invalid remote specification" can happen if you didnt compile your PHP IMAP with SSL Support. Make sure you do that and the error should go away.

The Logon failure will happen if you put in wrong username or password, please double check that.

Regards,

Varun Shoor

[joshopkins]

I know that exchange is rough i am also using it. Ok so i solved one problem, but now it looks like i have run into another.

when I run http://helpdesk/cron/index.php?_t=parser I get:

Total Messages in Inbox: 1
Fetching Msg Num: 1
Account is POP3
Fetching Msg UID: 1
1 Total Messages
Rejected Messages: 0
Accepted Messages: 1

Invalid SQL: INSERT INTO `swauditlogs` (`ticketid`, `staffid`, `departmentid`, `userid`, `dateline`, `logtype`, `actiontype`, `actionmsg`) VALUES ('2', '', '1', '1', '1156914456', '5', '14','Setting Due Time To: 30 Aug 2006 03:07 PM'),('2', '', '1', '1', '1156914456', '2', '11','New Ticket Created By Joshua Hopkins'); (Out of range value adjusted for column 'staffid' at row 1)

I do see the new ticket in the staff panel.

This is a new install so i have not setup any staff yet. When I reveiced this error i went to the admin panel to setup some staff members and I receive the following error at the top of the page after i hit submit:

Invalid SQL: INSERT INTO ‘swstaff’ (‘fullname’ , ‘username’ , ‘password’ , ‘staffgroupid’ , ‘email’ , ‘mobilenumber’ , ‘lastvisit’ , ‘lastactivity’ , ‘timezoneoffset’ , ‘enabledst’ , ‘startofweek’ , ‘pmunread’ , ‘groupassign’ , ‘enablepmalerts’ , ‘enablepmjsalerts’) VALUES (‘josh’,’jhopkins’,’fc26a25b41496f0f05eca5ded01021 8f’,’1’,’jhopkins@domain.com’,’’,’156914291’,15691 4291’,’99’,’0’,’’,’0’,’,0’,’1’,’1’);(Out of range value adjusted for column ‘startofweek’ at row 1)


I am using php 4.4.4, mysql 5, iis 6, windows 2003 sp 1. Anyone else had problems adding staff.