Results 1 to 10 of 10

Thread: Nothing can connect to mySQL

  1. #1
    Join Date
    Mar 2007
    Location
    Georgia USA
    Beans
    223
    Distro
    Xubuntu

    Nothing can connect to mySQL

    I wanted to try and get LemonPOS set up.

    I'm following instructions from this post which reads as follows:
    October 20th, 2011 #6
    Motovista
    First Cup of Ubuntu

    Here is how I did it in Kubuntu:

    Terminal command- sudo apt-get install mysql-client mysql-server

    download Lemon POS from Software Repository

    Terminal command- cd /usr/share/kde4/apps/lemon/

    Terminal command- cat lemon_mysql.sql | mysql -u root -p

    Reboot and open Squeeze. There will be a username and password on the screen that logs into the database. Leave that alone. I think this is where most people (I did) have issues with the program, because they think they are supposed to put their mysql password or the default lemonpos username and password there.

    Where you are asked for a user name and password, use admin and linux.
    I installed LemonPOS and Squeeze from the 18.04 repos.
    I understand that the software is old and unmaintained, as the wiki links for it are gone and the domain for sale.

    Anyway.

    My underlying problem is with mySQL.
    I don't remember being prompted for a password at install.

    I have run the following to change my root mySQL password:
    Code:
    sudo mysql_secure_installation
    I've run CD to get to /usr/share/kde4/apps/lemon

    When I run:
    Code:
    cat lemon_mysql.sql | mysql -u root -pls
    I get the return of:
    Code:
    mysql: [Warning] Using a password on the command line interface can be insecure.
    ERROR 1698 (28000): Access denied for user 'root'@'localhost'
    When running the same as sudo:
    Code:
    sudo cat lemon_mysql.sql | mysql -u root -pls
    I get the return:
    Code:
    mysql: [Warning] Using a password on the command line interface can be insecure.
    ERROR 1698 (28000): Access denied for user 'root'@'localhost'
    Then, a Sudo password prompt, and a return of new line.

    Running LemonPOS at this stage gives me a warning that it could not connect to database, and the logout function fails. So, I have to kill it with CTRL+ALT+ESCAPE.

    I know what my mySQL root password is. But, I'm never prompted for it.

    I know I'm missing something. I just don't know what.

    Any clues?
    And, isn't sanity really just a one-trick pony anyway? I mean, all you get is one trick: "rational thinking."
    But, when you're good and crazy? Oooh! Oooh! Oooh! The sky is the limit!

  2. #2
    Join Date
    Mar 2007
    Location
    Georgia USA
    Beans
    223
    Distro
    Xubuntu

    Re: 18.04 LemonPOS setup and mySQL issue.

    Bump?

    So, I've also tried unicenta POS 4.4.2.
    There are multiple problems with the setup.

    I'm following the guide posted here:
    https://chubbable.com/unicenta-3-9-u...l-unicenta-pos

    The initial install goes fine.
    CD -ing to /opt/unicentaopos-4.4.2 and making the SH files boot-able works.

    Running
    sudo sh start.sh returns:
    : not found0: start.sh:
    : not found3: start.sh:
    : not found6: start.sh:
    start.sh: 28: start.sh: Syntax error: word unexpected (expecting "in")
    Running sudo sh configure.sh returns:
    : not foundh: 20: configure.sh:
    : not foundh: 24: configure.sh:
    Error: Could not find or load main class com.openbravo.pos.config.JFrmConfig
    However, running java -jar unicentaopos.jar launches the program.
    It returns this in terminal:
    Code:
    Sep 27, 2018 7:48:13 PM com.openbravo.pos.forms.StartPOS$1 run
    WARNING: Look and Feel is set
    Thu Sep 27 19:48:15 EDT 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    Thu Sep 27 19:48:15 EDT 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    The program's GUI issues this:
    Code:
    Database manager message
    DNG_00_0000
    Danger: Unable to connect to database: Database not available.
    So, my underlying issue looks to be mySQL?
    I added a unicentaopos database to mySQL. But, not matter what settings I give, I can't connect to it.
    And, isn't sanity really just a one-trick pony anyway? I mean, all you get is one trick: "rational thinking."
    But, when you're good and crazy? Oooh! Oooh! Oooh! The sky is the limit!

  3. #3
    Join Date
    Mar 2007
    Location
    Georgia USA
    Beans
    223
    Distro
    Xubuntu

    Re: 18.04 LemonPOS setup and mySQL issue.

    Bump.
    I've uninstalled and reinstalled mysql server and client with no change with Lemon/Squeeze, unicentaopos, or TOra.
    I can access mysql, but, only through sudo at command line.

    I tried again to cat the lemon SQL file into the main database and get access denied at command line, even with the correct password.

    I'm open to ideas.
    And, isn't sanity really just a one-trick pony anyway? I mean, all you get is one trick: "rational thinking."
    But, when you're good and crazy? Oooh! Oooh! Oooh! The sky is the limit!

  4. #4
    Join Date
    Mar 2007
    Location
    Georgia USA
    Beans
    223
    Distro
    Xubuntu

    Nothing can connect to mySQL.

    I had tried to setup a point of sale system.
    I only want things to connect at localhost.

    I'm sorry if this seems like duplication of asking for help.
    But, my target shifted on me and I think this thread is more direct to my underlying problem.

    I can only log into mySQL with sudo.
    Code:
    select host, user from mysql.user;
    lists my users as:
    Code:
    +-----------+------------------+
    | host      | user             |
    +-----------+------------------+
    | localhost | debian-sys-maint |
    | localhost | mysql.session    |
    | localhost | mysql.sys        |
    | localhost | root             |
    +-----------+------------------+
    I've been trying to setup LemonPOS and Unicentaopos.
    Only nothing can connect to the local database.

    I clearly have no clue as to what I'm doing on the mySQL side.

    I have TOra installed as a GUI interface for mySQL and it can't connect either.

    I have no clue what I've done wrong.

    I guess what I'm asking for is suggested reading for setting up mySQL.
    The man page is a little too technical for me at this point.

    I'll even take a book recommendation.

    Thanks.
    And, isn't sanity really just a one-trick pony anyway? I mean, all you get is one trick: "rational thinking."
    But, when you're good and crazy? Oooh! Oooh! Oooh! The sky is the limit!

  5. #5
    Join Date
    Mar 2011
    Location
    19th Hole
    Beans
    Hidden!
    Distro
    Ubuntu 20.04 Focal Fossa

    Re: 18.04 LemonPOS setup and mySQL issue.

    Please do not duplicate post as this confuses those trying to help and dilutes community effort.

    It is perfectly acceptable to bump your thread every 12 hrs to float it up from the bottom of the sea.

  6. #6
    Join Date
    Mar 2007
    Location
    Georgia USA
    Beans
    223
    Distro
    Xubuntu

    Re: 18.04 LemonPOS setup and mySQL issue.

    Quote Originally Posted by DuckHook View Post
    Please do not duplicate post as this confuses those trying to help and dilutes community effort.

    It is perfectly acceptable to bump your thread every 12 hrs to float it up from the bottom of the sea.
    This is fair.
    Sorry about my confusion.
    And, isn't sanity really just a one-trick pony anyway? I mean, all you get is one trick: "rational thinking."
    But, when you're good and crazy? Oooh! Oooh! Oooh! The sky is the limit!

  7. #7
    Join Date
    Nov 2008
    Location
    Metro Boston
    Beans
    15,615
    Distro
    Kubuntu Development Release

    Re: Nothing can connect to mySQL

    Code:
    Thu Sep 27 19:48:15 EDT 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    Did you read the error about SSL? You either need to configure certificates and the like, or not use SSL. If you're only connecting to the server itself via the localhost interface, SSL isn't necessary. Take a look at

    https://stackoverflow.com/questions/...mysql-database
    If you ask for help, do not abandon your request. Please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

  8. #8
    Join Date
    Mar 2007
    Location
    Georgia USA
    Beans
    223
    Distro
    Xubuntu

    Re: Nothing can connect to mySQL

    Quote Originally Posted by SeijiSensei View Post
    Code:
    Thu Sep 27 19:48:15 EDT 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    Did you read the error about SSL? You either need to configure certificates and the like, or not use SSL. If you're only connecting to the server itself via the localhost interface, SSL isn't necessary. Take a look at

    https://stackoverflow.com/questions/...mysql-database
    I've read the article.
    Here's what I've done so far.

    I converted configure.sh and start.sh with dos2unix. So, they run now.
    I do not get an SSL warning when launching "./configure"

    I granted all privileges to my local user in mySQL with:
    Code:
    grant all privileges on * . * to 'MYUSER'@'localhost';
    Here's what my database setup tab looks like:
    Unicentaopos_DatabaseSetup.jpg
    My user is different in execution. But, I'm not posting the real user name in the screenshot.

    I've appended the line DB1URL to read:
    Code:
    jdbc:mysql://localhost:3306/unicentaopos?zeroDateTimeBehavior=convertToNull&&useSSL=false
    I have actually created a database called "unicentaopos".

    I was able to connect on test! Hooray!

    I'm running "./start.sh".

    Things were going okay until I got this dialogue box:
    Unicentaopos_Script_Fail.png

    Terminal output at this point is as follows:
    Code:
    Oct 10, 2018 2:35:10 PM com.openbravo.data.loader.PreparedSentence openExec
    INFO: Executing prepared SQL: INSERT INTO applications(id, name, version) VALUES(?, ?, ?)
    However, running "./start.sh" again gives me the start page. Looks like I'm in.
    Unicenta_Start_Screen.jpg

    So, success?

    I get to play around with a point of sale system now. So, I'll mark the thread as solved.
    And, isn't sanity really just a one-trick pony anyway? I mean, all you get is one trick: "rational thinking."
    But, when you're good and crazy? Oooh! Oooh! Oooh! The sky is the limit!

  9. #9
    Join Date
    Jan 2019
    Beans
    1

    Re: Nothing can connect to mySQL

    Answer from ->> https://www.youtube.com/watch?v=qr-t8ksYO78
    go to my.cnf file, note that you will find multiple my.cnf file, i had to look at all of them to find this->
    # The MySQL server
    [mysqld]
    user = mysql
    port=3306
    socket = /opt/lampp/var/mysql/mysql.sock
    Copy the path and write it like ->
    mysql -u root -p --socket=/opt/lampp/var/mysql/mysql.sock
    Thanks

  10. #10
    Join Date
    Mar 2007
    Location
    Georgia USA
    Beans
    223
    Distro
    Xubuntu

    Re: Nothing can connect to mySQL

    Actually marked the thread as solved, as I've had this running for about three months now with no issue.
    The Google Translating of my post into something else and back into English is kind of amusing. But, it's happened twice now.

    I'm assuming it's a bot doing it.

    I don't particularly want to ask for a thread lock in case someone else has a similar issue.
    And, isn't sanity really just a one-trick pony anyway? I mean, all you get is one trick: "rational thinking."
    But, when you're good and crazy? Oooh! Oooh! Oooh! The sky is the limit!

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •