Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
By karentan
#790521
Hi all,

I am trying out the trial version of ProcessMaker. I would like to connect to SQL database, and followed the steps on http://wiki.processmaker.com/3.0/Databa ... nreachable, but still have the "Error Testing Connection: Checking port failed : Destination Port Unreachable" error.
The firewall on the database server is currently switched off.
ProcessMaker - DB Connection Error.PNG
ProcessMaker - DB Connection Error.PNG (17.9 KiB) Viewed 2602 times
Can someone please advise how to resolve this problem?
Thank you!
User avatar
By amosbatto
#790537
Did you reboot the server where SQL Server is installed after making your changes?

Also check whether both the servers running ProcessMaker and SQL Server have unblocked port 1433 in the firewall (or whichever port you are using for SQL Server).
By karentan
#790623
One question, I saw this part about putting the .dll file in the following folder.
But as I am using the trial version online, there is no installation folder.
How do I proceed from here?

Also, the SQL server is also a web server running on Windows IIS. Will this impact anything?
I am not familiar with php setup and web servers, thus all advice is really appreciated.

Thank you.
Attachments
ProcessMaker - DLL File.PNG
ProcessMaker - DLL File.PNG (67.91 KiB) Viewed 2557 times
User avatar
By amosbatto
#790637
If you are using the Trial Version Online, then connecting to SQL Server won't work, because the Trial Version uses PHP 5.6 which isn't compatible with FreeTDS.

Currently, the only solution is to install ProcessMaker with PHP 5.5.X on your own server and then use the version of FreeTDS which is compatible with PHP 5.5.X.
By karentan
#790693
Thank you Amos, that was really helpful.
I downloaded the Community Edition to host locally and the SQL connection works.
Which brings me to my other concerns, can the Community Edition be only hosted locally?
Also, what is the php version of the Enterprise version? Is there any way I can find out?
Thank you once again for being patient with me as I am new to php and web servers and sort :)
User avatar
By amosbatto
#790732
PM Enterprise Edition can be installed in any server that uses PHP 5.5 or 5.6. You can check the PHP version by going to Admin > System Information. If you don't have access to the Admin menu, then you can create a trigger which has this code:
Code: Select all
phpinfo();
die; 
Set this trigger to fire at some point in your process and run a case to execute it.

The Community Edition can be installed in the cloud. If you need to access ProcessMaker from the internet, you can rent a cheap VPS (virtual private server) or use a cloud such as MS Azure, Amazon AWS, etc. For example, Afterburst offers unmetered LInux VPSes for $7 per month and they are reliable in my experience.

As you have got seen that after every single updat[…]

issue with processmaker 3.2

Hello! The solution to your question is the foll[…]

BPMN project disappeared

Hi Alex! , maybe you forgot to save your process[…]

mcrypt extension is deprecated!

Hello Ehsan! If you did not find the mcrypt ext[…]