Palabre :: Flash Xml Multiuser Socket Server

You don't need frames to view this website. Flash communication server. Flash mx xml socket server.

Home

Main Menu

- - - - - - -

- - - - - - -

- - - - - - -

Sourceforge Project Page

Python

Links

Palabre on Facebook

Actionscript for Multiplayer games

DOWNLOAD

FORUM

FAQ

WHAT IS IT

Using Palabre ? Coming here for Support ? Please consider making an (even small) donation :)

Palabre Forum

home | help

Post a new message in "Default Forum"

Name:

Subject:

topic icon:

boardcode:

Colour: Size: Close all tags

Message:

[b]Thrapple wrote:[/b]
[quote]Hello all !

Today i try to use Palabre 0.6 with my mysql server.

I create a database whith this name : test
I create a "table" with this name : t_logins whith inside : 
[quote]login_nickname 	login_password 	id[/quote]

With a lot of joy i read that on palabre :

[quote]2008-09-09 14:14:25,854 : INFO     No log file has been specified
2008-09-09 14:14:25,854 : INFO     Palabre will only print log to console
2008-09-09 14:14:25,901 : INFO     Running on: 127.0.0.1
2008-09-09 14:14:25,901 : INFO     Port: 2468
2008-09-09 14:14:25,901 : INFO     Palabre is running on local Interface
2008-09-09 14:14:25,901 : INFO     No other computer will be able to access it
2008-09-09 14:14:25,901 : INFO     2 Module(s) to load
2008-09-09 14:14:25,931 : INFO     Module : helloworld Loaded
2008-09-09 14:14:25,931 : INFO     Module : simpleLogin Loaded
2008-09-09 14:14:25,931 : INFO     2 Module(s) loaded
2008-09-09 14:14:25,979 : INFO     Connection to BDD      OK[/quote]

so i think, it's very good ^_^

But when I try to connect to palabre with my flash client, 
Any acount can connected to the server -_-''

For information, this is my palabre.conf :

[quote]# palabre.conf
# Main config file for Palabre

[daemon]
# startdaemon - if 'false', don't start in daemon mode
# and send the log to the console as well as to the log file
# useful with loglevel = debug
# default: true

startdaemon = false

# pidfile - pid file path 
# default: /var/run/palabre.pid
# Not used under windows, only for UNIX services

pidfile = /var/run/palabre.pid

# ip - uncomment the following to bind Palabre to a specific ip
# ex: ip = 192.168.1.25
# default (commented or empty): all

ip = 127.0.0.1

# port - uncomment the following to bind Palabre to a specific port
# ex: port = 9876
# default (commented or empty): 2468

port = 2468

[logging]
# loglevel - one of: debug, info, warning, error, critical
# default: info

loglevel = info

# logfile - log file path
# default: /var/log/palabre.log
# logfile = ./palabre.log
# If empty Palabre will print every messages in the console

logfile =

[admin]
# password - uncomment the following to allow root connection
# (useful for some administrative tasks)
# make sure only Palabre admins have access to this file
# ex: password = MetsTaCarpe
# default (commented or empty): no root connection allowed

password =

[crossdomain]
# List domains allowed to connect to this server (separated by spaces)
# Load through : System.security.loadPolicyFile("xmlsocket://foo.com:414");
#

alloweddomains = domainthatdoesnotexist.bar otherinexistantdomain.foo

[database]
# If you want to check password to database 
# checkpassword = true

usedatabase = true
checkpassword = true

# Database informations for ADODB

# dbType : Possible Values : any from ADODB : mysql, postgres, sqlite, odbc, ...
# But you need the correct module + Adodb to go on ...

dbType = mysql
dbHost = 127.0.0.1
dbUser = root
dbPassword =
dbDatabase = test

# Request to use : 
# use [LOGIN] and [PASSWORD] for the replacements WITHOUT QUOTES AROUND 
# Adodb Will auto quote it
# XML connect node must be : <connect nickname="toto" password="str0ngp4ss" />
# Ex : dbRequest = SELECT * FROM t_logins WHERE login_nickname LIKE [LOGIN] AND login_password LIKE MD5([PASSWORD])

dBRequest = SELECT * FROM t_logins WHERE login_nickname LIKE [LOGIN] AND login_password LIKE MD5([PASSWORD])
# test
# dBRequest = SELECT * FROM t_logins WHERE login_nickname='marius'

[modules]

list = helloworld,simpleLogin[/quote]

Do you know why there is this problem ?[/quote]

CAPTCHA:

How much is 3 added to 10

Topic History of: Palabre 0.6 + Mysql
Max. showing the last posts - (Last post first)

Author Message

Thrapple

Hi Célio !

Thank you very much and sorry for my later answer.

I'm a big looser, I don't see this details -_-''

I put :

Code:



 dBRequest = SELECT * FROM t_logins WHERE login_nickname LIKE [LOGIN] AND login_password LIKE [PASSWORD]

And Now, all is good.

Thank you so much.

Thrapple,

celio

Hi

What is returned by the server after you sent :

Code:



 

_root.mysend("<connect nickname='"+_root.mnick.text+"' password='"+_root.mnick2.text+"' />");

In the ouput you pasted I see no trace of login

And are your passwords encoded as MD5 in the database ? In the config file you posted, you still use the MD5() function in the SQL query, but in the database export this isn't MD5
So if it's that either encode your passwords or remove the MD5() function in the SQL query

Thrapple Carlos say :

I have the same problem in the past (i think).

Before everything: are you trying to connect local or from your IP?

Look, in the .conf, in the IP, try to put the IP you have locally (i mean, 192.168.??.??) if you're a windows user: WINDOWS BUTTON + R, then you writte CMD, then you write IPCONFIG and where it says "direction" or something like that, you'll have the IP. Copy that IP and paste it in the .conf.

Then, go to your connection in flash and put that IP if you wan't to work local or your REAL ip ( andy21.com/ip ) if you want to connect from another computer.

Finally, you must to OPEN the PORT (2468) in your firewall, and, if you use WIRELESS with ROUTER, you have to enter your router and configure it so you say him that if someone is trying to enter the por 2468, it must go to your computer.

I don't know if this was what you were asking.

Hi Carlos,

Thanks for the answer !

I think my connection palabre/client is good.

Beceause when I put "usedatabase = false checkpassword = false" in my palabre.conf I can connect to my palabre server with my flash client.

Thrapple Now, nobody can connect to palabre :(

And I don't understand why...

Have you got an idea ?

Thrapple No it's not work.

I try without :

2008-09-09 16:46:27,779 : INFO No log file has been specified

2008-09-09 16:46:27,779 : INFO Palabre will only print log to console

2008-09-09 16:46:27,825 : INFO Running on: 127.0.0.1

2008-09-09 16:46:27,825 : INFO Port: 2468

2008-09-09 16:46:27,825 : INFO Palabre is running on local Interface

2008-09-09 16:46:27,825 : INFO No other computer will be able to access it

2008-09-09 16:46:27,825 : INFO 1 Module(s) to load

2008-09-09 16:46:27,857 : INFO Module : helloworld Loaded

2008-09-09 16:46:27,857 : INFO 1 Module(s) loaded

2008-09-09 16:46:27,888 : INFO Connection to BDD OK

2008-09-09 16:46:59,460 : INFO Connection initialized for 127.0.0.1

2008-09-09 16:47:12,997 : INFO Connection lost for (127.0.0.1)

2008-09-09 16:47:12,997 : INFO Disconnection asked by (127.0.0.1)

2008-09-09 16:47:12,997 : INFO Client left:

So in the client I've got it :

*8963* Incoming :

<error>You must login first</error>

*6182* Sending :

<join room='Canal Principal' />

Hello !

Please connect, join a room and enjoy !

For more informations :

- code in my flash client :

px.onConnect = function(succes)

{

if(succes) {

_root.mysend("<connect nickname='"+_root.mnick.text+"' password='"+_root.mnick2.text+"' />");

gotoAndStop(2);

}

else

gotoAndStop(4);

}

- my database in phpmyadmin:

test (1)

* t_logins

login_nickname login_password id

minus 111111 1

pomme pomme 2

-__-"

admin Hi

I think the problem is that you use the "simpleLogin" plugin that overides the default password check.

Try without it and it should work

Simpleboard Forum Component 1.1.0 Stable
Two Shoes Mambo Factory

SORRY, website is currently mostly broken due to software changes on the server.
Hope to fix it soon ...

In the meantime you may still download palabre or use the forum