Unanswered: Need help making a connection to the DB
Requirement: Copy a website/webapp, along with DB data under a different name and dB on the same hosting server.
Website has been copied to another directory - and partially working (JSP)
Database has been duplicated and renamed - (PostgreSQL)
Host is Apache 2.2.3 - (Really old system) on
"Linux version 2.4.26-1-386 (horms@tabatha) (gcc version 3.2.3 (Debian)) #1 Tue Aug 24 13:31:19 JST 2004"
Ont the duplicated site the first page shows up fine but it fails to login. I cannot figure out where to go and make the change so that the website can pull the data from the newdb
Did you check the logs in the DB and web server?
If you renamed your database, what did you do with the connection string? Did you adapt anything? What about privileges?
Can you connect to the new db from the psql prompt? I am curious to know how you duplicated the db.
I don't know about Debian, but on Slackware, I have two log files for the webserver: access_log and error_log. It has been ages since I used Tomcat. If not mistaken, it also has logging facility. Did you check this?
In my case, Postgresql logs is in /var/log.
I take you used pg_dump tool to backup the db and created a new one from the backup script...
I am not familiar with virtual system so I can't help from that point of view. It's only me but I prefer to use a second machine.
When I referred to privileges I was not very clear, I meant granting connection permission through file pg_hba.conf. But if your run everything in a virtual environment, I guess there should be no changes...changes
Not sure about your last question. But if you run two databases from the same server, they must have different names.
One thing though. Maybe first start by just duplicating the application and see if it can connect to the original db? Maybe that would help to troubleshoot.