[Planetlab-devel] problem with database?

[Lee Breslau]

Stephen,

I sent the file as an attachment, and got a notice that it was awaiting 
moderator approval due to the size of the attachment.

Let me know if I should resend via some other mechanism.

Lee


Stephen Soltesz wrote:
> Hello, Lee,
>
> Would you be willing to send us the content of /var/log/boot.log?  
> This should include some diagnostic messages output from the plc start 
> scripts.  We may be able to find some error messages there that will 
> point the way.
>
> Thank you,
> Stephen.
>
> Lee Breslau wrote:
>> Faiyez,
>>
>> I tried what you suggested with no success.  Specifically:
>>
>> I was able to connect to the database successfully from the command 
>> line.
>>
>> I stopped and started httpd, with same result.
>>
>> then:  service restart plc -- oddly, starting the web server failed 
>> in this case, not sure if that is relevant.
>>
>> so then I did service plc stop, and service plc start, and web server 
>> (and everything else) started successfully.
>> But still same result when I try to connect via the web.
>> Lee
>>
>>
>> Faiyaz Ahmed wrote:
>>> Hi,
>>>
>>> It sounds like your database (postgres) is either hung or not 
>>> running.  On your server, try connecting to it manually.
>>>
>>> # psql -U pgsqluser planetlab4
>>>
>>> If you can connect successfully, then your database is operating 
>>> normally.  If not, you may need to stop the service (service 
>>> postgresql stop), check for and kill hung processes, then restart 
>>> the DB (service postgresql start).
>>>
>>> Once you can connect manually, try restarting your webserver 
>>> (service httpd restart).  If all else fails, restart plc (service 
>>> plc restart).
>>>
>>> Please let us know if you encounter any relevant errors.
>>>
>>> Hope that helps.
>>>
>>> Regards,
>>> Faiyaz Ahmed
>>>
>>>
>>> On Jan 12, 2009, at 5:08 PM, Lee Breslau wrote:
>>>
>>>>
>>>> Hi,
>>>>
>>>> I have been running plc on a server for a couple of months.  After 
>>>> a reboot this weekend, I can no longer access it via the web 
>>>> interface.
>>>> I am getting error messages like the one below.
>>>> Can anyone provide some guidance about how to fix this?
>>>>
>>>> Something (presumably postgresql) is running on port 5432 on the 
>>>> server.
>>>>
>>>> Thanks.
>>>>
>>>> Lee
>>>>
>>>>
>>>>
>>>> Unable to connect to database
>>>> This either means that the database information in your 
>>>> |settings.php| file is incorrect or we can't contact the PostgreSQL 
>>>> database server. This could mean your hosting provider's database 
>>>> server is down.
>>>> The PostgreSQL error was: /pg_connect() [<a 
>>>> href='function.pg-connect'>function.pg-connect</a>]: Unable to 
>>>> connect to PostgreSQL server: could not connect to server: 
>>>> Connection timed out Is the server running on host 
>>>> "www.pluto.research.att.com" and accepting TCP/IP connections on 
>>>> port 5432?/
>>>> Currently, the database is /drupal/, the username is /pgsqluser/, 
>>>> and the database server is /www.pluto.research.att.com/.
>>>>
>>>>   * Are you sure you have the correct username and password?
>>>>   * Are you sure that you have typed the correct hostname?
>>>>   * Are you sure you have the correct database name?
>>>>   * Are you sure that the database server is running?
>>>>
>>>>
>>>> _______________________________________________
>>>> Devel mailing list
>>>> Devel at lists.planet-lab.org
>>>> https://lists.planet-lab.org/mailman/listinfo/devel
>>>
>>> _______________________________________________
>>> Devel mailing list
>>> Devel at lists.planet-lab.org
>>> https://lists.planet-lab.org/mailman/listinfo/devel
>>
>> _______________________________________________
>> Devel mailing list
>> Devel at lists.planet-lab.org
>> https://lists.planet-lab.org/mailman/listinfo/devel
>
> _______________________________________________
> Devel mailing list
> Devel at lists.planet-lab.org
> https://lists.planet-lab.org/mailman/listinfo/devel