Article - CS260130

"Password authentication failed for user "twadmin"" while starting ThingWorx with PostgreSQL

Modified: 29-Aug-2024   


Applies To

  • ThingWorx Platform 7.3 F000 to 9.5
  • PostgreSQL 9.4/9.5

Description

  • While starting ThingWorx with PostgreSQL 9.4 below error appears in postgresql log :
    •  twadmin@thingworx FATAL:  password authentication    failed for user "twadmin"
    • twadmin@thingworx DETAIL:  Connection matched pg_hba.conf line 92: "host     all     all     127.0.0.1/32        md5"
  • In some cases following error is seen only catalina logs, but not in postgres or application logs. Rather logs are not generated in postgres at all
    • org.postgresql.util.PSQLException: FATAL: password authentication failed for user "twadmin"
  • Tomcat stdout log file shows error as : could not connect to database: Invalid password

 
This is a printer-friendly version of Article 260130 and may be out of date. For the latest version click CS260130