Hi Niklas,
Thanks, another good pointer... I'd not gone looking for a log file...
it seems that the example sql queries and what's expected are slightly
out of sync with each other...
I modified;
<select-user>SELECT userid, userpassword, homedirectory, enableflag,
writepermission, idletime, uploadrate, downloadrate FROM FTP_USER
WHERE userid = '{userid}'</select-user>
to
<select-user>SELECT userid, userpassword, homedirectory, enableflag,
writepermission, idletime, uploadrate, downloadrate, maxloginnumber,
maxloginperip FROM FTP_USER WHERE userid = '{userid}'</select-user>
and things are now working... :-) Thanks to all for their assistance
to this point...
Niklas, I'll prepare some additional 'notes for novices' to include on
the database user-manager doc page in the next day or so...
Cheers
Steve
On 13 Mar 2009, at 08:24, Niklas Gustavsson wrote:
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
Steve Winter
[email protected]
m: +44 77 7852 4776
3 Calshot Court, Channel Way
Ocean Village, Southampton SO14 3GR
