Bug#607229: Cannot reproduce your problem

[Francesco P. Lovergine]

tag 607229 - confirmed
thanks

On Tue, Mar 08, 2011 at 06:16:36PM +0100, Francesco P. Lovergine wrote:
> On Mon, Mar 07, 2011 at 07:33:09PM +0100, Vladimir Gulas wrote:
> > Hello Francesco,
> > 
> > Problem is still if user table have different name as 'users'
> > 
> > # Custom query  - table name 'ftp.ftpuser'
> > SQLNamedQuery   userinfo SELECT "userid, passwd, uid, gid, homedir, shell FROM ftpuser WHERE userid='%U' AND deleted=0 AND enabled=1 AND server='name_of_server'"
> > SQLUserInfo     custom:/userinfo
> > 
> > # mod_sql/4.2.4: unrecoverable backend error: (1146) Table 'ftp.users' doesn't exist
> > ???? - ftp.users ????
> > 
> > If created table 'ftp.users' with only schema without data all work fine.
> > 
> > Than you for your answer.
> > 
> 
> I never used those directives in the past. It seems you have to
> specify all queries strictly required for users and groups
> when using a custom userinfo query. So you need to provide
> at least the second query too.
> 

Just an explicit case that works:
#
# Describes both users/groups tables
#
SQLGroupInfo ftpgroups groupname gid members
SQLNamedQuery   userinfo SELECT "userid, passwd, uid, gid, homedir, shell FROM ftpusers WHERE userid='%U'"
SQLNamedQuery   uidinfo SELECT "userid, passwd, uid, gid, homedir, shell FROM ftpusers WHERE uid=%{0}"
SQLUserInfo     custom:/userinfo/uidinfo

I would close this bug as a configuration issue, not a bug.

-- 
Francesco P. Lovergine