Mysql in Mac OSX

Stimulsoft Reports.PHP discussion
Chan Kuan Leang
Posts: 74
Joined: Sun May 20, 2007 9:14 pm
Location: Singapore

Mysql in Mac OSX

Post 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
Smile
Chan Kuan Leang
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Mysql in Mac OSX

Post 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.
Chan Kuan Leang
Posts: 74
Joined: Sun May 20, 2007 9:14 pm
Location: Singapore

Re: Mysql in Mac OSX

Post 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.
Image

Image
Smile
Chan Kuan Leang
Vladimir
Posts: 1462
Joined: Fri Apr 13, 2007 4:05 am
Location: Earth

Re: Mysql in Mac OSX

Post 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.
Chan Kuan Leang
Posts: 74
Joined: Sun May 20, 2007 9:14 pm
Location: Singapore

Re: Mysql in Mac OSX

Post 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.
Attachments
log.txt
Log file
(10.5 KiB) Downloaded 356 times
Smile
Chan Kuan Leang
Vladimir
Posts: 1462
Joined: Fri Apr 13, 2007 4:05 am
Location: Earth

Re: Mysql in Mac OSX

Post 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.
Chan Kuan Leang
Posts: 74
Joined: Sun May 20, 2007 9:14 pm
Location: Singapore

Re: Mysql in Mac OSX

Post by Chan Kuan Leang »

Thank you so much!!

I will read the faq. Thanks.
Smile
Chan Kuan Leang
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Mysql in Mac OSX

Post by HighAley »

Hello.

Let us know if you need any additional help.

Thank you.
Chan Kuan Leang
Posts: 74
Joined: Sun May 20, 2007 9:14 pm
Location: Singapore

Re: Mysql in Mac OSX

Post 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.
Image

Please advice where do I need to save the report?
Is it in stimulsoft/reports of my server? or just inside stimulsoft?

Thanks.
Smile
Chan Kuan Leang
Chan Kuan Leang
Posts: 74
Joined: Sun May 20, 2007 9:14 pm
Location: Singapore

Re: Mysql in Mac OSX

Post 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.
Smile
Chan Kuan Leang
Post Reply