Problem with mango on WinServer 2008 R2

Hi guys! I have a big problem! Mango was working fine and perfectly until yesterday night.... today i found that the pc probably reboot by itself, and now.... everytime a try to access to the webpage, tomcat say always to me "The requested resource () is not available."
I don't know how to solve the problem. I'm running Mango with Mysql on Xampp.
Some details:
Mango v. 1.8.2
Mysql ( on xampp

5.1.41
Apache download from seratonin site v. 6.0.20.
The only thing i did yesterday was creating a "dbuser" on mysql to access to mango logged data by a custom webpage.
I always run and stop the service by using the startup and shutdown script into /apache..../bin folder.
Any help will be appreciated. Regards from Italy!

Maybe it can help someone:
from localhost log:

13-lug-2010 11.50.22 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextDestroyed()
13-lug-2010 11.50.22 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextDestroyed()
13-lug-2010 11.50.23 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
13-lug-2010 11.50.23 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
13-lug-2010 11.50.23 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
13-lug-2010 11.50.24 org.apache.catalina.core.StandardContext listenerStart
GRAVE: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'dbuser'@'localhost' (using password: YES))
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:42

at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:59)
at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:86)
at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:259)
at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:89)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:987)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:909)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:28

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'dbuser'@'localhost' (using password: YES))
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1232)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:881)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
... 30 more
Caused by: java.sql.SQLException: Access denied for user 'dbuser'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:204

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:3

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1254)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:122

... 33 more
13-lug-2010 11.50.24 org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext

from catalina log:

13-lug-2010 11.50.21 org.apache.coyote.http11.Http11Protocol pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
13-lug-2010 11.50.22 org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
13-lug-2010 11.50.22 org.apache.coyote.http11.Http11Protocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
13-lug-2010 11.50.23 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: c:\Program Files (x86)\Java\jre6\bin;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Fujitsu\ServerView Suite\PrimeUp\;C:\Program Files (x86)\OpenVPN\bin
13-lug-2010 11.50.23 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
13-lug-2010 11.50.23 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 212 ms
13-lug-2010 11.50.23 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
13-lug-2010 11.50.23 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
13-lug-2010 11.50.24 org.apache.catalina.core.StandardContext start
GRAVE: Error listenerStart
13-lug-2010 11.50.24 org.apache.catalina.core.StandardContext start
GRAVE: Context [] startup failed due to previous errors
13-lug-2010 11.50.24 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
13-lug-2010 11.50.24 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
13-lug-2010 11.50.24 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/31 config=null
13-lug-2010 11.50.24 org.apache.catalina.startup.Catalina start
INFO: Server startup in 1452 ms

Thanks in advance!!

What happend if you open a shell amd execute

mysql -u dbuse -h localhost -p

?

If you cant login the problem is on your mysql installation.

If you can log, in which OS (Win/Linux[RedHat,Ubuntu,...],...)do you use?

Arne

Hi Arne,
nothing happend because I already removed that user from privile of mysql when i saw some error with that name! Now there is no user called "dbuser" but mango is still generating error!
Yesterday i was playing with php and mysql, that's why i create that user from phpmyadmin. And everything ( mango, php web page <-> mysql

were working ok!
I'm using Windows Server 2008 R2!
Regards!

Sorry for the OS (Now I see it, It was already in the header ;-)).

If you look at you log you will find

Access denied for user 'dbuser'@'localhost' (using password: YES)

that means mango is using the user dbuser somehow. Look in the file: TOMCAT\webapps\ROOT\WEB_INF\classes\env.properties.
So if you still encounter problems I would look for that user/password listed there.

Arne

Hey Arne, thank you so much!!!! Eveything works now!! You were right, in that file there was the "dbuser" username. Now I changed it with "adminstrator" and pass "admin". But...just a question.... why by creating a user for the mango's database.... i had this problem?? Who wrote that user in env.proprieties??? If i want a user to connect to pointvalues database..... what can i do??? However thank you again!

That may be a phpadmin problem I'm using the MYSQL Admin/Query Browser...

Who wrote .. I don't know mango not ;-) - maye it was you?

If i want a user to connect to pointvalues database..... what can i do?

What do you mean exactly by this phrase?

The point values are in a table in the mango database, just use SQL against the mago database...

Arne