The password of the account has expired

March 7, 2012

I'm currently getting a 404 'The requested reource () is not available error which started after I reset my ms sql jiradbuser account whilst trying to fix a 'password has expired' issue.

I'm not sure whether the root of the problem is the password has expired issue, the database not being available or the connection pool issue per the logs below.

I've checked the dbconfig.xml file and reset the SQL user to that password, restarted the services and still get the same error (I didn't think SQL user passwords could expire??)

I have a problem also in that I can't find the database at the location in dbconfig.xml; I do get a error in MS SQL when I try to view the User Mapping for jiradbuser and it says 'One or more databases are inaccessible and will not be displayed in list' - the only DB i can't see is the Jira database.

How do I troubleshoot this issue / where do I start?

Any help would be greatly appreciated.

(related to trying to find the db issue; https://answers.atlassian.com/questions/40335/how-do-i-find-where-jira-s-database-is

atlassian-jira.log:

****************

JIRA starting...

****************

2012-03-08 15:39:37,411 main INFO [atlassian.jira.startup.JiraStartupLogger]

___ Environment _____________________________

JIRA Build : 4.4.3#663-r165197

Build Date : Mon Oct 17 00:00:00 EST 2011

JIRA Installation Type : Standalone

Application Server : Apache Tomcat/6.0.32 - Servlet API 2.5

Java Version : 1.6.0_26 - Sun Microsystems Inc.

Current Working Directory : C:\Windows\system32

Maximum Allowable Memory : 455MB

Total Memory : 122MB

Free Memory : 91MB

Used Memory : 31MB

Memory Pool: Code Cache : Code Cache: init = 2359296(2304K) used = 826112(806K) committed = 2359296(2304K) max = 50331648(49152K)

Memory Pool: PS Eden Space : PS Eden Space: init = 33554432(32768K) used = 30466792(29752K) committed = 33554432(32768K) max = 167772160(163840K)

Memory Pool: PS Survivor Space : PS Survivor Space: init = 5570560(5440K) used = 2254968(2202K) committed = 5570560(5440K) max = 5570560(5440K)

Memory Pool: PS Old Gen : PS Old Gen: init = 89522176(87424K) used = 0(0K) committed = 89522176(87424K) max = 357957632(349568K)

Memory Pool: PS Perm Gen : PS Perm Gen: init = 16777216(16384K) used = 11181192(10919K) committed = 16777216(16384K) max = 268435456(262144K)

JVM Input Arguments : -Dcatalina.base=C:\Program Files\Atlassian\JIRA -Dcatalina.home=C:\Program Files\Atlassian\JIRA -Djava.endorsed.dirs=C:\Program Files\Atlassian\JIRA\endorsed -Dmail.mime.decodeparameters=true -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true -Djava.io.tmpdir=C:\Program Files\Atlassian\JIRA\temp -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=C:\Program Files\Atlassian\JIRA\conf\logging.properties -XX:MaxPermSize=256m -Xms128m -Xmx512m

___ Java System Properties ________________

awt.toolkit : sun.awt.windows.WToolkit

catalina.base : C:\Program Files\Atlassian\JIRA

catalina.home : C:\Program Files\Atlassian\JIRA

catalina.useNaming : true

common.loader : ${catalina.base}/lib,

${catalina.base}/lib/*.jar,

${catalina.home}/lib,

${catalina.home}/lib/*.jar

file.encoding : Cp1252

file.encoding.pkg : sun.io

java.awt.graphicsenv : sun.awt.Win32GraphicsEnvironment

java.awt.printerjob : sun.awt.windows.WPrinterJob

java.class.version : 50.0

java.home : C:\Program Files\Atlassian\JIRA\jre

java.io.tmpdir : C:\Program Files\Atlassian\JIRA\temp

java.naming.factory.initial : org.apache.naming.java.javaURLContextFactory

java.naming.factory.url.pkgs : org.apache.naming

java.runtime.name : Java(TM) SE Runtime Environment

java.runtime.version : 1.6.0_26-b03

java.specification.name : Java Platform API Specification

java.specification.vendor : Sun Microsystems Inc.

java.specification.version : 1.6

java.util.logging.config.file : C:\Program Files\Atlassian\JIRA\conf\logging.properties

java.util.logging.manager : org.apache.juli.ClassLoaderLogManager

java.vendor : Sun Microsystems Inc.

java.vendor.url : http://java.sun.com/

java.vendor.url.bug : http://java.sun.com/cgi-bin/bugreport.cgi

java.version : 1.6.0_26

java.vm.info : mixed mode

java.vm.name : Java HotSpot(TM) Server VM

java.vm.specification.name : Java Virtual Machine Specification

java.vm.specification.vendor : Sun Microsystems Inc.

java.vm.specification.version : 1.0

java.vm.vendor : Sun Microsystems Inc.

java.vm.version : 20.1-b02

mail.mime.decodeparameters : true

org.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER : true

os.arch : x86

os.name : Windows Server 2008

os.version : 6.0

package.access : sun.,

org.apache.catalina.,

org.apache.coyote.,

org.apache.tomcat.,

org.apache.jasper.,

sun.beans.

package.definition : sun.,

java.,

org.apache.catalina.,

org.apache.coyote.,

org.apache.tomcat.,

org.apache.jasper.

server.loader :

shared.loader :

sun.arch.data.model : 32

sun.boot.library.path : C:\Program Files\Atlassian\JIRA\jre\bin

sun.cpu.endian : little

sun.cpu.isalist : pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86

sun.desktop : windows

sun.io.unicode.encoding : UnicodeLittle

sun.jnu.encoding : Cp1252

sun.management.compiler : HotSpot Tiered Compilers

sun.os.patch.level : Service Pack 2

tomcat.util.buf.StringCache.byte.enabled : true

user.country : AU

user.dir : C:\Windows\system32

user.home : C:\

user.language : en

user.name : BCAS02$

user.timezone : Australia/Sydney

user.variant :

2012-03-08 15:39:37,426 main INFO [atlassian.jira.startup.JiraStartupLogger] Running JIRA startup checks.

2012-03-08 15:39:37,504 main INFO [atlassian.jira.startup.JiraHomeStartupCheck] The jira.home directory 'C:\Program Files\Atlassian\Application Data\JIRA' is validated and locked for exclusive use by this instance.

2012-03-08 15:39:37,504 main INFO [atlassian.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.

2012-03-08 15:39:37,863 main INFO [jira.config.database.SystemTenantDatabaseConfigurationLoader] Reading database configuration from C:\Program Files\Atlassian\Application Data\JIRA\dbconfig.xml

2012-03-08 15:39:38,050 main INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher

2012-03-08 15:39:38,222 main ERROR [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:jtds:sqlserver://mbds1:45527/jiradb', driverClassName='net.sourceforge.jtds.jdbc.Driver', username='jiradbuser', password='********', isolationLevel='null', connectionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=15, minSize=2, maxWait=60000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery='null', minEvictableTimeMillis=null, timeBetweenEvictionRunsMillis=null}}

java.lang.RuntimeException: Unable to obtain a connection from the underlying connection pool

at org.ofbiz.core.entity.jdbc.interceptors.connection.ConnectionTracker.trackConnection(ConnectionTracker.java:59)

at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.trackConnection(DBCPConnectionFactory.java:149)

at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:137)

at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)

at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146)

at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:101)

at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)

at com.atlassian.jira.ofbiz.DefaultOfBizConnectionFactory.getConnection(DefaultOfBizConnectionFactory.java:28)

at com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:100)

at com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.databaseSetup(MinimumUpgradableVersionCheck.java:49)

at com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.isOk(MinimumUpgradableVersionCheck.java:30)

at com.atlassian.jira.startup.JiraDatabaseConfigChecklist.doStartupChecks(JiraDatabaseConfigChecklist.java:65)

at com.atlassian.jira.startup.JiraDatabaseConfigChecklist.startupOK(JiraDatabaseConfigChecklist.java:53)

at com.atlassian.jira.startup.DatabaseChecklistLauncher.start(DatabaseChecklistLauncher.java:35)

at com.atlassian.jira.startup.DefaultJiraLauncher$2.run(DefaultJiraLauncher.java:90)

at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:250)

at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:155)

at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:85)

at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:24)

at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:61)

at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:33)

at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:56)

at com.atlassian.jira.startup.LauncherContextListener$1.create(LauncherContextListener.java:68)

at com.atlassian.jira.startup.LauncherContextListener$1.create(LauncherContextListener.java:63)

at com.atlassian.multitenant.impl.MultiTenantComponentMapImpl.get(MultiTenantComponentMapImpl.java:121)

at com.atlassian.multitenant.impl.MultiTenantComponentMapImpl.onTenantStart(MultiTenantComponentMapImpl.java:165)

at com.atlassian.multitenant.impl.DefaultMultiTenantManager$1.consume(DefaultMultiTenantManager.java:134)

at com.atlassian.multitenant.impl.DefaultMultiTenantManager$1.consume(DefaultMultiTenantManager.java:131)

at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForEachListener(DefaultMultiTenantManager.java:256)

at com.atlassian.multitenant.impl.DefaultMultiTenantManager.startTenant(DefaultMultiTenantManager.java:130)

at com.atlassian.multitenant.impl.DefaultMultiTenantManager.startAll(DefaultMultiTenantManager.java:203)

at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:96)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Caused by: java.sql.SQLException: Login failed for user 'jiradbuser'. Reason: The password of the account has expired.

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)

at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)

at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)

at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:357)

at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)

at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:154)

at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:97)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)

at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)

at org.ofbiz.core.entity.transaction.DBCPConnectionFactory$1.call(DBCPConnectionFactory.java:153)

at org.ofbiz.core.entity.transaction.DBCPConnectionFactory$1.call(DBCPConnectionFactory.java:150)

at org.ofbiz.core.entity.jdbc.interceptors.connection.ConnectionTracker.trackConnection(ConnectionTracker.java:53)

... 46 more

2012-03-08 15:39:38,222 main ERROR [atlassian.jira.startup.LauncherContextListener] Unable to start JIRA.

com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: Login failed for user 'jiradbuser'. Reason: The password of the account has expired.

at com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:127)