Jump to content
  • Announcements

    • spinynorman

      Mandriva Official Documentation

      Official documentation for extant versions of Mandriva can be found at doc.mandriva.com.   Documentation for the latest release may take some time to appear there. You can install all the manuals from the main repository if you have Mandriva installed - files are prefixed mandriva-doc.
    • paul

      Forum software upgrade   10/29/17

      So you may have noticed the forum software has upgraded !!!
      A few things that have changed. We no longer have community blogs (was never really used) We no longer have a portal page.
      We can discuss this, and decide whether it is needed (It costs money) See this thread: Here
Sign in to follow this  
xboxboy

Trouble Setting up LemonPOS

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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              

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×