Mysql connection

allexiel · Post by **allexiel** » 01 Jun 2006, 20:37

*sorry for talking french*

Elgueu dit moi

Tu travaille en local je vois. Peux tu m'expliquer 2-3 choses?
192.168.0.15 => ordinateur dans ton lan qui contient la base de données? ou..?
Quelle "package" emploi tu pour le création de database en local?

Voili voilou

mangoon · Post by **mangoon** » 01 Jun 2006, 20:51

Hi,
had a similiar problem an one machine .. try to replace 127.0.0.1 in config.xml bei your hostname (the name in /etc/hostname)
Also add an mysql user entry with that name instead of localhost or %

This did help on my ubuntu/debian install. Its worth a try.

hil

Elgueu · Post by **Elgueu** » 01 Jun 2006, 22:28

allexiel > Euh nop désolé justement je travaille pas en local ^^ Je dois me débrouiller avec un serveur dédié Linux distant que je ne maitrise pas du tout, et c'est un peu pour ca que je galère. Je n'ai donc pas vraiment de réponse à tes questions

mangoon > I don't have any /etc/hostname file. But i already tried with every IP or name i have for the server, and still get the same error.. Thx anyway ^^

Virusescu · Post by **Virusescu** » 02 Jun 2006, 06:31

Is there any other way to store easily array on the server ? PHP ?

You can write/read files on the server with _server.writeFile() and _server.readFile();

Or, with the newely introduced LoadVars class on server side. But this one adds a little too much of overhead for something that should be achieved easly.

Elgueu · Post by **Elgueu** » 02 Jun 2006, 07:56

And it's not really easy to rebuild an array object from a textfile, is it ?

Virusescu · Post by **Virusescu** » 02 Jun 2006, 08:55

I've just posted an example on this thread here -> http://forums.smartfoxserver.com/viewto ... =2565#2565

Elgueu · Post by **Elgueu** » 02 Jun 2006, 10:26

Hm... Yes i could do like this, and converting the datas in array with Number(). The problem is that my arrays are multi-dimensionnal (about 2 or 3 levels), so i don't think the split() command will be sufficient >.>

Virusescu · Post by **Virusescu** » 02 Jun 2006, 11:22

I've discussed this with JarochoCity. Read through this thread as well - http://forums.smartfoxserver.com/viewtopic.php?t=554

Thing is that SFS does this when sending data. You can send complex objects as xml strings through the xmlSocket. It's how SFS works.
Maybe Lapo didn't had a chance to read the other thread, but he might be able to expose the serialization/deserialization methods from inside the server.

So, you can build your own serialization algorithm for your data structure or you could use the builtIn methods of SFS (if these are available to be called from the server AS framework).

Elgueu · Post by **Elgueu** » 02 Jun 2006, 14:32

Alright, i've found a classic serialize class for flash, and will do everything in text files... This way, my app won't be affected if a sql freez occurs :p

Post by **Lapo** » 02 Jun 2006, 19:10

The AS 1 version of the client side serializer/deserializer could be used in an extension, but we don't provide direct access to the java serializer because it's more complex than the client version

There are some open source solutions like the wddx class for Flash >> http://sephiroth.it/tutorials/flashPHP/wddx/index.php which could be used for this task.

Elgueu, which classes do you use?

Elgueu · Post by **Elgueu** » 02 Jun 2006, 21:31

Yeap, this one http://sephiroth.it/test/unserializer/index.php

I had a few problem of compatibility between this class and server code, and had to remove some "AS2 stuff" to make it work, but it's now ok.

BTW, is it possible to use a server based code without joining a room and all the user process, etc... ? I mean, i store my "map arrays" in text files as i've just explained, but i also have a mapeditor and would like it to use the _server.Write and Read functions, but i don't need any "user login", "rooms" or anything else. So what is the minimum code to connect and be able to use server extension with this kind of app ?