[flexcoders] LCDS + MD5 + PostGreSQL and JRun4

2009-10-13 Thread Flex Boy
Hi FlexCoders, This is probably not your thing to help me with, but just maybe 
someone have it in top of their head and can point me in the right direction on 
this.

Issue:

JRun 4 update 7 standalone server.
PostgreSQL 8.4 default install, with md5 crypt on password.
LCDS 2.6.1 with custom SQL assembler.

The problem, I'm using the JrunLoginCommand connected to the native PostgreSQL 
user role and role group.
This password is crypt with md5  , when I attempt to connect with LCSD 
Channels::Login over RTMP it don't work using plain text.
Then I figured out that I have to send the password in md5 format, did copy and 
paste the md5 string from PostgreSQL and pasted it into the password field in 
Flex app and it connected. I have looked at some MD5 encoders for AS3 but maybe 
I have to tweak it to be compatible with PostgreSQL  anyone have a Idea?

Here is the hash form password in PostgreSQL : secretpassword = 
md5b6b7afff2e118778d175c88f52098a3f

http://gsolofp.blogspot.com/2006/01/actionscript-3-md5-and-sha1.html
http://code.google.com/p/as3corelib/





Re: [flexcoders] LCDS + MD5 + PostGreSQL and JRun4

2009-10-15 Thread Daniel Nelson
Holy Crap, someone other than myself is using JRun and LCDS.  Awesome!  I
can't help you with your problem as I have never used PostgreSQL, but could
I get your contact info as I have never ran across anyone using JRun outside
of ColdFusion development.

Feel free to contact me at nelso...@gmail.com anytime.

-Dan

On Tue, Oct 13, 2009 at 9:33 AM, Flex Boy  wrote:

>
>
> Hi FlexCoders, This is probably not your thing to help me with, but just
> maybe someone have it in top of their head and can point me in the right
> direction on this.
>
> Issue:
>
> JRun 4 update 7 standalone server.
> PostgreSQL 8.4 default install, with md5 crypt on password.
> LCDS 2.6.1 with custom SQL assembler.
>
> The problem, I'm using the JrunLoginCommand connected to the native
> PostgreSQL user role and role group.
> This password is crypt with md5 , when I attempt to connect with LCSD
> Channels::Login over RTMP it don't work using plain text.
> Then I figured out that I have to send the password in md5 format, did copy
> and paste the md5 string from PostgreSQL and pasted it into the password
> field in Flex app and it connected. I have looked at some MD5 encoders for
> AS3 but maybe I have to tweak it to be compatible with PostgreSQL anyone
> have a Idea?
>
> Here is the hash form password in PostgreSQL : secretpassword =
> md5b6b7afff2e118778d175c88f52098a3f
>
> http://gsolofp.blogspot.com/2006/01/actionscript-3-md5-and-sha1.html
> http://code.google.com/p/as3corelib/
>
> 
>