Hi Do you get anything in the server log when this happens?
/niklas On Fri, Mar 13, 2009 at 8:10 AM, Steve Winter <[email protected]> wrote: > Hi all, > > Well, I'm getting closer...! > > It would seem that the configuration settings in my config xml file are now > all correct, and that I can (presumably) establish a connection to my > database, given that if I vary any of the parameters in my config file from > those which are correct I get a huge stacktrace of error messages... > > However... I can't actually connect. When I try to connect using a username > which exists in the database I get; > > Status: Connecting to 127.0.0.1:2121... > Status: Connection established, waiting for welcome message... > Response: 220 Service ready for new user. > Command: USER steve > Error: Connection closed by server > Error: Could not connect to server > Status: Waiting to retry... > > If I try using a 'bogus' username I get; > > Status: Connecting to 127.0.0.1:2121... > Status: Connection established, waiting for welcome message... > Response: 220 Service ready for new user. > Command: USER fred > Response: 331 User name okay, need password for fred. > Command: PASS *** > Response: 530 Authentication failed. > Error: Could not connect to server > > Now I used the sql dump from the site to create my table structure, so I > know that should match the config... my user steve has the following in the > database; > > userid steve > userpassword testTest > homedirectory /Users/stevewinter/ > enableflag 1 > writepermission 1 > idletime 0 > uploadrate 0 > downloadrate 0 > maxloginnumber 100 > maxloginperip 100 > > Within my config I've got <db-user-manager encrypt-passwords="clear"> which > I believe matches what is (currently) in the database... > > Sorry to be bothering you all again... > > Thanks for any guidance... > > Cheers > Steve > > > On 12 Mar 2009, at 08:00, Steve Winter wrote: > >> Hi Ashush, >> >> Your clue about the MySQL jdbc driver was enough to get me the next step >> of the way...! I downloaded mysql-connector-java-5.1.7-bin.jar and added >> that to the /lib folder as well, and the server now starts...!! just need to >> figure out the password hashing now, and I think I might have cracked it... >> >> I'm going to write up some additional instructions for this which I'll >> forward to the project developers with the suggestion that they add them to >> the stand-alone config instructions for using the server with MySQL (when I >> get it working ;-) >> >> Cheers >> Steve >> > > > > >
