I'm not quite sure what it is you're doing, but it sounds like you're
talking directly to mysql over a socket connection. I'd be very
careful in doing so in that all of your mysql authentication info is
included in the swf file. The swf can be easily decompiled and your
database compromised.
I'd look into using server-side technology to handle the mysql
interaction.... CF/PHP/etc.
Aside from that, you're swf once uploaded is running in whatever
domain you uploaded it to. If you want to disregard the above, and
just get it working, make sure mysql and the swf are running on the
EXACT same domain.
John Robinson - Flash/Flex Developer at large
Blog: http://jrobinsonmedia.wordpress.com
On May 27, 2007, at 5:03 AM, li.wen wrote:
Hello all,
I am using flash.net.Socket class to connect mysql database. And I
always meet sandbox violation error. I have some questions
regarding this problem.
1) When I develop the flex application and mysql database
(localhost:3066 is used) in same machine, there is no sandbox
violation box error, since they are considered as in the same
domain. Am I correct?
2) After I upload the flex application the server which is equipped
with mysql, I access the flex application from client machine.
Firstly the flex application will be downloaded to the client
machine's cache, then start to execute. Now flex application and
mysql database are considered as in different domain, and the
sandbox violation may happen?
3) In order to solve it, I need to enable mysql remote access? Set
mysql server address to digital format (xxx.xxx.xxx.xxx) to instead
of "localhost"?
4) Or alternative way to solve it is to set "crossdomain.xml" file?
Thank you.
Regards,
Joe
