Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Selecting data from mysql using qt?

Selecting data from mysql using qt?

Scheduled Pinned Locked Moved General and Desktop
150 Posts 7 Posters 141.3k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • D Offline
    D Offline
    doforumda
    wrote on last edited by
    #89

    there are 6 files in there but no mysql.log

    these are the files
    access_log, cgisock.1693, error_log, httpd.pid, php_error_log, ssl_request_log

    1 Reply Last reply
    0
    • D Offline
      D Offline
      Dii
      wrote on last edited by
      #90

      Don't bother with the log files, I guess Qt looks at the wrong place for the socket file...

      Let's check this line in your mysql config file (my.cnf):

      socket = /var/run/mysqld/mysqld.sock

      You should find my.cnf in /etc/ or /etc/mysql/ ... I don't know ubuntu that much.

      1 Reply Last reply
      0
      • D Offline
        D Offline
        doforumda
        wrote on last edited by
        #91

        1st solution returns this
        @
        root@zafar-laptop:/# find /opt/lampp -name *.log
        /opt/lampp/htdocs/xampp/contrib/sqlnet.log
        @

        1 Reply Last reply
        0
        • D Offline
          D Offline
          doforumda
          wrote on last edited by
          #92

          with which editor i can view that .conf file. with gedit or something.

          1 Reply Last reply
          0
          • L Offline
            L Offline
            lyuts
            wrote on last edited by
            #93

            [quote author="¤ Dii ¤" date="1286881470"]
            You should find my.cnf in /etc/ or /etc/mysql/ ... I don't know ubuntu that much.[/quote]

            I don't think that this config will be in /etc. He uses lampp - a preconfigured bundle. That config might be in /opt/lampp.

            I'm a rebel in the S.D.G.

            1 Reply Last reply
            0
            • D Offline
              D Offline
              Dii
              wrote on last edited by
              #94

              BTW a quick sum:

              • mysql is installed
              • database and tables are created
              • access is granted
              • qt code looks fine

              I see two possibilities here: libmysqlclient is missing, or the socket file is at different place.

              1 Reply Last reply
              0
              • D Offline
                D Offline
                doforumda
                wrote on last edited by
                #95

                the file my.cnf is in etc/mysql folder

                1 Reply Last reply
                0
                • D Offline
                  D Offline
                  Dii
                  wrote on last edited by
                  #96

                  doforumda: use gedit

                  sudo gedit /etc/mysql/my.cnf

                  at least most of the ubuntu machines have the config file there.

                  1 Reply Last reply
                  0
                  • D Offline
                    D Offline
                    doforumda
                    wrote on last edited by
                    #97

                    this is the socket line in my.cnf

                    @
                    socket = /var/run/mysqld/mysqld.sock
                    @

                    1 Reply Last reply
                    0
                    • D Offline
                      D Offline
                      Dii
                      wrote on last edited by
                      #98

                      ok then the wrong socket guess was wrong... but let's make it sure:

                      sudo ls -l /var/run/mysqld/*

                      1 Reply Last reply
                      0
                      • D Offline
                        D Offline
                        doforumda
                        wrote on last edited by
                        #99

                        after running this sudo ls -l /var/run/mysqld/* there is nothing inside run directory

                        1 Reply Last reply
                        0
                        • D Offline
                          D Offline
                          Dii
                          wrote on last edited by
                          #100

                          uhmmmmmmm that's more than strange, the socket file should be there somewhere, let's find it:

                          find /var -name mysqld.sock

                          if no result:

                          find /opt -name mysqld.sock

                          1 Reply Last reply
                          0
                          • D Offline
                            D Offline
                            doforumda
                            wrote on last edited by
                            #101

                            both of them didnt return any resutl

                            @
                            root@zafar-laptop:/# find /var -name mysqld.sock
                            root@zafar-laptop:/# find /opt -name mysqld.sock
                            root@zafar-laptop:/#
                            @

                            1 Reply Last reply
                            0
                            • L Offline
                              L Offline
                              lyuts
                              wrote on last edited by
                              #102

                              I have bitnami lampp stack installed and when I start it then the socket file is created in /opt/lamppstack/mysql/tmp/mysql.sock. I think doforumda shoudl have similar directory and we need to check the permissions for that directory.

                              I'm a rebel in the S.D.G.

                              1 Reply Last reply
                              0
                              • D Offline
                                D Offline
                                Dii
                                wrote on last edited by
                                #103

                                Usually that means, that the mysql daemon is not running... but the the command line should not work as well... ;(

                                It doesn't hurt to try to start the daemon:

                                sudo /etc/init.d/mysql start

                                ... and do the search for the socket file as above.

                                1 Reply Last reply
                                0
                                • D Offline
                                  D Offline
                                  Dii
                                  wrote on last edited by
                                  #104

                                  gosh, do the find with sudo:

                                  sudo find /opt -name mysqld.sock
                                  sudo find /var -name mysqld.sock

                                  damn, I always forget that with ubuntu

                                  1 Reply Last reply
                                  0
                                  • D Offline
                                    D Offline
                                    Dii
                                    wrote on last edited by
                                    #105

                                    lyuts: yes, if he have the socket file at the same place, we need to symlink it to the /var/... location and happy end :) I hope so.

                                    1 Reply Last reply
                                    0
                                    • D Offline
                                      D Offline
                                      doforumda
                                      wrote on last edited by
                                      #106

                                      tyut: yes i have one file with the name of mysql.sock in /opt/lampp/var/mysql/mysql.sock

                                      1 Reply Last reply
                                      0
                                      • D Offline
                                        D Offline
                                        doforumda
                                        wrote on last edited by
                                        #107

                                        the permissions on mysql.sock it read write exe for all types of users

                                        1 Reply Last reply
                                        0
                                        • D Offline
                                          D Offline
                                          Dii
                                          wrote on last edited by
                                          #108

                                          Great, don't give up, we are close :D

                                          ls -l /opt/lampp/var/mysql/*

                                          maybe you have another mysql config file somewhere:

                                          ls -l /opt/lampp/etc/my.cnf
                                          or
                                          ls -l /opt/lampp/etc/mysql/my.cnf
                                          ?

                                          1 Reply Last reply
                                          0

                                          • Login

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Users
                                          • Groups
                                          • Search
                                          • Get Qt Extensions
                                          • Unsolved