Trouble Setting up LemonPOS

[xboxboy]

Hi all, I'm in the process of looking around at various programs for running a business on. I had come across LemonPOS before, and I see it's in the repos so I thought it would be great to give it a try.

 

Installing LemonPOS through MCC went well, then I found I needed to install Mysql aswell, which I have, and have since change the root password as advised.

 

The trouble is I seem to be having trouble building the database for LemonPOS.

 

Various instruction sets to me to:

 

For the first time, you have to create a database. Database is used to store all things related to 
the operation of the POS, like sales and products.

* To create database, run script included inside lemonpos/database_resources/ 
or on recent releases this file is located at /usr/share/kde4/apps/lemon/ 

  cd lemonpos/database_resources/
  cat lemon_mysql.sql | mysql -u root -p

 

Unfortunately I cannot find this database_resources or anything along the lines of lemon_mysql.sql

 

Can anyone help or am I doing something stupid?

[ianw1974]

As root, on your system from console you can try:

 

find / -name lemon_mysql.sql

 

and see if it comes back with anything. Alternatively, do:

 

rpm -ql lemonpos

 

assuming that package is called lemonpos, and it will list all files that were installed as part of that rpm. Then you might be able to find the script.

 

Also, just check you have all the required packages installed, eg:

 

urpmf --name lemonpos

 

in case more than one package is available for providing other files such as mysql scripts. For example, on Ubuntu I have packages lemonpos and lemonpos-data. That's not to say it will be the same in Mandriva. But just an idea.

[xboxboy]

Thanks Ian,

not quite sure what these results mean.

 

The first command returned a whole host of "permission denied" results.

 

$ rpm -ql lemonpos                      
/usr/bin/lemon                                               
/usr/bin/squeeze                                             
/usr/share/applications/kde4/lemon.desktop                   
/usr/share/applications/kde4/squeeze.desktop                 
/usr/share/apps/lemon                                        
/usr/share/apps/lemon/images                                 
/usr/share/apps/lemon/images/imgPrint.png                    
/usr/share/apps/lemon/images/itemBox.png                     
/usr/share/apps/lemon/images/logo_bottom.png                 
/usr/share/apps/lemon/images/splash_screen.png               
/usr/share/apps/lemon/lemonui.rc                             
/usr/share/apps/lemon/styles                                 
/usr/share/apps/lemon/styles/elegant                         
/usr/share/apps/lemon/styles/elegant/backg.png               
/usr/share/apps/lemon/styles/elegant/button.png              
/usr/share/apps/lemon/styles/elegant/button_hover.png        
/usr/share/apps/lemon/styles/elegant/checkbox_off.png        
/usr/share/apps/lemon/styles/elegant/checkbox_on.png         
/usr/share/apps/lemon/styles/elegant/checks_bg.png           
/usr/share/apps/lemon/styles/elegant/dialog.png              
/usr/share/apps/lemon/styles/elegant/editbox.png             
/usr/share/apps/lemon/styles/elegant/elegant.qss             
/usr/share/apps/lemon/styles/elegant/groupbox.png            
/usr/share/apps/lemon/styles/elegant/headers.png             
/usr/share/apps/lemon/styles/elegant/headerview.png          
/usr/share/apps/lemon/styles/elegant/headerview_hover.png    
/usr/share/apps/lemon/styles/elegant/hgroupbox.png           
/usr/share/apps/lemon/styles/elegant/loginBackground.png     
/usr/share/apps/lemon/styles/elegant/loginBackground_1280x800.png
/usr/share/apps/lemon/styles/elegant/passwordBackground.png      
/usr/share/apps/lemon/styles/elegant/passwordBackground_wide.png 
/usr/share/apps/lemon/styles/elegant/radiobutton_off.png         
/usr/share/apps/lemon/styles/elegant/radiobutton_on.png          
/usr/share/apps/lemon/styles/elegant/tira.png                    
/usr/share/apps/lemon/styles/simple                              
/usr/share/apps/lemon/styles/simple/backg.png                    
/usr/share/apps/lemon/styles/simple/dialog.png                   
/usr/share/apps/lemon/styles/simple/loginBackground.png          
/usr/share/apps/lemon/styles/simple/loginBackground_1280x800.png 
/usr/share/apps/lemon/styles/simple/passwordBackground.png       
/usr/share/apps/lemon/styles/simple/passwordBackground_wide.png  
/usr/share/apps/lemon/styles/simple/priceCheckerBack.png         
/usr/share/apps/lemon/styles/simple/pricechecker.png             
/usr/share/apps/lemon/styles/simple/simple.qss                   
/usr/share/apps/squeeze                                          
/usr/share/apps/squeeze/images                                   
/usr/share/apps/squeeze/images/itemBox.png                       
/usr/share/apps/squeeze/images/logo.png                          
/usr/share/apps/squeeze/squeezeui.rc                             
/usr/share/apps/squeeze/styles                                   
/usr/share/apps/squeeze/styles/simple                            
/usr/share/apps/squeeze/styles/simple/backg.png                  
/usr/share/apps/squeeze/styles/simple/passwordBackground_wide.png
/usr/share/apps/squeeze/styles/simple/simple.qss                 
/usr/share/config.kcfg/lemon.kcfg                                
/usr/share/config.kcfg/squeeze.kcfg                              
/usr/share/config/lemonrc                                        
/usr/share/doc/lemonpos                                          
/usr/share/doc/lemonpos/INSTALL                                  
/usr/share/doc/lemonpos/NOTES                                    
/usr/share/doc/lemonpos/README                                   
/usr/share/doc/lemonpos/USING                                    
/usr/share/icons/hicolor/128x128/apps/lemon-user.png             
/usr/share/icons/hicolor/16x16/actions/lemon-balance.png         
/usr/share/icons/hicolor/16x16/actions/lemon-box.png             
/usr/share/icons/hicolor/16x16/actions/lemon-boxcancel.png       
/usr/share/icons/hicolor/16x16/actions/lemon-cashin.png          
/usr/share/icons/hicolor/16x16/actions/lemon-cashout.png         
/usr/share/icons/hicolor/16x16/actions/lemon-categories.png      
/usr/share/icons/hicolor/16x16/actions/lemon-money.png           
/usr/share/icons/hicolor/16x16/actions/lemon-offers.png          
/usr/share/icons/hicolor/16x16/actions/lemon-payfocus.png        
/usr/share/icons/hicolor/16x16/actions/lemon-price-checker.png   
/usr/share/icons/hicolor/16x16/actions/lemon-print-ticket.png    
/usr/share/icons/hicolor/16x16/actions/lemon-printer.png         
/usr/share/icons/hicolor/16x16/actions/lemon-reports.png         
/usr/share/icons/hicolor/16x16/actions/lemon-ruler.png           
/usr/share/icons/hicolor/16x16/actions/lemon-switchuser.png      
/usr/share/icons/hicolor/16x16/actions/lemon-tag.png             
/usr/share/icons/hicolor/16x16/actions/lemon-ticket-cancel.png   
/usr/share/icons/hicolor/16x16/actions/lemon-transaction-accept.png
/usr/share/icons/hicolor/16x16/actions/lemon-transaction-cancel.png
/usr/share/icons/hicolor/16x16/apps/lemon.png                      
/usr/share/icons/hicolor/16x16/apps/squeeze.png                    
/usr/share/icons/hicolor/22x22/actions/lemon-balance.png           
/usr/share/icons/hicolor/22x22/actions/lemon-box.png               
/usr/share/icons/hicolor/22x22/actions/lemon-boxcancel.png         
/usr/share/icons/hicolor/22x22/actions/lemon-cashin.png            
/usr/share/icons/hicolor/22x22/actions/lemon-cashout.png           
/usr/share/icons/hicolor/22x22/actions/lemon-categories.png        
/usr/share/icons/hicolor/22x22/actions/lemon-money.png             
/usr/share/icons/hicolor/22x22/actions/lemon-offers.png            
/usr/share/icons/hicolor/22x22/actions/lemon-payfocus.png          
/usr/share/icons/hicolor/22x22/actions/lemon-price-checker.png     
/usr/share/icons/hicolor/22x22/actions/lemon-print-ticket.png      
/usr/share/icons/hicolor/22x22/actions/lemon-printer.png           
/usr/share/icons/hicolor/22x22/actions/lemon-reports.png           
/usr/share/icons/hicolor/22x22/actions/lemon-ruler.png             
/usr/share/icons/hicolor/22x22/actions/lemon-switchuser.png        
/usr/share/icons/hicolor/22x22/actions/lemon-tag.png               
/usr/share/icons/hicolor/22x22/actions/lemon-ticket-cancel.png     
/usr/share/icons/hicolor/22x22/actions/lemon-transaction-accept.png
/usr/share/icons/hicolor/22x22/actions/lemon-transaction-cancel.png
/usr/share/icons/hicolor/22x22/apps/lemon.png                      
/usr/share/icons/hicolor/22x22/apps/squeeze.png                    
/usr/share/icons/hicolor/32x32/actions/lemon-balance.png           
/usr/share/icons/hicolor/32x32/actions/lemon-box.png               
/usr/share/icons/hicolor/32x32/actions/lemon-boxcancel.png         
/usr/share/icons/hicolor/32x32/actions/lemon-cashin.png            
/usr/share/icons/hicolor/32x32/actions/lemon-cashout.png           
/usr/share/icons/hicolor/32x32/actions/lemon-categories.png        
/usr/share/icons/hicolor/32x32/actions/lemon-money.png             
/usr/share/icons/hicolor/32x32/actions/lemon-offers.png            
/usr/share/icons/hicolor/32x32/actions/lemon-payfocus.png          
/usr/share/icons/hicolor/32x32/actions/lemon-price-checker.png     
/usr/share/icons/hicolor/32x32/actions/lemon-print-ticket.png      
/usr/share/icons/hicolor/32x32/actions/lemon-printer.png           
/usr/share/icons/hicolor/32x32/actions/lemon-reports.png           
/usr/share/icons/hicolor/32x32/actions/lemon-ruler.png             
/usr/share/icons/hicolor/32x32/actions/lemon-switchuser.png        
/usr/share/icons/hicolor/32x32/actions/lemon-tag.png               
/usr/share/icons/hicolor/32x32/actions/lemon-ticket-cancel.png     
/usr/share/icons/hicolor/32x32/actions/lemon-transaction-accept.png
/usr/share/icons/hicolor/32x32/actions/lemon-transaction-cancel.png
/usr/share/icons/hicolor/32x32/apps/lemon.png                      
/usr/share/icons/hicolor/32x32/apps/squeeze.png                    
/usr/share/icons/hicolor/48x48/actions/lemon-balance.png           
/usr/share/icons/hicolor/48x48/actions/lemon-box.png               
/usr/share/icons/hicolor/48x48/actions/lemon-boxcancel.png         
/usr/share/icons/hicolor/48x48/actions/lemon-cashin.png            
/usr/share/icons/hicolor/48x48/actions/lemon-cashout.png           
/usr/share/icons/hicolor/48x48/actions/lemon-categories.png        
/usr/share/icons/hicolor/48x48/actions/lemon-money.png             
/usr/share/icons/hicolor/48x48/actions/lemon-offers.png            
/usr/share/icons/hicolor/48x48/actions/lemon-payfocus.png          
/usr/share/icons/hicolor/48x48/actions/lemon-price-checker.png     
/usr/share/icons/hicolor/48x48/actions/lemon-print-ticket.png      
/usr/share/icons/hicolor/48x48/actions/lemon-printer.png           
/usr/share/icons/hicolor/48x48/actions/lemon-reports.png           
/usr/share/icons/hicolor/48x48/actions/lemon-ruler.png             
/usr/share/icons/hicolor/48x48/actions/lemon-switchuser.png        
/usr/share/icons/hicolor/48x48/actions/lemon-tag.png               
/usr/share/icons/hicolor/48x48/actions/lemon-ticket-cancel.png     
/usr/share/icons/hicolor/48x48/actions/lemon-transaction-accept.png
/usr/share/icons/hicolor/48x48/actions/lemon-transaction-cancel.png
/usr/share/icons/hicolor/48x48/apps/lemon.png                      
/usr/share/icons/hicolor/48x48/apps/squeeze.png                    
/usr/share/icons/hicolor/64x64/actions/lemon-balance.png           
/usr/share/icons/hicolor/64x64/actions/lemon-cashin.png            
/usr/share/icons/hicolor/64x64/actions/lemon-cashout.png           
/usr/share/icons/hicolor/64x64/actions/lemon-print-ticket.png      
/usr/share/icons/hicolor/64x64/actions/lemon-printer.png           
/usr/share/icons/hicolor/64x64/actions/lemon-reports.png           
/usr/share/icons/hicolor/64x64/actions/lemon-ruler.png             
/usr/share/icons/hicolor/64x64/actions/lemon-switchuser.png        
/usr/share/icons/hicolor/64x64/apps/lemon.png                      
/usr/share/icons/hicolor/64x64/apps/squeeze.png                    
/usr/share/locale/ca/LC_MESSAGES/lemon.mo                          
/usr/share/locale/ca/LC_MESSAGES/squeeze.mo                        
/usr/share/locale/de/LC_MESSAGES/lemon.mo                          
/usr/share/locale/de/LC_MESSAGES/squeeze.mo                        
/usr/share/locale/es/LC_MESSAGES/lemon.mo                          
/usr/share/locale/es/LC_MESSAGES/squeeze.mo                        
/usr/share/locale/fr/LC_MESSAGES/lemon.mo                          
/usr/share/locale/fr/LC_MESSAGES/squeeze.mo                        
/usr/share/locale/pt_BR/LC_MESSAGES/squeeze.mo                     
/usr/share/locale/zh/LC_MESSAGES/lemon.mo                          
/usr/share/locale/zh/LC_MESSAGES/squeeze.mo

 

$ urpmf --name lemonpos                       
lemonpos              

[ianw1974]

Did you run the find as a normal user first time around? That will be why you got the permission denied errors :)

 

Normally I run a find as root so that I've got access to all directories/files. But as it happens, that script isn't supplied by the lemonpos package anyway as it would be listed above.

[xboxboy]

Ok, so when I open Squeese (the administration gui for lemonpos) it tries to connect to a database called "lemondb". Perhaps I need to build this as a database. Does this sound right?

[ianw1974]

Without the mysql db script to import into the database, it will be almost impossible. You'll need to obtain this from somewhere. Then, what you can do is in mysql:

 

mysql -u root -p
create database lemondb

 

then once it's ready, all you need to do is import the script when you find it, so:

 

mysql -u root -p lemondb < mysql_lemonpos.sql

 

or whatever the name of the script is. That will create all the tables in the database.