Re: [LemonPOS-general] initial database script

[Miguel C. G. <mig...@gm...>]

Hi,

On Fri, Apr 10, 2009 at 3:07 PM, Ivan Aleman <ale...@gm...> wrote:
> Hello,
>
> this is my first post to this list, first of all let me tell you that I see
> LemonPOS as a great app that is here to cover the gap of this kind of
> applications that been said I would like to start by reporting some issues:
>
> * The SQL script to create the db for the first time, tables, users and data
> doesn't fully work on MySQL v5.0.67 it stops on line 245 on the CREATE USER
> statement, commenting out this line will make the script to go fine and
> because the following line is a GRANT statement for the same user it's a bit
> redundant to have both statements IMHO, I've tried to make the CREATE USER

This depends on configuration.. There is a 'NO_AUTOCREATE_USER' for the GRANT.
So, why not create it before the grant...
There is also a note about mysql modes:
"As noted in the examples where appropriate, some of the statements
will fail if the server's SQL mode has been set to enable certain
restrictions. In particular, strict mode (STRICT_TRANS_TABLES,
STRICT_ALL_TABLES) and NO_AUTO_CREATE_USER will prevent the server
from accepting some of the statements."

See
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

> statement ot work but it seems that is not accepted with the following
> examples:
>

I have "mysql  Ver 14.12 Distrib 5.0.77, for pc-linux-gnu (i686) using
readline 5.2" and it works fine.

Are you sure it was the first time you run the script?
If you have ran the script twice or more, it will stop at creating the
user, because it exists.

I tested the following and worked fine, except the 5th. I think its
due to copy paste and characters...
---
...syntax to use near '�lemon...
---

> CREATE USER 'lemonclient'@'localhost' IDENTIFIED BY '1234567890';
> CREATE USER 'lemonclient'@'%' IDENTIFIED BY '1234567890'
> CREATE USER 'lemonclient' IDENTIFIED BY '1234567890';
> CREATE USER lemonclient IDENTIFIED BY '1234567890';
> CREATE USER ´lemonclient´@´localhost´ IDENTIFIED BY '1234567890';
> CREATE USER "lemonclient"@"localhost" IDENTIFIED BY '1234567890';
>
> None of the above work.
>
> Other than the above I haven't found any other bugs... but it's my first day
> ;)
>
> Keep up with the hard work and thanks.
>
> --
> Ivan Aleman
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> High Quality Requirements in a Collaborative Environment.
> Download a free trial of Rational Requirements Composer Now!
> http://p.sf.net/sfu/www-ibm-com
> _______________________________________________
> Lemonpos-general mailing list
> Lem...@li...
> https://lists.sourceforge.net/lists/listinfo/lemonpos-general
>
>



-- 
Miguel Chavez Gamboa

George Burns  - &quot;I spent a year in that town, one Sunday.&quot; -
http://www.brainyquote.com/quotes/authors/g/george_burns.html