Forums Search Login Register
Login
Username
Password
New Posts Todays Posts Find Users Posts Unanswered Threads Help Mark Forums as Read

Thread Options  Subscribe to this thread Subscribed Users  Add Reply 
Posts: 1,155
Trophies:
1
I wanted to try and get LemonPOS set up.

I'm following instructions from this post which reads as follows:

Quote:



October 20th, 2011 #6
Motovista
First Cup of Ubuntu

Here is how I did it in Kubuntu:

Terminal command- sudo apt-get install mysql-client mysql-server

download Lemon POS from Software Repository

Terminal command- cd /usr/share/kde4/apps/lemon/

Terminal command- cat lemon_mysql.sql | mysql -u root -p

Reboot and open Squeeze. There will be a username and password on the screen that logs into the database. Leave that alone. I think this is where most people (I did) have issues with the program, because they think they are supposed to put their mysql password or the default lemonpos username and password there.

Where you are asked for a user name and password, use admin and linux.



I installed LemonPOS and Squeeze from the 18.04 repos.
I understand that the software is old and unmaintained, as the wiki links for it are gone and the domain for sale.

Anyway.

My underlying problem is with mySQL.
I don't remember being prompted for a password at install.

I have run the following to change my root mySQL password:

Code:
sudo mysql_secure_installation
I've run CD to get to /usr/share/kde4/apps/lemon

When I run:

Code:
cat lemon_mysql.sql | mysql -u root -pls
I get the return of:

Code:
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
When running the same as sudo:

Code:
sudo cat lemon_mysql.sql | mysql -u root -pls
I get the return:

Code:
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
Then, a Sudo password prompt, and a return of new line.

Running LemonPOS at this stage gives me a warning that it could not connect to database, and the logout function fails. So, I have to kill it with CTRL+ALT+ESCAPE.

I know what my mySQL root password is. But, I'm never prompted for it.

I know I'm missing something. I just don't know what.

Any clues?
09-25-2018, 10:57 PM
Reply
Subscribe to this thread Subscribed Users  Add Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  Issue with rotate display on rpi4 with ubuntu server 19.10 Wilma 0 9 02-14-2020 09:01 AM
Last Post: Wilma
  [xubuntu] Fresh Xubuntu install, no sound, cant play videos. justinbray9 0 12 01-15-2020 05:31 AM
Last Post: justinbray9
  [xubuntu] Brother ADS-2400N scanner on Xubuntu 18.04 - can only scan as superuser blesleystanleyz 0 25 01-09-2020 11:07 AM
Last Post: blesleystanleyz
  Google drive upload issue keiraleach 0 5 12-30-2019 04:28 PM
Last Post: keiraleach
  [xubuntu] source packages joaltun85 0 14 12-14-2019 09:05 PM
Last Post: joaltun85
  [xubuntu] Full Screen dgalinaalvaradoj 0 10 11-21-2019 10:27 AM
Last Post: dgalinaalvaradoj
  [xubuntu] how set font size in thunderbird evolution05 0 10 11-17-2019 07:08 PM
Last Post: evolution05
  [xubuntu] DPMS appears not to work on Raspberry Pi 4B (Xubuntu, 19.10) lonniedivers 0 21 11-15-2019 08:17 AM
Last Post: lonniedivers
  mysql Ver 14.14 Distrib 5.7.27 stops suddenly on ubuntu 18.04.3 LTS KevynB1947 0 25 11-12-2019 08:31 AM
Last Post: KevynB1947
  Lenovo S130-11IGM / touchpad kernel issue ? eevkllriffithl 0 9 10-16-2019 05:07 PM
Last Post: eevkllriffithl

Forum Jump:



User(s) browsing this thread: 1 Guest(s)



Contact Us Privacy Policy Top RSS
Forum Software By: MyBB, © 2002-2020