Joget V5 installation mysql error

 
1
0
-1

Hi , 

I encounter the below erros as mention on comman issue during instalation FAQ ( Setting Up Database) . but I could not find how to fix, did any one too encounter the same ? , Please help to share your findings 

 

Setting Up Database

    CommentAdd your comment...

    5 answers

    1.  
      2
      1
      0

      Hi Janak,

      Assuming jogetuser is your MySQL user, I'd suggest running the following on your database before you start the setup:

      GRANT ALL PRIVILEGES ON * . * TO 'jogetuser'@'localhost';

      You could also replace the * with jwdb to be more precise on which schema to give permission on.

      Please let me know if this works!

       

      Thanks.

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Seems like you don't have proper permissions on the database for your user.

        Please let me know if this helps!

         

        Thanks

        1. Janak

          Hi Ashutosh, Thanks, but i don't find any good ref.docs from joget for setup. looks like end user or customer has to run like headless chicken to complete setup. you see the error just saying connection failed and if you look Joget support page the setup as (Installation on Linux ) Create a new directory (e.g. /opt/joget) and extract the tar.gz bundle into that directory Install the Java Runtime Environment (JRE) or Java Development Kit (JDK) version 6 and above Install MySQL Server version 5 and above Create an empty database 'jwdb' in the MySQL server Execute the setup script to create the required database tables: ./setup.sh Execute the bundled Apache Tomcat application server: ./tomcat8.sh run Access the App Center at http://localhost:8080/jw Follow on with Setting Up Database. with this, I am trying to get best, but no luck...

        2. Janak

          when I Just follow the default, its works.. lesson learned as the Joget Product site docs need to add more details. joget.v.5.0.9]# ./setup.sh Buildfile: build.xml setup-db: [input] Please enter MySQL host name: [localhost] [input] Please enter MySQL port: [3306] [input] Please enter MySQL database name: [jwdb] [input] Please enter MySQL username: [root] [input] Please enter MySQL password: [] [input] Please enter profile name to create: [default] create-db: [echo] Creating database, please wait... create-profile: [copy] Copying 1 file to /opt/joget/joget.v.5.0.9/wflow [propertyfile] Updating property file: /opt/joget/joget.v.5.0.9/wflow/app_datasource.properties setup: BUILD SUCCESSFUL Total time: 14 seconds [root@test] [joget.v.5.0.9]# \mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 377 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | jwdb | | mysql | | test | +--------------------+ 4 rows in set (0.00 sec) mysql> mysql> \Q ERROR: Unknown command '\Q'. -> \q Bye

        CommentAdd your comment...
      2.  
        1
        0
        -1

        Hi,

        The error what I can see on admin UI

          CommentAdd your comment...
        1.  
          1
          0
          -1

          joget.v.5.0.9]# ./setup.sh

          Buildfile: build.xml

          setup-db:

              [input] Please enter MySQL host name: [localhost]

          127.0.0.1

              [input] Please enter MySQL port: [3306]

          3306

              [input] Please enter MySQL database name: [jwdb]

          jwdb

              [input] Please enter MySQL username: [root]

          jogetuser

              [input] Please enter MySQL password: []

          jogetuser

              [input] Please enter profile name to create: [default]

          default

          create-db:

               [echo] Creating database, please wait...

               [exec] ERROR 1045 (28000): Access denied for user 'jogetuser'@'localhost' (using password: YES)

               [exec] Result: 1

               [exec] ERROR 1045 (28000): Access denied for user 'jogetuser'@'localhost' (using password: YES)

               [exec] Result: 1

          create-profile:

               [copy] Copying 1 file to /opt/joget/joget.v.5.0.9/wflow

          [propertyfile] Updating property file: /opt/joget/joget.v.5.0.9/wflow/app_datasource.properties

          setup:

          BUILD SUCCESSFUL

          Total time: 2 minutes 5 seconds

           ___________

           cat /opt/joget/joget.v.5.0.9/wflow/app_datasource.properties

          #Thu Jan 28 17:37:19 SGT 2016

          currentProfile=default

           

           

           

          1. Anders

            The error message seems pretty clear: Access denied for user 'jogetuser'@'localhost' (using password: YES) Either the user password is wrong, or that user does not have permission to access the database, so you'll need to grant the appropriate privileges http://dev.mysql.com/doc/refman/5.6/en/grant.html

          CommentAdd your comment...
        2.  
          1
          0
          -1

          Hi there,

          Could you please share the error message that you see? The errors in the logs would also be of much help.

           

          Thanks,

          Ashutosh

            CommentAdd your comment...