Jump to content

Trouble Setting up LemonPOS


xboxboy
 Share

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?

Link to comment
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.

Link to comment
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              

Link to comment
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.

Link to comment
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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...