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
  [ubuntu] compact-wireless driver issue | tl-wn722n | atheros chipset - 9271 Bakker 2 317 04-06-2020 01:26 PM
Last Post: FrankJScott
  [ubuntu] Sonicwall Netextender Install Issue manastassian 1 917 04-06-2020 12:38 PM
Last Post: FrankJScott
  [ubuntu] Inconsistent Data Read & Memory Issue after Installation Big Bad John 2 442 04-06-2020 12:29 PM
Last Post: FrankJScott
  [xubuntu] SPSS 19 - SPSS_Statistics_19_lin_en.bin danastacrrzynnt 2 277 04-06-2020 12:21 PM
Last Post: FrankJScott
  How to setup to stream live from firewire camera rstefaniacoxa 0 3 04-03-2020 04:19 AM
Last Post: rstefaniacoxa
  [ubuntu] 530 5.7.0 Must issue a STARTTLS command first ISPC3 jsmelawson78 1 194 04-02-2020 05:44 PM
Last Post: FrankJScott
  [xubuntu] Journald Has CPU @100% 400k Lines of Tumblerd Errors tsergiohaynesz 3 47 04-02-2020 05:25 PM
Last Post: FrankJScott
  [ubuntu] Canon PIXMA xn895 scaner installation issue: cannot find -lcncpnet cadenadaltoni 3 640 04-02-2020 04:55 PM
Last Post: FrankJScott
  [ubuntu] Wireless setup for Gateway M-6750 evolution05 4 359 04-02-2020 04:54 PM
Last Post: FrankJScott
  [xubuntu] unable to install 11.10, "no root file system is defined" [64 bit] jamescraig 1 330 04-02-2020 04:52 PM
Last Post: FrankJScott

Forum Jump:



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



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