Security Violation

[MarcPires]

I´m developing an app and i´m getting into some issues on sandBox Security violation. Details as follow.

I design my report and save it in a folder called relatorios in my server (ex. http://myserver/myapp/relatorios/rel_pessoas.mrt

When i run the app http://myserver/myapp i get the error below

Error #2044: ioError: não manipulado. text=Error #2048: Violação da área de segurança: http://rglinux/EsusRelatorios/Diego/Rel ... ssoas2.swf can´t load data from myserver:3306.

[Vladimir]

Hello,

Looking at the error description, you have denied access to the MySql database from a Flash application. Since the Flash application runs on the client side, you need to allow access to the database for remote users.

Thank you.

[guibi]

Hello,
I have the same problem as MarcPires
Error #2044: ioError non pris en charge : text=Error #2048: Violation de la sécurité Sandbox : http://myappserver/guibi/EcoDynSoft.swf ne peut pas charger de données à partir de myapperser:3306.

My database has already access for the remote users

my cross domain:






my code:
report.dictionary.databases.clear();
var database:StiMySqlDatabase = new StiMySqlDatabase("test","test","Server=myappserver;Port=3306;Database=test;Uid=test;Pwd=test;",false);
report.dictionary.databases.add(database);

Could you please help me.
Many thanks in advance.

Best regards

[Vladimir]

Hello,

The cross-domain file must be named as crossdomain.xml, and should be in the root directory of your domain - http://mywebsite.com/crossdomain.xml, also file must be in UTF-8 encoding. Please check if this is.


Also, please try the following cross-domain file code:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<cross-domain-policy>
	<allow-access-from domain="*" to-ports="843"/>
	<allow-access-from domain="*" to-ports="3306"/>
	<site-control permitted-cross-domain-policies="all"/>
</cross-domain-policy>

Thank you.

[guibi]

Thank you for your quick reply.

I've tried to do what you've done but it doesn't work.

Thanks.

[Vladimir]

Hello,

Please tell us does your application work with a local MySQL server?

Thank you.

[guibi]

my webserver = http://mywebserver
my flex application = http://mywebserver/guibi/test.swf
my reports = http://mywebserver/guibi/reports/test.mrt
my MySql Server = http://mywebserver:3306
my cross domain = http://mywebserver/crossdomain.xml

with PHP it works
$link = mysql_connect("localhost","test","test");
mysql_select_db("test",$link);

with Flex it doesn't work
var database:StiMySqlDatabase = new StiMySqlDatabase ("test","test","Server=mywebserver;Port=3306;Database=test;Uid=test;Pwd=test;",false);
or
var database:StiMySqlDatabase = new StiMySqlDatabase ("test","test","Server=localhost;Port=3306;Database=test;Uid=test;Pwd=test;",false);

Thanks.

[Vladimir]

Thanks for the detailed description of the problem, we recheck this on our web server and let you know about the results.

Thank you.

[guibi]

Hello,

Have you already checked the problem? I am very content with your product, and I would buy it, but I need urgently the solution for my web application.
And how about the developpement of your report with ArrayCollection?

Many thanks in advance

Best regards

[Vladimir]

Hello,

We tested the product on our MySQL server, everything works correctly. Please try checking your server using other MySQL managers (e.g., EMS SQL Manager, or any other). If MySQL manager cannot connect to remote MySQL database, then the problemis to set the access permissions. In this case, you need to allow remote access for MySQL server (not only on localhost, which uses PHP).

The attached archive contains the latest version of Reports.Fx for Flex with many improvements, including the Test function in create connection dialog. Also, the new version adds new methods for working with data.

Method registers XML data source in the report:

Code: Select all

report.regDataXml(name: String, dataNode: XMLNode, schemaNode: XMLNode = null): void

Method registers a created data source in the report:

Code: Select all

report.regDataSet(name: String, alias: String, dataSet: DataSet): void

Use the following code to create a data source:

Code: Select all

var table: DataTable = new DataTable("Customers");
var column: DataColumn = new DataColumn("CustomerName", StorageType.StringType);
table.columns.add(column);

table.addNewRow().sett("CustomerName", "John Smith");
table.addNewRow().sett("CustomerName", "Antonio Moreno");
table.addNewRow().sett("CustomerName", "Elizabeth Brown");

var dataSet: DataSet = new DataSet("DataSetName");
dataSet.tables.add(table);

var report: StiReport = new StiReport();
report.regDataSet("DataSetName", "DataSetName", dataSet);
report.dictionary.synchronize();
report.design();

Thank you.