Page 1 sur 1
404 Not Found when login
Publié : mar. sept. 01, 2020 11:44 am
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?
Re: 404 Not Found when login
Publié : mar. sept. 01, 2020 12:15 pm
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.
Re: 404 Not Found when login
Publié : mer. janv. 20, 2021 2:40 pm
par ppuiseux
Hello,
How is declared yout squash-tm user in Mysql ?
What is his address ?