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
