It is likely that presto web app has not started properly. Try to go to /presto instead of /prestohub. If you get 404 it means that your presto web app either not there or not up. First check if it is there - under /tomcat/webapps directory. If it is there look at presto.log file as well as tomcat logs to see if you can get some clue why presto would not start
Hi Ganesh,
I think saw some where in Presto Respository setup doc that at the time of confugration you will have to create a new account and this account need to given admin priveleges.
But in my case I didn't do this and just restarted the presto server. I think when we restart presto automatically admin account is created with need previleges.
Did you checked in postgress database if all tables are created properly? Are you able to see some exception in server logs?
You should not need to create a new admin user for Presto when using PostgreSQL at the database. Running the scripts that come with Presto to create the tables also populates them with the same default roles that are shipped with HSQL.
I'm posting some of the common errors seen in the prestoserver.log when there is a configuration issue between Presto and PostgreSQL and the common resolutions:
- 1. If you see the following error:
ERROR [org.springframework.web.context.ContextLoader] - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'esdInternalSrvcsPublisher' defined in ServletContext resource [/WEB-INF/classes/applicationContext.xml]: Instantiation of bean failed; nested exception is
Ensure that the tables in the createDBTables.txt file have been created and that you have permission to access them with the connection information you put in the properties file.
- 2. If you see the following error:
ERROR [com.jackbe.jbp.sas.rds.impl.jdo.JDOClassloaderFactory] - Cannot discover classloader to be used by JPOX PMF java.lang.ClassNotFoundException: org.postgresql.Driver
Ensure that the postgresql-8.4-701.jdbc4.jar is in the <presto-install>/appserver/apache-tomcat-XXX/webapps/presto/WEB-INF/lib directory.
- 3. If you see the following error:
ERROR [DataNucleus.Datastore.Schema] - Failed initialising database. Cannot create PoolableConnectionFactory (FATAL: role "XXXXX" does not exist)
Ensure that the username is specified correctly in the <presto-install>/appserver/apache-tomcat-XXX/webapps/presto/WEB-INF/classes/rdsJdbc.properties file.
- 4. If you see the following error:
ERROR [DataNucleus.Datastore.Schema] - Failed initialising database. Cannot create PoolableConnectionFactory (FATAL: database "<database>" does not exist)
Ensure that the jdbc.url is specified correctly in the <presto-install>/appserver/apache-tomcat-XXX/webapps/presto/WEB-INF/classes/rdsJdbc.properties file.
- 5. If you see the following error:
ERROR [DataNucleus.Datastore.Schema] - Failed initialising database. Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
Ensure that postgresql is started.
- 6. If you see the following error:
ERROR [DataNucleus.Datastore.Schema] - Failed initialising database. Cannot create PoolableConnectionFactory (FATAL: no pg_hba.conf entry for host "XX.XX.XXX.XXX", user "<username>", database "<database>", SSL off)
Ensure that the correct ip address is entered in postgresql’s pg_hba.conf file.
- 7. If you see the following error:
ERROR [DataNucleus.Datastore.Schema] - Failed initialising database. Cannot create PoolableConnectionFactory (FATAL: Ident authentication failed for user "<user>")
Ensure that md5 authentication is specified in the pg_hba.conf for your web server.
Hi,
After installing the Prestoserver I configured it with Postgresql server 8.4 .
followed the steps mentioned in the documentation, but now I am unable to login using "admin" login.
am getting following HTTP 404 error while trying to login.
Can some body help me with it.
its Prest 3.1
Thanks,
Omganesh