Bug#607229: Cannot reproduce your problem

[Francesco P. Lovergine]

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.

-- 
Francesco P. Lovergine