How To Connect Multiple Unicenta POS Systems

[Anthony Porter]

For those wondering how to create multi user systems this is how. Apparently they've changed a few things or I forgot or whatever but I just did it (Again) and while it's fresh on my mind, this is how to connect multiple stations...

BTW: SET UP YOUR ROUTER TO PORT FORWARD TO THE DATABASE SERVER'S IP!

Linux Users: sudo gedit /etc/mysql/my.cnf | Windows Users: I don't know search for my.cnf

1. Comment the line that states "Bind address = 127.0.0.1" Ex: #bindaddress = 127.0.0.1

2. My cnf didnt have it but if you see a line that states "skip-networking" make sure you DONT have that enabaled to do that.

3. Restart mysql server: /etc/init.d/mysql restart

4. Go to your phpmyadmin and from the main screen select "SQL". DO NOT SELECT A DATABASE

Type: FLUSH HOSTS;

Repeat step 4 but dont type flush hosts again.. proceed to read... There are two ways to achieve setting multiple connections and it's no biggy either way. Im going to show you the (Across the board) way and explain how to individually set connections...

1. Proceeding from step 4, type or copy and paste the following into your sql box and edit; Using "unicentaopos" as a database example

GRANT ALL ON unicentaopos.* TO 'aUserName'@'%' IDENTIFIED BY 'password'
FLUSH PRIVILIGES

Now from your other system and for the love of your data, please PLEASE do not use root as a username and eithier no password. Lets use "unicentauser/1236987. From your other systems that will be the remote system, go to your configuration and from the connections go to the username and type...

replace "localhost" with the server database's ipaddress.

EX: jdbc:mysql://123.456.7.89:3306/unicentaopos

User: unicentauser(Literally put in the username you planned to use from the grant code

password: 1236987

Save and it should say in big ol bold words "YOU'RE CONNECTED". nOW THIS WORKS ACROSS THE BOARD and all you have to do is add the coorasponding ip address to the connection grant code and in the unicenta

From here you have just unlocked a ton of possibilities to run your business using pads, phones, laptops. This will even allow wireless connections and nothing special. To be explicit about ip addresses do the following...

---

GRANT ALL ON unicentaopos.* TO 'aUserName'@'192.168.xxx.xx1' IDENTIFIED BY 'password'
FLUSH PRIVILIGES

GRANT ALL ON unicentaopos.* TO 'aUserName'@'192.168.xxx.xx2' IDENTIFIED BY 'password'
FLUSH PRIVILIGES

GRANT ALL ON unicentaopos.* TO 'aUserName'@'192.168.xxx.xx3' IDENTIFIED BY 'password'
FLUSH PRIVILIGES

GRANT ALL ON unicentaopos.* TO 'aUserName'@'192.168.xxx.xx4' IDENTIFIED BY 'password'
FLUSH PRIVILIGES

---

FLUSH HOSTS;

Then restart mysql. If mysql does not want to come back up, no worries, restart your system(I know it's not windowws but this helps everything mesh together and work properly. You now have a multiple system store

ETC...... Now ONLY those ip addresses with xx1-4 can connect to the database. The '%' allows address and that's good if you are not physically connected to the internet and/or not owning a good router with firewall. If you do use it and have internet connected it's not a federal requirement to explicitly use each ip but good practice. Now this step worked for me so don't go messing with the mysql.sock because that will just shut you down all together and wreak havoc on the other 19 systems in your store.

There you go guys!

[Anthony Porter]

Correcion: FLUSH PRIVILEGES

Sorry about that

[Anthony Porter]

Update, you do not have to set up your router to port forward for local connections as I simply plugged in a breand new router, got my ip my lappy is and I grabbed my tablet and was using the OSR Backoffice within minutes