Thank you for good explanation. Now Tomcat starts ok, but when I try to connect localhost:8080 - it show error: ------------- HTTP Status 404 - / The requested resource (/) is not available. ------------- How can I fix it? What's the problem?
David Smith wrote: >The "URL" as used here means Universal Resource Locator aka URI (Universal >Resource Identifier). It's a standardized syntax for defining where to find >resources and doesn't always have to do with web content. In this case, >we're telling Tomcat to connect via JDBC to the PostgreSQL database at >localhost and use the database 'authority' to get user authentication info. > >You will also have to make another table in addition to 'users' named >'user_roles'. It should have two columns: 'users' and 'user_roles'. > >One note on PostgreSQL: If postmaster wasn't started with the -i option, you >will have to restart it with that since JDBC does not recognize UNIX domain >sockets and postmaster by default does not offer a TCP/IP listen port. Test >it with psql -h localhost -U test -W authority. If you connect and >authenticate with password test, you've just done exactly what the JDBC >driver is going to do and everything should be set. Just make sure you >secure your db before making it available to the world with effective >passwords, privileges, and a firewall. > >Hope this helps clear it up a bit. > >--David Smith > >On Tuesday 30 October 2001 08:35 pm, you wrote: > >>Dear All. >> >>Can smbd help me to setup Tomcat 4 with Postgres 7.1? >>I'm so stupid, I can't understand some things. >> >>To use Java/JSP with DB (Tomcat's Realm, Postgres) to check authorities >>I should: >>1. Make DB with table containing user_name and user_pass >>2. Install JDBC driver for Postgres >>---- It's ok. >>3. Edit "server.xml": >> >><Realm className="org.apache.tomcat.request.JDBCRealm" debug="99" >> driverName="org.postgresql.Driver" >> >>connectionURL="jdbc:postgresql://localhost/authority?user=test;password=tes >>t" userTable="users" userNameCol="user_name" >>userCredCol="user_pass" >> userRoleTable="user_roles" roleNameCol="role_name" /> >> >>And what's the string: connectionURL >>Does it mean, that I should put user's DB into the root www catalog?????? >>How and where Tomcat can find my user's table? >> >>Thanks, Max >> >> >> >>-- >>To unsubscribe, e-mail: >><mailto:[EMAIL PROTECTED]> For additional >>commands, e-mail: <mailto:[EMAIL PROTECTED]> >> > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > >. > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
