I have used the 5.5.1 stack installer to install the Community edition on a Windows 2000 server.
This server is also running an intranet site that uses IIS and is using mySQL v6 databases so I set the http port in the stack installer to 81 and the mySQL port to 3307.
Everything appeared to be working fine - everybody could access the system without errors and perform their normal on-line tasks. I even sent a test email from a campaign successfully (although the unsubscribe link tried to take the recipient to "127.0.0.1:81" which would obviously only work on the server.
The problem came when I setup a batch file to run cron.php via task scheduler to send out "live" emails.
Whenever cron.php runs, it's saying "Unable to select database: Unknown database 'sugarcrm'".
It appears that cron.php is ignoring the mySQL port setting of 3307 and connecting using the default port 3306, thereby connecting to the mySQL6 server running on the same machine. (I have proved this by creating an empty database called sugarcrm on the mySQL6 server).
How can I get cron.php to connect on port 3307???


LinkBack URL
About LinkBacks



Reply With Quote

Bookmarks