404 Not Found when login

anaigini45
Messages : 2
Inscription : mar. sept. 01, 2020 11:40 am

404 Not Found when login

Message par anaigini45 »

Hi,

I installed squash-tm into a CentOS 7 box, using tar.gz.
The version I have used is 10.3.
However, after I run ./startup.sh, and open this link : http://<ip>:8080/squash/login, I get 404 Not Found.

What are the permissions that I have to check and change?

There are also these errors during startup :

Code : Tout sélectionner

[root@qavm9-2 bin]# ./startup.sh
./startup.sh : checking java environment... done
checking version... done
./startup.sh : starting Felix...
Picked up _JAVA_OPTIONS: -Ddb.driver=com.mysql.jdbc.Driver -Ddb.url=jdbc:mysql://localhost:3306/squashtm -Ddb.username=squash-tm -Ddb.password=mon_password -Ddb.dialect= -Duser.language=en
log4j:WARN No appenders could be found for logger (org.eclipse.jetty.util.log).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Are they related?
anaigini45
Messages : 2
Inscription : mar. sept. 01, 2020 11:40 am

Re: 404 Not Found when login

Message par anaigini45 »

I added the line "DB_DIALECT="org.hibernate.dialect.MySQLDialect" into startup.sh, and executed it, and now the error is :

Code : Tout sélectionner

HTTP ERROR 500

Problem accessing /squash/login. Reason:

    Server Error
Part of the error excerpt from this page is :

Code : Tout sélectionner

	at java.lang.Thread.run(Thread.java:701)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'squash-tm'@'localhost' (using password: YES))
	at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
	at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)
	at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:292)
	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)
	... 139 more
Caused by: java.sql.SQLException: Access denied for user 'squash-tm'@'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:3491)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:534)
	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:38)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
	at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
I then run this command in the mysql db prompt :

Code : Tout sélectionner

mysql> GRANT ALL ON squashtm.* TO 'squash-tm'@'localhost';
Query OK, 0 rows affected (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.03 sec)
But I still get the HTTP 500 error above.
ppuiseux
Messages : 49
Inscription : ven. mars 30, 2018 12:53 pm

Re: 404 Not Found when login

Message par ppuiseux »

Hello,
How is declared yout squash-tm user in Mysql ?
What is his address ?
Répondre

Revenir à « Installation & Base de données / Installation & Database »