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 : login_nickname login_password id
With a lot of joy i read that on palabre :
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
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 :
# 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"); #
[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'
Re:Palabre 0.6 + Mysql - 2008/09/09 14:56No 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 !
Re:Palabre 0.6 + Mysql - 2008/09/10 08:57Carlos 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.
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
Palabre on Facebook
DOWNLOAD
FORUM
FAQ
WHAT IS IT
