Quick Setup
You can also view the wiki articles, there are steps for installing on (k)ubuntu.
http://sourceforge.net/apps/mediawiki/lemonpos/
For compiling lemonpos, first make sure you have kde4 installed . Then you can start compiling :
cd trunk
mkdir build
cd build
cmake -DCMAKE_INSTALL_PREFIX=/opt/kde4 .. #here you put your path to kde4.
make
su
make install
When installing, you can see where it was installed, just in case you cant find a way to run lemon, write the location of the installation (the binary files are in /usr/bin or /usr/local/bin), also the menu entries are under something like “lost objects”.
copy the lemonrc file to your local .kde/share/config directory:
cp trunk/src/lemonrc /home/USER/.kde4/share/config/ #Replace USER with your username.
After compiling and installing lemonpos, you must proceed to the database creation before you can login and use lemonpos.
Things you will need:
- MySql Installed and ready to use.
- MySql’s root password
- The script to create the database, located in the database_resource folder from lemonpos code. If you are using lemon POS 0.6 version, the file is also installed on your /usr/share/apps/lemon/ or /usr/local/share/apps/lemon/ depending on your system and configuration. But if you use *ubuntu with lemon POS 0.5 version this file is missing for such version you can get it here
.
Note that the script must be from the same version you installed. Different version may have a different database structure.
This task is very simple. All you have to do is to run the script as shown below:
cd trunk/database_resources
cat lemon_mysql.sql | mysql -u root -p
MySql will prompt for the password, type the mysql’s root password. If you dont know this, try searching the default password for your linux distribution.
If no errors are reported, you can start using lemonpos.
Now you can run lemonpos and squeeze. from your applications menu or by command. Note that if you run “lemon” and it is not found, maybe you installed at another location, try /usr/local/bin/lemon or /usr/local/bin/squeeze
Lemon Pos Weblog 
Somethings I had to modify to get running on Ubuntu 8.04.1, with KDE4 installed:
* The basic instructions are:
cd trunk
mkdir build
cd build
cmake .. -DCMAKE_INSTALL_PREFIX=/opt/kde4 .. #here you put your path to kde4. /usr/lib/kde4
make
sudo su
make install
Now, copy the lemonrc file to your local .kde/share/config directory:
cp trunk/src/lemonrc /home/USER/.kde/share/config/ #Replace USER with your username.
* After installation, you need to create a database and user on mysql, to do this:
cd trunk/database_resources
cat lemon_mysql.sql | mysql -u root -p
sudo apt-get install libqt4-sql-mysql
* If you want to create some demo products, do:
mysqlimport -u root -p -v -L lemondb trunk/database_resources/*.txt
Note: if you got an error, try changing the group and user for the products file to mysql:mysql
* To start using lemon, type
/usr/lib/kde4/bin/lemon
Note the differences to your isntructions. Thanks! 😀
I used your modified instructions but I still have no idea what my username or password should be. and when I go to squeeze to try to create one it crashes when I select ‘browse users’
and I know user: admin password: linux is what it’s supposed to be, but no dice
“help”: To which password do you refere?
1.- lemonpos user/password is the one written in this document.
2.- mysql password depends on your distribution. If you dont know this, try searching on mysql documentation about changing root’s password for mysql.
Once you run the script successfully, you can use lemonpos, creating more users, changing passwords, etc…
Is there a way to do this in phpmyadmin?
Yes you can do it with phpmyadmin. Simply log in, go to import, select the sql file and click go. Do not make a database as the sql with do that for you.
I’ve got this working but I also need the username & password that you say:
“1.- lemonpos user/password is the one written in this document.”
Help!
Got it!
First, let me say that Lemon appears to be what I have been looking for. We are building an Eco-resort in Nicaragua, thus Spanish is what I need. All our computer systems (from general purpose to the way that controls our bio-filter sewage system will be running Linux–currently Kubuntu Hardy so the KDE interface fits.
That said, what I see as the downside is no real discussion about the project, the product, documentation, … For example, I really did not see where Squeeze was directly refered to as what it does–I just figured it out by reading everything I could find.
My personal suggestion would be to put up a wiki so it is easy for people to contribute the various bits of knowledge they gain. I also think it would encourage more participation.
Thanks for your comments Phil, Its my plan to write some guides for the software, I started with the Quick Setup, I will continue with a Quick Startup guide for start using the two tools (lemon and squeeze). I stop including sample database because of the changing stage.
Ive installed lemonpos via Kubuntu repo and I find no lemondb anywhere on my system.
I could really use a template file to start with.
Ive been talking to people about Linux and some business owners have been talking to me about POS systems. Id really like to show them a demo of lemonpos. Is there anyway to get a copy of a database that I can show with?
Thank you for all your hard work on this from I can see it looks great, and just what some of my friends are looking for.
Sherman:
I dont know how the kubuntu package is installed, and if it includes the database_resources folder in which the database-creation-script is located. On old version (0.4) this was not included (ubuntu package). Dont know if the newer is (0.5).
One thing i must say: You must use the script from the lemonpos version you installed.
About sample database, there is no one included yet for the 0.5 version (0.4 is very different).But its easy to create sample products using squeeze.
No SQL resources included in the Ubuntu packages. It sure looks good, but the packaging in the binaries is not complete, and the startup has no bootstrap process.
A suggestion – when Lemon starts up, if it gives a database error, ask if the person wants to create teh database, and feed the SQL script into the install. Sure the admin needs to create a database instance, but the table creation and setup should be seamless.
The package looks interesting, but I cannot run it. I’ll have to move on.
Well, as im not the kubuntu package mantainer i cannot help with that. Any way i can post the script here for you and all other people who needs it.
Wait for the file here or at the homepage (sourceforge).
Hi there!
I’m curious about trying lemon. I did the installation and everything worked fine. BUT when I start-up lemon I get the error message:
“Lemon could not connect to the database and will terminate. Check if the database is running (mysql)”
I am running Fedora 9. MYSQL is up and running. I can log-in as root and as lemon. So! I wonder what else I can check & try…
BTW, I agree with the wiki idea. Maybe documenting the whole thing is an enormous tasks but the experience of other end-users can help both yourself and newbies.
Thanks in advance,
— Luis.
Did you run the database creation script?
some error when running the script?
This problem may be because of:
1.- No Mysql running
2.- No database/user created (with script)
3.- Bad user/password for (lemonclient) mysql
4.- Bad configured acces for the lemonuser (mysql grant stuff)
5.- A firewall blocking acess to mysql.
The default created (by de script) user for mysql is “lemonclient”, and its granted to access from localhost. You can see the password in lemon_mysql.sql.
how do i edit the configuration file if i cannot get into lemonpos? i need to change where the mysql database is but the program closes when it cant connect, this is a bigggggg flaw! change it next version!
The config file is stored in two places, any kde app tries frist to load from your home, for example:
~/.kde4/share/config/lemonrc
if that is not found, it tries to load system-wide config at:
/usr/local/share/config/lemonrc or /usr/share/config/lemonrc depending on your system.
So, first, modify the one that is inside your home.
how can I make lemon use a mysql server on an other system
Use the configuration dialog to change the server address, user, and password.
Change for both, lemon and squeeze.
For lemon, run and login as admin. Then in the tool bar there is an configure icon, click it and go to ‘database’ section.
For squeeze, run it, and click on the configure button on the right-top side of the window and go to database section.
On 0.7 version, if lemon/squeeze cannot connect to database server, this dialog is shown.
lemon exits with an error about connecting to the mysql server on the local system before I can click on anything
what do I have to do to the configuration files to make it use my external server
Are you using 0.6 or older version? There is a post and an the answer for which file to modify.
But, version 0.7 fixes that inconvenient showing a database configuration dialog instead of terminating the application.
ok I got lemon woking, setup mysql on the host system tempararaly to get it to work so I could reconfigure it.
that done it looks like a nice program I only have to get it to be able to charge for time and traveling distance, things that you don’t have to have in stack, so far all I can get it to bill fore it objects I have not fore time unless I make an item to represent an hour or something and say I have a ridiculous amount onhand.
so is there a way to define labor rate in lemon and how, if not, consider it a suggestion for the next version.
I am planing to open a small home based computer shop, so I need to be able to bill for services that might have different prices based on criteria, like time or other services, can lemon be programed to do that, give a discount on i service when ordered with another.
Well, time is a “measure”, so you can insert a new measure called ‘labor hours’ and insert products such as “Technical Support” sold by “labor hours” with price per ‘hour’ of ‘10.3’. So at lemon you can enter product “Technical Support” and a quantity of 3.5 ‘hours’. With the new way of inserting products, considering this product having code 123456789 you could enter 3.5×123456789 at the code inputbox and 3.5 hours of Technical Support will be inserted.
This is the easiest way you can use lemonpos right now for this porpouse -dont need to wait for another version-.
Click here to see an example
Regarding discounts based on “grouped” products is not yet implemented. Well, I have a todo item for ‘grouped products’ but i have to plan it better at implementation level. My idea is having groups of products sold at lower price, but defined products per group, for example “1 coke + 1 hotdog” for 2 dollars, instead of “1 coke” for 1 dollar and “1 hotdog” for 2 dollars, which togheter are 3 dollars; but that group is exactly one hotdog and one coke, no more, no less.
In case you are using Ubuntu, there is the kde-devel package that will install the KDE4/Qt4 dependencies.
No puedo compilar la version SVN ni en Madriva Cooker ni en Debian.
El error que salta en ambas es el siguiente.
[ 25%] Building CXX object src/CMakeFiles/lemon.dir/lemonview.o
/root/kdenlive/lemonpos/src/lemonview.cpp:74: aviso: parámetro ‘parent’ sin uso
/root/kdenlive/lemonpos/src/lemonview.cpp:142: aviso: parámetro ‘parent’ sin uso
/root/kdenlive/lemonpos/src/lemonview.cpp:193: aviso: parámetro ‘parent’ sin uso
/root/kdenlive/lemonpos/src/lemonview.cpp: In member function ‘void lemonView::finishCurrentTransaction()’:
/root/kdenlive/lemonpos/src/lemonview.cpp:1282: error: no se encontró una función coincidente para la llamada a ‘Azahar::decrementProductStock(const long long unsigned int&, const double&, QDate)’
/root/kdenlive/lemonpos/src/../dataAccess/azahar.h:137: nota: los candidatos son: bool Azahar::decrementProductStock(const qulonglong&, const double&, const qulonglong&, const qulonglong&, const QDate&)
make[2]: *** [src/CMakeFiles/lemon.dir/lemonview.o] Error 1
make[1]: *** [src/CMakeFiles/lemon.dir/all] Error 2
Sinceramente no tengo ni idea de porqué sucede esto
Es normal, como escribi en un post anterior, por el momento la version mas actual del SVN no compilara, ya que hay muchos cambios en progreso. (https://lemonpos.wordpress.com/2009/04/05/release-073-and-starting-new-features/)
Puedes utilizar hasta la revision 285. En unos dias hare el release de una nueva version en sourceforge.
Muchas gracias por su atención y su rápida respuesta.
Excuse me, i write english very bad.
Firstly, thank you. This is a fine piece of work that takes GNU/Linux one step further.
I’m not sure if i have over looked this, but I was interested in not only donating money for further development of this project, but interested in helping in any way possible with documenting, small bug fixes for this project or anything I can do to help.
You can start by subscribing to the mailing list and view tickets and the roadmap at the lemonpos trac site:
https://lists.sourceforge.net/lists/listinfo/lemonpos-general
http://apps.sourceforge.net/trac/lemonpos/
This think is so complicated and hard to understand for new in Linux world people.
One ho to video tutorial would make life easier for everyone.
I have an interest in LemonPOS, because I saw LemonPOS in an article on TechRepublic. They mention some important factors about your software are low hardware requirements and printer support. I went to the sourceforge, wiki, and now here.
I want to help out. What language is this written in? Maybe I can help there.
I want to share some business insight, so that your project will blossom:
1. Among the links to the User Guide, and Screenshots, you NEED one that takes the potential users to a list of “known” working hardware – ESPECIALLY cash drawers and printers. Why? What if Jane Doe read the above article on a non-technical web site, and she owns a PC, and wants to make a hardware shopping list for her girlfriends’ husband who is going to BestBxy ( lets pretend he is a novice level geek ).
You can save them from the over excitement that leads to dispare when Jane figures out that she purchased receipt paper for a cash register – NOT a POS printer, and the POS Receipt Printer she got on FLEA-BAY uses odd size paper.
2. Most restaurant guys/gals need a “ready made” version of the binaries because they can’t afford a Linux consultant on top of other startup costs. Some of them are trying to deal with accounting/tax issues, etc. So they need a generic install that is ready to run (think Excel). EVEN if that means cutting out the mysql, and using flat files, or SQLite ( a truly great alternative since you can “script” it, AND it does nearly everything, while also being stable ).
Hi,
Well, i need more time to do such things.. im trying to make the homepage (writing content)…
Great application n cool UI 🙂 Btw i think generic setup like Greg say its important to new user on linux land. Maybe you can create *generic* installer with makeself[1] (this is a initial project on loki installer).
[1] http://megastep.org/makeself/
Awesome app, really everything that I have been looking for. I have one tiny thing that I’m struggling with. I live in South Africa and I am need of changing the currency symbol. I have been looking everywhere to change this but sadly no luck. How can I change it? I’ve got your latest version… 0.8. Can you please help? Thank you so much 🙂
The currency and other things like date, double-click-or-single-click-on-views.. are system wide settings. You must configure such things on KDE’s systemsettings tool ( launch systemsettings on your command line ) on the language and regional settings for the language, the currency, and the date format to use in all your kde applications.
The new version 0.9.1 adds many features and fixes bugs.
Hi,
I am a developer, though my background is C-based mainly. But, I have taken and used C++. That said, I am here to help…hopefully. 🙂
I have added several fields to the ‘clients’ table and have added them to the editclient_widget.ui. I then found most everywhere that referenced the data and added my fields in. azahar.* are most interesting.
Now I am getting a KDE crash with squeeze and am trying to debug.
BTW, these are the fields that we need in there added to what is already in lemonPoS:
email
account number
account type
comments
Any help in debugging the reasons for the crash would be great. I see that there are a number of unused variables, or so my compiler is saying. No errors on my additions, though, interestingly.
We also need ‘check’ and ‘gift certificate’ as methods of payment.
I am thinking it should be a drop-down box instead of radio buttons.
The last part that I am trying to accomplish is to change lemon/squeeze slightly to use our online store’s (oscommerce.org) products and categories.
Help? Thoughts?
Thanks!!!
Hi,
For help please subscribe and send your questions to the lemonpos mailing list. This is a better way to keep a record.
This comment will be better on the mailing list and better to respond on each part of the comment.
I will send it to the mailing list and a copy to you… please subscribe to the mailing list.
The link to the mailing list subscription is in the project homepage under doc section:
http://lemonpos.org/doc
The error looks to have been there prior to my edits, after rolling back. Here is what I get:
/home/cmanders/Downloads/lemonpos/squeeze/src/squeezeview.cpp: In member function ‘void squeezeView::productsViewOnSelected(const QModelIndex&)’:
/home/cmanders/Downloads/lemonpos/squeeze/src/squeezeview.cpp:1776: warning: unused variable ‘price’
/home/cmanders/Downloads/lemonpos/squeeze/src/squeezeview.cpp:1778: warning: unused variable ‘stockQty’
/home/cmanders/Downloads/lemonpos/squeeze/src/squeezeview.cpp:1780: warning: unused variable ‘cost’
/home/cmanders/Downloads/lemonpos/squeeze/src/squeezeview.cpp:1784: warning: unused variable ‘units’
/home/cmanders/Downloads/lemonpos/squeeze/src/squeezeview.cpp:1786: warning: unused variable ‘tax1’
/home/cmanders/Downloads/lemonpos/squeeze/src/squeezeview.cpp:1788: warning: unused variable ‘tax2’
/home/cmanders/Downloads/lemonpos/squeeze/src/squeezeview.cpp:1790: warning: unused variable ‘category’
/home/cmanders/Downloads/lemonpos/squeeze/src/squeezeview.cpp:1792: warning: unused variable ‘points’
/home/cmanders/Downloads/lemonpos/squeeze/src/squeezeview.cpp:1795: warning: unused variable ‘isAGroup’
/home/cmanders/Downloads/lemonpos/squeeze/src/squeezeview.cpp:1797: warning: unused variable ‘isARaw’
/home/cmanders/Downloads/lemonpos/squeeze/src/../../src/structs.h: In member function ‘void squeezeView::updateGraphs()’:
Well, these are not errors, are warnings… 🙂
Some unused variables are there because where used some time ago ( debugging or simple remove them… )
I will later remove the unused variables from the code…
Oh,
BTW, Lemon POS is great! and… Ubuntu has a GREAT installer. I had no problems with the setup and even if I were a WindBlows guy they made it simple.
I’d say focus on the app and others of us can make it easy to digest for the masses.
I also would like to say in response to the chap with Linux setup issues that this is where you trade off. Either you pay a good consultant to set you up right….or you buy some crap software from M$, etc. Better to pay the consultant. S/he needs it way more.
🙂
Somebody out there to help me with the default login credentials for LemonPOS Ver. 0.9.1. I did successfully install the application from Ubuntu 10.04LTS software center. I equally created a database “lemondb” on mysql server ver.5.1. The major problem is the login credentials to start using the system.
What is the debug output from lemon? (running at the terminal).
Running lemon in the same computer where mysql is installed?
is libqt4-sql-mysql installed? (this is required to connect to mysql).
The user is admin and password linux… if you cant login with these, then something is wrong on the database or libqt4-sql-mysql is missing.
This is the debug output from lemon running at the terminal
Loading Stylesheet…
trigger grid action done…
Setting up database…
ERROR: QSqlError(1146, “QMYSQL: Unable to execute query”, “Table ‘lemondb.categories’ doesn’t exist”)
Setting up clients…
ERROR: QSqlError(1146, “QMYSQL: Unable to execute query”, “Table ‘lemondb.clients’ doesn’t exist”)
ERROR: QSqlError(1146, “QMYSQL: Unable to execute query”, “Table ‘lemondb.clients’ doesn’t exist”)
Updating client info…
Login.. emiting disable startop action
disabling start op action, logged user: “”
Transactions Count: 0 Cash in drawer: 0
startAgain(): New Transaction
Setting up clients…
ERROR: QSqlError(1146, “QMYSQL: Unable to execute query”, “Table ‘lemondb.clients’ doesn’t exist”)
ERROR: QSqlError(1146, “QMYSQL: Unable to execute query”, “Table ‘lemondb.clients’ doesn’t exist”)
Updating client info…
**Error** : QSqlError(1146, “QMYSQL: Unable to execute query”, “Table ‘lemondb.users’ doesn’t exist”)
I can see that at least some tables does not exists on the database..
So, I think that you have not created the database or the creation went wrong.
Please read the wiki:
Database Creation
If you installed a recent version, the db-creation script can be located at
/usr/share/kde4/apps/lemon/I am using Ubuntu 10.04 and tried installing Lemonpos with Ubuntu software center. Squeeze and Lemon icons appear in Office. Squeeze appears, then goes grey. I have tried uninstalling and reinstalling several times. I have installed Mysql server. There is a folder called Persa. I have gone into it and opened a file data_resources\lemon_mysql.sql. I tried running a terminal with “cat lemon_mysql.sql | mysql -u root -p” and nothing happens. I am really looking forward to using Lemon and would like to contribute, but cannot get it running. Thank you. Best regards, Bob
Nothing happens?
what is nothing?
is mysql server running?
did you also install mysql client? (in order to run the creation script).
dont forget to install (at least on ubuntu) the libqt4-sql-mysql package. It is important for lemon/squeeze.
I do not program. So, I’m a little lost when it comes to installing linux programs. I was super excited when I was able to just click install for Gnucash. But after opening it, I realized I actually need something to help me track inventory. So, I was hoping I could just install lemonpos (which is perfect!). But I’m having 2 problems.
1. I can only open lemon from a terminal, by typing lemon in. Why isn’t it showing up in my Applications menu?
2. It keeps asking me for my administrator password, and it’s not accepting my computer’s admin password, or the username: admin password: linux that that installation instructions told me to use. I can see the program, it’s open on my desktop, it’s just not letting me access anything in it, because I don’t have the right password.
Please help. I already love lemonpos. I just don’t know how to open it. And I’d like it to love me back.
Did you created the database?
instructions on the wiki.
http://sourceforge.net/apps/mediawiki/lemonpos/index.php?title=Installation_Guide
Fistly I love this program and going to use it at 3 sites within the next 2 months
Will keep you posted on it .. As real live exaples .
My question is if a sale is done and someone pays with cash and card , how would you do it ..?
Thank you …
Hi,
Multiple payment method is not implemented.
Maybe in the next release, if it not becomes a hard task to implement.
Also, in the same way, i want to implement a multi-currency support (at conversion level).
Hi mchavezg, great work!
Can run LemonPos no prob
but can’t run
Squeeze
O/S OpenSUSE Gnome 11.3 – Live CD – Virtual Box
Hi,
What happens?
give some more details.
ross@linux-ils4:~> $ squeeze
terminal says
“squeeze: error while loading share libraries: libstreamanalyzer.so.0: cannot open share object file: No Such file or directory”.
Which linux distribution are you using?
Did you compiled lemonPOS?
the libstreamanalyzer can be part of strigi (kde component)
Please add tender types – need additional ones as well as cash and card – you can’t run a store nowadays without cheque, gift voucher, amazon, paypal, mastercard, visa – you name it!! Thanks in advance and what a promising piece of software. Only wish I had the knowledge to help develop it in a programming sense rather than add feedback as requests and critique!!
Hi mchavezg;
I can login successfully to lemon with user: admin and passwd:linux, but when I try to start an operation it requiems the credentials again (Authentication required) and I inserted admin/linux again but nothing happened i.e) Authentication required still (no any msg appeared like error or wrong user/passwd), and that happened for Squeeze too, I can not login to Squeeze for the same issue.
I use Ubuntu 10.10, GNOME. also I installed lemon from Ubuntu Software Center, and run the SQL script from the source code as mentioned. libqt4-sql-mysql is installed too.
Thanks in Advance.
Im not on 10.10 now, i will try later. But i have installed (and made a video) from the source code (compiled) the latest version and it works.
Try running lemon from a console (terminal) to see the output which contains debug information.