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

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

Hi,

The error what I can see on admin UI

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

Please let me know if this helps!

Thanks

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...

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.

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

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