trvpseudo Posted January 22, 2020 Share Posted January 22, 2020 hello all, so lets go to the main point.i already did ALL documentations provided but nothing!heres what i did :1. install jasper2. have postgre 9.5 in app server3. have same postgre 9.5 in db server4. test wether they can connect (yes they can connect)5. change buildomatic/default_master.properties parameter, META_INF/context.xml6. clean config7. gen config8. js-install.sh minimal9. DB created10. start service with "ctlscript.sh start"11. postgre connect to 5432 (in remote server its 5551)how to setup the connection to the right port?any idea?pls help, any idea might give me a clue.regards, -TV Link to comment Share on other sites More sharing options...
yann22580 Posted January 22, 2020 Share Posted January 22, 2020 Don't really know the install process but I remember you can try the install with a --test option. Did you try it ?And the error says 'denied', did you check the users and permissions used in your properties/xml files ?Hope you'll find the answer soon.Yann Link to comment Share on other sites More sharing options...
trvpseudo Posted January 23, 2020 Author Share Posted January 23, 2020 thank youand i did already tried it. so its because the admin dont allow my userid to crate omg..now the DB has been created in remote server, cant connect to it when i start the ctlscript.sh startthe postgre seems to connect to port default 5432 not the port i specified like 5551any idea about that?thanks a lot Link to comment Share on other sites More sharing options...
Solution trvpseudo Posted January 30, 2020 Author Solution Share Posted January 30, 2020 found the way for bundling version- if you need to create DB first in remote server follow this step:1. install the jasperserver with .run (linux)2. change in buildomatic default_master.properties : host, port, dbusername, password & ucomment something like "js.dbName = jasperserver" (can change jasperserver to ur custom DB name else it will create DB by the default name jasperserver)3. change jasperserver file META-INF/context.xml, change username, password & url4. go to buildomatic command prompt and do './js-ant clean-config' then './js-ant gen-config' (using linux, if windows without ./ )5. then do './js-install.sh minimal' (minimal = no sample data), this step will create the DB with the new config in default_master.propertiesnote that u need existing credential within the server allowed to create DB so buildomatic can create the DB.- if you already have DB created within the remote server :1. simply change username, password and url in webapps/jasperserver/meta-inf/context.xml2. restart jasperserverit shouldve connect to remote server.Regards, - TV - last update 13 aug 2020 Link to comment Share on other sites More sharing options...
trvpseudo Posted August 13, 2020 Author Share Posted August 13, 2020 fyi, the 5432 in console is a hardcode string, can ignore it or change it somewhere in postgre folder. find the script used to turn on postgre and u'll find the hardcode text.regardless, if u do the step above it shouldve been connect to the assigned DB. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now