Re: [LemonPOS-general] How to find the database over the network.

[Miguel C. G. <mi...@le...>]

Hi,

On Thu, Sep 23, 2010 at 2:25 PM, <daw...@pa...> wrote:

> Hello,
>
> I have LemonPOS successfully running on one computer, and want to add
> a second till, so I can do Squeeze-Administration jobs in my back
> office, while doing retail sales from the first computer.
>
> LemonPOS is installed on the second computer, with SQL-Client, but not
> SQL_Server.
> I am sure in the LemonPOS dialog the Server Name should not be
> "localhost", but what should it be? I do not have experience with
> connecting to a database over a network.
>

The IP Address (or hostname) of the computer with mysql server.

Of course mysql must be configured to accept connections from other
computers on the network, and the firewalls not rejecting connections on the
mysql port (3306 by default) in the server.
Also, you may add another or the same mysql user for each computer (
user@hostname ) in mysql, to be granted to use the lemon database. See the
database creation script almost at the end, where the lemonclient user is
granted ( lemonclient@localhost) to use the database.

This is the text you need to read (from the script).
And this to run in mysql-client (logged as mysql root user), just replace
the localhost by the appropiate hostname/ip:

# Note: if you change the password to the lemonclient user (which is a
must),
# also re-grant it again with the new password. see the grant clause below.
GRANT ALL ON lemondb.* TO 'lemonclient'@'localhost' IDENTIFIED BY
'thepassword';


> Thanks for your help!
>
> Sterling
>
>
>
>
> ------------------------------------------------------------------------------
> Nokia and AT&T present the 2010 Calling All Innovators-North America
> contest
> Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in
> marketing
> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
> http://p.sf.net/sfu/nokia-dev2dev
> _______________________________________________
> Lemonpos-general mailing list
> Lem...@li...
> https://lists.sourceforge.net/lists/listinfo/lemonpos-general
>



-- 
Miguel Chavez Gamboa


LemonPOS, an opensource point of sale.
Want to support the development?

Donations accepted via paypal:
https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=5650578