Page 1 of 2
Mysql in Mac OSX
Posted: Wed Feb 19, 2014 3:26 am
by Chan Kuan Leang
Can stimulsoft Reports.Fx for PHP work in Mac OSX mavericks?
I have a mysql database in mac osx. But I not able to connect to it & it always give me Connection errors with error code #2032
Smile
Chankl78
Re: Mysql in Mac OSX
Posted: Wed Feb 19, 2014 11:21 am
by HighAley
Hello.
Could you specify which version do you use?
The connection is initiated from server side. Please, check if you have access to the database from the PHP Server.
Thank you.
Re: Mysql in Mac OSX
Posted: Wed Feb 19, 2014 1:54 pm
by Chan Kuan Leang
I am connecting to my localhost while working on this report.
I am using Mac environment to do this. I have install stimulreport and create a virtual host to host it and trying to connect to mysql in my mac.
This is the version I am using now.
Re: Mysql in Mac OSX
Posted: Thu Feb 20, 2014 11:30 am
by Vladimir
Hello,
Please do the following steps:
1. In the 'config.xml' file the EnableDataLogger option set to True in Connection section.
2. Run the report designer with this report and click to Test button in the Connection dialog.
3. Click on the 'Save Log File' button in the designer's main menu.
4. Save the text file and send it to us for analysis.
Thank you.
Re: Mysql in Mac OSX
Posted: Sun Feb 23, 2014 1:00 am
by Chan Kuan Leang
Hi, sorry for missing action for a few days due to work overload.
This is the file you required. Thanks for helping.
Re: Mysql in Mac OSX
Posted: Mon Feb 24, 2014 8:23 am
by Vladimir
Hello,
You need to use the index.php file to start the designer:
Code: Select all
http://print.local.com/stimulsoft/index.php?stimulsoft_client_key=DesignerFx
The more detail you can read about it in our FAQ at the link below:
http://www.stimulsoft.com/en/faq/reports-fx-php
Thank you.
Re: Mysql in Mac OSX
Posted: Mon Feb 24, 2014 10:46 am
by Chan Kuan Leang
Thank you so much!!
I will read the faq. Thanks.
Re: Mysql in Mac OSX
Posted: Mon Feb 24, 2014 12:28 pm
by HighAley
Hello.
Let us know if you need any additional help.
Thank you.
Re: Mysql in Mac OSX
Posted: Mon Feb 24, 2014 1:59 pm
by Chan Kuan Leang
So far still researching how to use it in php. Right now, I can save the report into the folder of stimulsoft. but the problem when I not able to load the report when I try to call it with below link.
http://ssasoft.local.com/public/stimuls ... Report.mrz
it always give me an empty report.
Please advice where do I need to save the report?
Is it in stimulsoft/reports of my server? or just inside stimulsoft?
Thanks.
Re: Mysql in Mac OSX
Posted: Mon Feb 24, 2014 2:45 pm
by Chan Kuan Leang
I manage to understand how to call the report by including the following lines in the index.php.
Code: Select all
function sti_get_report($report_key)
{
switch ($report_key)
{
case "Report1": return file_get_contents("/reports/Report.mrz");
case "Report2": return file_get_contents("/reports/Report.mrt");
//case "report2": return file_get_contents("/reports/Document.mdc");
}
if (file_exists("../reports/$report_key")) return file_get_contents("../reports/$report_key");
// If there is no need to load the report, then the empty string will be sent
return "";
// If you want to display an error message, please use the following format
return "ServerError:Some text message";
}
But, I faced with a new problem. It always have error #1088 when I trying to view it in the viewer using the following link.
http://ssasoft.local.com/public/stimuls ... ey=Report1
But in my designer, it is working perfectly fine.
Please advice. Thanks.