Page 1 of 1

MySQL Problem

Posted: 02 Aug 2011, 20:05
by kadath
HI
first of all, sorry for my English.
i need help with a problem in the connection sfs and mysql
I am currently working in a project using the multiuser aplications for flash, for the project i need a user login that's how i get to the web

http://www.gotoandplay.it/_articles/mul ... ce56a5e8aa

following the steps i cauld make a local connection with the php posted on the web but i cant make a connection with MySQL.

before that I changes to the server as stated in the official website of sfs

http://www.smartfoxserver.com/docs/ (6.3 Connecting to databases)

I leave here some screenshots showing the changes I made to make the connection with mysql

here is the php file i use to validate the user and pass
also i use XAMPP to emulate the web server

Image

here are the changes i make to the config.xml
Image

Here is the BD made in MySQL
Image

Here are the .jar files for the connect sfs and mysql
Image

And the server ready screen
Image

i really need help with that
i tried to configure it about a couple of months but i cant.

if you need more information just ask for that i dont know wath to do to solution the problem.

Thanks in advance for your help
greetings.

Posted: 02 Aug 2011, 20:32
by rjgtav
hi. Could you please paste here the error it gives when trying to connect? And does the test sql work?

Posted: 03 Aug 2011, 18:44
by kadath
is not a special error just dont validate correctly the user and pass

if i use the php in the example (local validation) it works correctly
but if i use the mysql is imposible to validate the user

The error is show in the flash "custom login" examples of sfs
its unable to validate the user and pass

Image

Posted: 04 Aug 2011, 03:52
by kaloy12
kadath wrote:is not a special error just dont validate correctly the user and pass

if i use the php in the example (local validation) it works correctly
but if i use the mysql is imposible to validate the user

The error is show in the flash "custom login" examples of sfs
its unable to validate the user and pass

Image
that error should have many possible causes,
1. does your php server working properly?
2. do your link to call your check log in is correct?

Posted: 04 Aug 2011, 08:22
by rjgtav
hi. If my memory isn.t failing, that error is thrown when the client couldn.t connect to the SFS server. So please make sure first that it is connecting. If you.re behind a router, please refer to lapo.s sticky post called Behind a router help.

Posted: 07 Aug 2011, 00:15
by kadath
rjgtav wrote:hi. If my memory isn.t failing, that error is thrown when the client couldn.t connect to the SFS server. So please make sure first that it is connecting. If you.re behind a router, please refer to lapo.s sticky post called Behind a router help.
i saw the post you saying.
but it is in the case of a web server out of mi pc

i do what said in the post but now i have another problem
i upload the flash proyect (.SWF) into a .html file but i´m unable to see the flash in the
web. simply the flash aplication isn´t show in the browser.

Posted: 07 Aug 2011, 20:57
by rjgtav
Hi. Well that part about the flash not showing, it may have many causes...

For example, does the html file work on your pc? If yes, did you upload the .js file that is generated alongside with the html file (in case you're exporting to html using Flash)?

Posted: 08 Aug 2011, 18:42
by kadath
i do the html file with dreamweaver
and i uploaded all the files created by dreamweaver

here is a screen of the web server

Image

Image

Posted: 08 Aug 2011, 20:20
by rjgtav
Sorry but i cant help much, as i said, this could have multiple causes. Try first by checking if it works on your pc, then check in your website if the swf is really being lloaded on the html file (right click on the place where the swf should be and check if the Flash Player's right click menu appears). Check in multiple browsers to see if its just a browser's issue... etc.

Posted: 09 Aug 2011, 21:15
by kadath
ok i will search for that problem
when i find the solution i will post it here

thanks for the help
you served me a lot

greetings