Hi, 1) When i use sqlite3_user_add it first checks whether sqlite_user table exists. 2) It tries to create sqlite_user table 3) It throws an error that sqlite_user is reserved for interal use.
Regards, Siddharth On Tue, Mar 15, 2016 at 3:51 AM, syl leo <syleo2002 at yahoo.fr> wrote: > Hi, > I'm not a expert but i played few days ago with that.What i have seen is > : 1?)- I open a database with sqlite3_open(..)- create a table and add > record -> no problem- close the base > 2?)- I open the same database with sqlite3_open(..)- Add a user > with sqlite3_user_add( user, password.)- Close the database > 3?)- I open the same database with sqlite3_open(..) > - try to add a record on the table -> failed- > use sqlite3_user_authenticate(.user, password.) - Add a record on the table > -> OK > and if i try to use a common tool to open the database from now, it failed > (from the moment I create a user) > Hope it help :o) > Regards. > Sylvain. > > > De : siddharth kotian <siddse7en at gmail.com> > ? : SQLite mailing list <sqlite-users at mailinglists.sqlite.org> > Envoy? le : Lundi 14 mars 2016 20h32 > Objet : Re: [sqlite] SQLITE_USER_AUTHENTICATION > > Hi, > > I had modified that for my convenience. I had changed it in the code also. > I was under the impression to make it compatible for both 64 and 32 bit the > underscore is required. I have tried it with and without the underscore. > Both times it compiled successfully and all the operations worked fine > except for the authentication. > > Regards, > Siddharth > > On Tue, Mar 15, 2016 at 12:19 AM, Robert Weiss <weissrm0 at yahoo.com> wrote: > > > Tthe documentation says to use the flag as > > -DSQLITE_USER_AUTHENTICATION > > > > whereas in your message you said you used > > -D_SQLITE_USER_AUTHENTICATION > > > > So unless cl ignores a leading underscore (seems unlikely), you're > > defining something the code doesn't care about. > > > > > > On Monday, March 14, 2016 10:26 AM, siddharth kotian < > > siddse7en at gmail.com> wrote: > > > > > > Thanks, It works now. > > > > > > On Mon, Mar 14, 2016 at 10:06 PM, syl leo <syleo2002 at yahoo.fr> wrote: > > > > > Hi, > > > In your c++ program, if you use directly sqlite.c and .h and not the > > > dll+lib, you should remove the sqlite3.lib in your link.(project > > properties > > > -> linker -> input) > > > No ? > > > Regards. > > > Sylvain. > > > > > > De : siddharth kotian <siddse7en at gmail.com> > > > ? : sqlite-users at mailinglists.sqlite.org > > > Envoy? le : Lundi 14 mars 2016 13h39 > > > Objet : [sqlite] SQLITE_USER_AUTHENTICATION > > > > > > Hi, > > > > > > I have downloaded the SQLITE amalgamation folder along with the entire > > > source code. > > > > > > Followed the steps mentioned here > > > http://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt > > > > > > Using the following command to build the sqlite3.exe:- > > > > > > cl -D_SQLITE_USER_AUTHENTICATION shell.c sqlite3.c userauth.c > > > -Fesqlite3.exe > > > > > > But i can still open the database with sqlite3_open_v2. No > authentication > > > is required. > > > > > > Another problem is that I am trying to add a user to the sqlite_user > > table. > > > I have appended userauth.c to the sqlite3.c amalgamation and have > > provided > > > sqlite3userauth.h to the C++ program. > > > I am able to access sqlite_user_add method but it gives error lnk1181: > > > cannot find sqlite3.lib > > > > > > I am using VS2012, x64, Release Mode. > > > > > > Regards, > > > Siddharth > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users at mailinglists.sqlite.org > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > > > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users at mailinglists.sqlite.org > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
