xboxboy Posted November 26, 2010 Report Share Posted November 26, 2010 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? Quote Link to comment Share on other sites More sharing options...
ianw1974 Posted November 26, 2010 Report Share Posted November 26, 2010 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. Quote Link to comment Share on other sites More sharing options...
xboxboy Posted November 26, 2010 Author Report Share Posted November 26, 2010 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 Quote Link to comment Share on other sites More sharing options...
ianw1974 Posted November 26, 2010 Report Share Posted November 26, 2010 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. Quote Link to comment Share on other sites More sharing options...
xboxboy Posted November 28, 2010 Author Report Share Posted November 28, 2010 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? Quote Link to comment Share on other sites More sharing options...
ianw1974 Posted November 28, 2010 Report Share Posted November 28, 2010 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.