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 -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
