[burritobill]

Sorry if this is a newb question. I have been using BPFTP for years now. We need SSL support. I am switching to g6. Just by coincidence all our account info is stored in a database. I would like to use them with g6 ftp. I have my connection string setup and it is working. I keep getting auth failed errors in the log files. I setup a quick db just to test this app. Info is as follows.

db name ftpdb
server local
odbc ftp_user

g6 odbc auth set to

name db
account prefix = blank
method database via odbc

connection string = data source=ftp_user;server=localhost;uid=ftpdb;pwd=abcd;database=ftpdb

query = select ftp_user from users where ftp_user=%s and ftp_pass=%s

I have run a trace on the sql server and see my query as this
select ftp_user from users where ftp_user='tuna' and ftp_pass='tunapass'

my return is tuna

I am not sure If I am not passing back enough info or not passing back the correct info since I get a login failed. I know my connection string is working and I am getting a valid query.

If anyone can point me to a doc (please not the http://www.g6ftpserver.com/manuals/en/) or if anyone can just simply explain what data needs to be in the database and how do you get it out so g6 can understand it.

Any help is appreciated.

Thanks
Bill

[Codspirit]

How are your accounts ?

Have you a "tuna" user ?

[burritobill]

yes user tuna password of tunapass is a valid row in my table

[Matthieu]

Is user tuna also created in the ftp server ? The server will use the account name returned to load the properties to apply for this account.

[burritobill]

ok so this is where I went wrong. The user has to exist in the ftp users list also? So what is the point of using authentication from the database?

[Matthieu]

Only the authentication is stored in the base, all other options need to come from the default source. This allows you to not have to have to synchronize all the passwords.

Note that you can simply indicate the same account for all the users in your base then use access rights based on the username (using tags in access rights $USR_ACCOUNT)

[burritobill]

thank you very much for all of your help. Its good to see a message board that is usefull.

Bill

[Codspirit]

Sorry I was meaning in the ftpd ...

Its good to see a message board that is usefull

Yes, this one is really active and I like it too