I tried to install Thingoworx 7.1 with Java 8.1 Apache Tomcat 8.0 and PostgreSQL 9.5 (PgAdmin III) in Windows Server 2008 R2 Enterprise Service Pack 1.
I followed the steps on the manual:
1) install Tomcat and run the service
2) install PostgreSQL with PgAdmin III and create the login role
3) Create ThingworxPostgresqlStorace in C with full control to NETWORK SERVICE
3) Try to run the Bat files (Setup and Schema) after configured that (i created the thingoworx DB and tablespace via PgAdmin GUI )
below the code:
-- Tablespace: thingworx
-- DROP TABLESPACE thingworx
CREATE TABLESPACE thingworx
-- Database: thingworx
-- DROP DATABASE thingworx;
CREATE DATABASE thingworx
WITH OWNER = twadmin
ENCODING = 'UTF8'
TABLESPACE = thingworx
LC_COLLATE = 'English_United States.1252'
LC_CTYPE = 'English_United States.1252'
CONNECTION LIMIT = -1;
4) Create the json file in the Thingworx Platform folder in C: (attached file)
5) Added the thingworx.war file in webapps folder
in "manager apps" it seems ok:
when i click on Thingoworx something went wrong: Could not Authenticate, Invalid Authentication content
I tried to start and stop the app and reload with no results.
What's went wrong?
Anyone can help me?
Marco, the password set for twadmin and the one in the platform-settings.json matches, correct? Also, we support (and recommend) PostgreSQL 9.4. Please do install that instead. On a side note, similar to the other thread, please do post your Application log from ThingworxStorage/logs and Catalina logs from Tomcat_install_path/logs folder.
i'm stucked at this point, during configuration of PostgreSQL 9.4
Can i create tablespace and database using GUI Pg admin instead of bat file?
I need to delete the following stuff because impact on Postgresql?
(all in C: path)
Marco, you can create them in the pgAdmin tool as well. A tablespace exists, correct? You can right click Databases and add a new Database called 'thingworx' with the owner set to twadmin. If you don't have a tablespace, you can add that one too, a tablespace called 'thingworx'. Make sure the Location field in Definition points to '\ThingworxPostgresqlStorage'.
Marco, the user trying to execute the bat file might have no access permissions to the .sql files. Try adding full-control permissions to the user and execute the script. Also, try executing the bat file as 'Administrator'.
No, I downloaded the trial edition.
And I just found out I just need to change my Java version in order to play with Thingworkx trial edition.
Thanks for your answer
i followed already these steps, the only difference is that (maybe is important) i have Windows 10. Please see my logs.
Thanks for your help.
Just wanted to put this out here since I recently installed TW 7.1.3 with PostgreSQL 9.5.3 and I kind of ran into same issue but then i realized it was due to the incorrect settings (was my mistake) in the platform-settings.json file. I tried creating this file completely from scratch using the Appendix B: Sample platform-settings.json from the installation guide of ThingWorx 7.1.1 (page 46) and obviously tried too many settings without completely understanding the implication of each setting.
To resolve the issue I used the sample file that comes with the download package from the PTC Software Download page which has basic settings to get you up and running - all it need is configuration to the server, username & password and the JDBC URL.
May be Miklos Lorincz you want to copy this file over as a starting point and once you have a successful connection try to extend the settings using the Apendix B: Sample platform-settings.json as a reference. Of course, lookout for the other steps and suggestions discussed in this thread.
Hope this helps.
after i tried to install on another System i realized that there was some system issue.
I made a clean up with thingworxPostgresDBCleanup.bat i re-runn the thingworxPostgresDBSetup.bat, i need to re-create the thingworks table space manualy, i did the following setup:
- i set the password for twadmin again
- re-set the location of the Storage
- i set the owner of the table space as twadmin
- run the thingworxPostgresSchemaSetup again
and that was it. Everything works now on my system to.
Maybe something hasn't run at the begging with the setup batch but after i made a clean and remade almost everything .
Thank you all for your help.