LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-02-2015, 09:46 PM   #1
Gomera
LQ Newbie
 
Registered: Dec 2014
Posts: 5

Rep: Reputation: Disabled
Help with lemonpos for SlackWare 14.1


I'm a newby Slackware(14.1) user, I downloaded and installed the SlackBuild for lemonpos, also installed mysql database Ok, but when I star squeeze or lemon it asking me the administrator or supervisor username and password,I try admin-linux and didn't work, also get those error's:

setup Logs.. done, QSqlError(-1, "Unable to find table logs", "")
Login()

Error** : QSqlError(1046, "QMYSQL: Unable to execute query", "No database selected"

No database selected QMYSQL: Unable to execute query"
**Error** : QSqlError(1046, "QMYSQL: Unable to execute query", "No database selected")
squeeze(2233) KPlotWidget::Private::calcDataRectLimits: y1 and y2 cannot be equal. Setting y2 = y1 + 1.0


Any helps, I'll apreciate. the domain lemonpos is not available.

Homepage: http://lemonpos.org/.
 
Old 03-03-2015, 05:59 AM   #2
dijetlo
Senior Member
 
Registered: Jan 2009
Location: RHELtopia....
Distribution: Solaris 11.2/Slackware/RHEL/
Posts: 1,491
Blog Entries: 2

Rep: Reputation: Disabled
Quote:
installed mysql database...asking me [for] the administrator or supervisor username and password,
MySQL has an administrative account named "mysql" that is required for database administration/access/setup.
Did you create that little guy and give him a password? Did you try that password? Looking at your error, it seems like your database has never been initialized

Just a thought

Last edited by dijetlo; 03-03-2015 at 06:00 AM. Reason: Clarity
 
Old 03-03-2015, 06:38 AM   #3
allend
Senior Member
 
Registered: Oct 2003
Location: Melbourne
Distribution: Slackware-current
Posts: 4,574

Rep: Reputation: 1490Reputation: 1490Reputation: 1490Reputation: 1490Reputation: 1490Reputation: 1490Reputation: 1490Reputation: 1490Reputation: 1490Reputation: 1490
There are relevant comments in /etc/rc.d/rc.mysqld on initial install of MariaDB
 
Old 03-08-2015, 12:02 AM   #4
Gomera
LQ Newbie
 
Registered: Dec 2014
Posts: 5

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by allend View Post
There are relevant comments in /etc/rc.d/rc.mysqld on initial install of MariaDB
The problem is with Squeeze, I can access lemonpos, but i need to access squeeze for create product, user, etc. Here is 'lemondb' created in MariaDB;

MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| lemondb |
| mysql |
| performance_schema |


Hi, I'm a slackware user and I having problem to start Squeeze("No database selected QMYSQL: Unable to execute query" .) see log: , I Drop the database in mysql and instaled againg with the script lemon_mysql.sql. When I start lemon I can access with user: admin y password: linux. I read many blog and say the squeeze user and passowrd are admin, linux as lemon is. any help, I'll aprettiate.

===STARTING SQUEEZE AT "Sun Mar 8 01:30:14 2015" ===
Object::connect: No such slot squeezeView::doCheckOut()
Object::connect: (sender name: 'checkOut')
Object::connect: (receiver name: 'squeezeview_base')
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "login" "Login" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "usersBrowse" "Users" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "clientsBrowse" "Clients" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "productsBrowse" "Products" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "measuresBrowse" "Measures" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "categoriesBrowse" "Categories" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "offersBrowse" "Offers" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "balancesBrowse" "Balances" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "cashFlowBrowse" "Cash Flow" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "transactionsBrowse" "Transactions" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "quickViewPlots" "Quick Plots" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "doPurchase" "Purchase" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "checkOut" "Check Out" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "stockCorrection" "Stock Correction" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "reports" "Reports" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "printEndOfDay" "Print End of day report" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "printEndOfDayGral" "Print General end of day report" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "printEndOfMonth" "Print End of month report" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "printLowStock" "Print Low stock products" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "printSoldOut" "Print Sold out products" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "showSpecialOrders" "Show Special Orders" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "randomMsgsBrowse" "Ticket Messages" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "viewLog" "View Events Log" set with QShortcut::setShortcut()! See KAction documentation.
squeeze(5937)/kdeui (kdelibs): Shortcut for KAction "currenciesBrowse" "View Currencies" set with QShortcut::setShortcut()! See KAction documentation.
Disabling Actions..
Loading Stylesheet...
Style file: "/usr/share/apps/squeeze/styles/simple/simple.qss"
X Error: BadAtom (invalid Atom parameter) 5
Major opcode: 19 (X_DeleteProperty)
Resource id: 0x0
QWidget::setMinimumSize: (/MibitFloatPanel) The largest allowed size is (16777215,16777215)
QWidget::setMaximumSize: (/MibitFloatPanel) The largest allowed size is (16777215,16777215)
QWidget::setMinimumSize: (/MibitFloatPanel) The largest allowed size is (16777215,16777215)
QWidget::setMaximumSize: (/MibitFloatPanel) The largest allowed size is (16777215,16777215)
Enabling Actions..
Enabling others..
Enabling Actions..
Enabling others..
setupProducts..
ERROR: QSqlError(1046, "QMYSQL: Unable to execute query", "No database selected")
setupProducts.. done.
Enabling Actions..
Enabling others..
setupTransactions..
setupTransactions.. done, QSqlError(-1, "Unable to find table transactions", "")
Enabling Actions..
Enabling others..
setupBalances.. after openDB
setupBalances.. done.
Enabling Actions..
Enabling others..
setupcashflow.. after openDB
setupCashFlow.. done, QSqlError(-1, "Unable to find table cashflow", "")
Enabling Actions..
Enabling others..
setup special orders.. after openDB
setup special orders.. done.
Enabling Actions..
Enabling others..
setup random msgs model.. after openDB
Enabling Actions..
Enabling others..
setup logs msgs model.. after openDB
setup Logs.. done, QSqlError(-1, "Unable to find table logs", "")
Login()
Disabling Actions..
squeeze(5937) KPlotWidget::Private::calcDataRectLimits: y1 and y2 cannot be equal. Setting y2 = y1 + 1.0
squeeze(5937) KPlotWidget::Private::calcDataRectLimits: y1 and y2 cannot be equal. Setting y2 = y1 + 1.0
"No database selected QMYSQL: Unable to execute query"
**Error** : QSqlError(1046, "QMYSQL: Unable to execute query", "No database selected")
**Error** : QSqlError(1046, "QMYSQL: Unable to execute query", "No database selected")
**Error** : QSqlError(1046, "QMYSQL: Unable to execute query", "No database selected")
**Error** : QSqlError(1046, "QMYSQL: Unable to execute query", "No database selected")
**Error** : QSqlError(1046, "QMYSQL: Unable to execute query", "No database selected")
**Error** : QSqlError(1046, "QMYSQL: Unable to execute query", "No database selected")
**Error** : QSqlError(1046, "QMYSQL: Unable to execute query", "No database selected")
**Error** : QSqlError(1046, "QMYSQL: Unable to execute query", "No database selected")
squeeze(5937) KPlotWidget::Private::calcDataRectLimits: y1 and y2 cannot be equal. Setting y2 = y1 + 1.0
squeeze(5937) KPlotWidget::Private::calcDataRectLimits: y1 and y2 cannot be equal. Setting y2 = y1 + 1.0
"No database selected QMYSQL: Unable to execute query"
squeeze(5937) KPlotWidget::Private::calcDataRectLimits: y1 and y2 cannot be equal. Setting y2 = y1 + 1.0
squeeze(5937) KPlotWidget::Private::calcDataRectLimits: y1 and y2 cannot be equal. Setting y2 = y1 + 1.0
"No database selected QMYSQL: Unable to execute query"
squeeze(5937) KPlotWidget::Private::calcDataRectLimits: y1 and y2 cannot be equal. Setting y2 = y1 + 1.0
squeeze(5937) KPlotWidget::Private::calcDataRectLimits: y1 and y2 cannot be equal. Setting y2 = y1 + 1.0
"No database selected QMYSQL: Unable to execute query"
squeeze(5937) KPlotWidget::Private::calcDataRectLimits: y1 and y2 cannot be equal. Setting y2 = y1 + 1.0
squeeze(5937) KPlotWidget::Private::calcDataRectLimits: y1 and y2 cannot be equal. Setting y2 = y1 + 1.0
"No database selected QMYSQL: Unable to execute query"
 
Old 03-08-2015, 10:55 AM   #5
yancek
LQ Guru
 
Registered: Apr 2008
Distribution: PCLinux, Slackware
Posts: 7,281

Rep: Reputation: 1381Reputation: 1381Reputation: 1381Reputation: 1381Reputation: 1381Reputation: 1381Reputation: 1381Reputation: 1381Reputation: 1381Reputation: 1381
Did you create a mysql root user during the installation as explained at the mysql site below?

http://dev.mysql.com/doc/refman/5.0/...rivileges.html

You posted the errors you are getting but not the command you used which gave you those errors. The primary problem is that you are not selecting the database. If you open a terminal in Slackware and enter this command it should get you to the lemondb database if you have creaated the mysql root user with password. You should then be prompted for the mysql root password and when you enter it you should be at the mysql prompt:

Code:
mysql -h localhost -u root -p lemondb
You can use the commands below to show what users you have and also the grant privileges for users.

Quote:
mysql> select user from mysql.user;
mysql> SHOW GRANTS FOR 'root'@'localhost';
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
About Slackware 9.1 boot disk?? ftp://ftp.kpn.be/pub/linux/slackware/slackware-9.1-is AL3OMDAH Slackware 4 04-18-2007 09:54 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 11:50 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration