MySQL lite password

[Bob Sneidar]

Now would be a good time for me to point out that I created a Login stack that is modular. You pass either an array of database connection settings, or else an sqlYoga database object name. It will take care of the rest. If a login table does not exist in your current database it will create one for you. Once it does you can log in as Administrator:123456 and this will allow you to create new logins. If you login as one of the newly created users it will close itself, set some properties in the calling stack for the username, the user type (standard or administrator) and readonly. It’s up to you to access and use these as you see fit. 

If you quit the login stack without successfully logging in, it will close the calling stack. To use it, simply add the stack as a substack of you project, then set the dialogData as described above, then go to the loginStack. I could stand to tweak it a little more, but it is functional the way it stands. 

Bob S


> On Feb 21, 2015, at 09:29 , Andrew Kluthe <andrew at ctech.me> wrote:
> 
> That's interesting, Pete. Good catch.
> 
> On Fri, Feb 20, 2015 at 5:02 PM, Peter Haworth <pete at lcsql.com> wrote:
> 
>> Hi Andrew,
>> Turns out SQLite added a user authentication extension in 10/2014 that
>> requires a password to access an SQLite database but it's not part of the
>> SQLite library provided with Livecode.  It has to be compiled into the
>> source and a compile time flag set to enable it
>> 
>> See http://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt
>> 
>> I recently added a QCC request to update the SQLite library which is now
>> about 8 months and several releases old, including the addition of this
>> feature.
>> 
>> On Fri Feb 20 2015 at 1:39:32 PM Andrew Kluthe <andrew at ctech.me> wrote:
>> 
>>> Unfortunately, for a SQLite file there isn't really any built in
>>> authentication/permissions features.
>>> 
>>> With using only live code your only real option is to encrypt the entire
>>> file either using built in encrypt/decrypt commands or shell out to
>>> something that can.
>>> 
>>> Kind regards,
>>> 
>>> Andrew
>>> On Feb 20, 2015 1:53 PM, "JB" <sundown at pacifier.com> wrote:
>>> 
>>>> What is the proper way to add a password to
>>>> a MySQL lite database?
>>>> 
>>>> John Balgenorth
>>>> 
>>>> _______________________________________________
>>>> use-livecode mailing list
>>>> use-livecode at lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe and manage your
>>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>> 
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
> 
> 
> 
> -- 
> Regards,
> 
> Andrew Kluthe
> andrew at ctech.me
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode