Re: [Server-devel] Database error troubleshooting
Regarding below, on the Moodle forum I was advised to try deleting the Moodle config.php file (after backing up) and it would then bring up the install page to regenerate it. However, when I test this on my local XS (0.6) it says install.php not found. Looking for tips how to regenerate the database connection. David Subject: Re: [Server-devel] Database error troubleshooting Would appreciate any more tips on why the Moodle database connection is in error. My resource person in PNG has repeated tests on the XS and confirms service postgresql status and service httpd status both report postmaster/httpd services are running OK, but the Moodle home pages states database error. I can research this error for default Moodle installations but don't know if there are any specifics related to the XS Moodle configuration. David Leeming -Original Message- From: server-devel-boun...@lists.laptop.org [mailto:server-devel-boun...@lists.laptop.org] On Behalf Of David Leeming Sent: Friday, 11 May 2012 10:38 a.m. To: 'James Cameron' Cc: 'XS Devel' Subject: Re: [Server-devel] Database error troubleshooting More on this from my remote XO Champion in PNG Reminder: The error is : "Error: Database connection failed" as viewed in a connected XO when they try to access the Moodle home page (local schoolserver link in Browse) Rebooting does not help. We already established disk space is OK. It's a default 0.6 installation. service postgresql status - gives "postmaster is stopped" service httpd restart - stops and starts up OK it pings the FQDN and the shortcut schoolserver OK on the XS and an XO using Terminal. Any help with this appreciated. It is difficult to have to reinstall it, as no-one there has the skills. David Leeming Solomon Islands Rural Link www.rurallink.com.sb -Original Message- From: qu...@us.netrek.org [mailto:qu...@us.netrek.org] On Behalf Of James Cameron Sent: Wednesday, 9 May 2012 6:13 p.m. To: David Leeming Cc: 'Jerry Vonau'; 'XS Devel' Subject: Re: [Server-devel] Database error troubleshooting Have you tried rebooting the server? The reason that I ask, is that I imagine if the Unix domain socket was missing due to an accident, rebooting would start the database server component again and create the Unix domain socket. But I'm really not sure what other conditions might lead to the same symptom. -- James Cameron http://quozl.linux.org.au/ ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel
Re: [Server-devel] Database error troubleshooting
Would appreciate any more tips on why the Moodle database connection is in error. My resource person in PNG has repeated tests on the XS and confirms service postgresql status and service httpd status both report postmaster/httpd services are running OK, but the Moodle home pages states database error. I can research this error for default Moodle installations but don't know if there are any specifics related to the XS Moodle configuration. David Leeming -Original Message- From: server-devel-boun...@lists.laptop.org [mailto:server-devel-boun...@lists.laptop.org] On Behalf Of David Leeming Sent: Friday, 11 May 2012 10:38 a.m. To: 'James Cameron' Cc: 'XS Devel' Subject: Re: [Server-devel] Database error troubleshooting More on this from my remote XO Champion in PNG Reminder: The error is : "Error: Database connection failed" as viewed in a connected XO when they try to access the Moodle home page (local schoolserver link in Browse) Rebooting does not help. We already established disk space is OK. It's a default 0.6 installation. service postgresql status - gives "postmaster is stopped" service httpd restart - stops and starts up OK it pings the FQDN and the shortcut schoolserver OK on the XS and an XO using Terminal. Any help with this appreciated. It is difficult to have to reinstall it, as no-one there has the skills. David Leeming Solomon Islands Rural Link www.rurallink.com.sb -Original Message- From: qu...@us.netrek.org [mailto:qu...@us.netrek.org] On Behalf Of James Cameron Sent: Wednesday, 9 May 2012 6:13 p.m. To: David Leeming Cc: 'Jerry Vonau'; 'XS Devel' Subject: Re: [Server-devel] Database error troubleshooting Have you tried rebooting the server? The reason that I ask, is that I imagine if the Unix domain socket was missing due to an accident, rebooting would start the database server component again and create the Unix domain socket. But I'm really not sure what other conditions might lead to the same symptom. -- James Cameron http://quozl.linux.org.au/ ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel
Re: [Server-devel] Database error troubleshooting
I remain ignorant of how to solve this problem, however I have a random suggestion based on your observation: On Fri, May 11, 2012 at 11:38:07AM +1100, David Leeming wrote: > service postgresql status - gives "postmaster is stopped" Then try service postgresql start then check again with service postgresql status and if you no longer see "postmaster is stopped", check if the problem on an XO persists, and if so, check postgresql status again and then service httpd restart -- But this is blind prodding without understanding the real cause of the problem, sorry. I have never used XS. -- James Cameron http://quozl.linux.org.au/ ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel
Re: [Server-devel] Database error troubleshooting
More on this from my remote XO Champion in PNG Reminder: The error is : "Error: Database connection failed" as viewed in a connected XO when they try to access the Moodle home page (local schoolserver link in Browse) Rebooting does not help. We already established disk space is OK. It's a default 0.6 installation. service postgresql status - gives "postmaster is stopped" service httpd restart - stops and starts up OK it pings the FQDN and the shortcut schoolserver OK on the XS and an XO using Terminal. Any help with this appreciated. It is difficult to have to reinstall it, as no-one there has the skills. David Leeming Solomon Islands Rural Link www.rurallink.com.sb -Original Message- From: qu...@us.netrek.org [mailto:qu...@us.netrek.org] On Behalf Of James Cameron Sent: Wednesday, 9 May 2012 6:13 p.m. To: David Leeming Cc: 'Jerry Vonau'; 'XS Devel' Subject: Re: [Server-devel] Database error troubleshooting Have you tried rebooting the server? The reason that I ask, is that I imagine if the Unix domain socket was missing due to an accident, rebooting would start the database server component again and create the Unix domain socket. But I'm really not sure what other conditions might lead to the same symptom. -- James Cameron http://quozl.linux.org.au/ ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel
Re: [Server-devel] Database error troubleshooting
Have you tried rebooting the server? The reason that I ask, is that I imagine if the Unix domain socket was missing due to an accident, rebooting would start the database server component again and create the Unix domain socket. But I'm really not sure what other conditions might lead to the same symptom. -- James Cameron http://quozl.linux.org.au/ ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel
Re: [Server-devel] Database error troubleshooting
Thanks, I don't know how that might have come about as the server is not accessed via the terminal. It is quite important to us to try and find a solution on site. The chap there is able to follow simple instructions using the terminal. So any help greatly appreciated... David -Original Message- From: qu...@us.netrek.org [mailto:qu...@us.netrek.org] On Behalf Of James Cameron Sent: Wednesday, 9 May 2012 5:35 p.m. To: David Leeming Cc: 'Jerry Vonau'; 'XS Devel' Subject: Re: [Server-devel] Database error troubleshooting The Apache error logs suggest that the database connection failure is because of a missing Unix domain socket file in /tmp/.s.PGSQL.5432 which I imagine might occur if the file was accidentally removed since last boot. There may be other causes. I don't know enough about XS to advise further, sorry. I hope someone who knows will review the logs and give you advice. -- James Cameron http://quozl.linux.org.au/ ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel
Re: [Server-devel] Database error troubleshooting
The Apache error logs suggest that the database connection failure is because of a missing Unix domain socket file in /tmp/.s.PGSQL.5432 which I imagine might occur if the file was accidentally removed since last boot. There may be other causes. I don't know enough about XS to advise further, sorry. I hope someone who knows will review the logs and give you advice. -- James Cameron http://quozl.linux.org.au/ ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel
Re: [Server-devel] Database error troubleshooting
On Wed, 2012-05-09 at 11:28 +1100, David Leeming wrote: > I have a resource person at a remote school contacting me to say their > production XS is displaying “Error: database connection failed” on the > Moodle home page. It had been running OK for some weeks with a low > load – only 20 laptops. > > Moodle is very dependent on name resolution. > > He is able to follow simple instructions with the terminal and we > managed to check dish space – not a problem, the partitions are only > 20% or so used. > > > > What else can I suggest to try? > Ensure that the FQDN of the XS and 'schoolserver' are resolvable by both the XS and the XOs. Did the hostname/domain name change on the XS? Try pinging both the FQDN and the short alias from the XS and XO's. Jerry > > > David Leeming > > Solomon Islands > > > > > ___ > Server-devel mailing list > Server-devel@lists.laptop.org > http://lists.laptop.org/listinfo/server-devel ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel
Re: [Server-devel] Database error troubleshooting
On Wed, May 09, 2012 at 01:27:44PM +1100, David Leeming wrote: > cron.log attached, not very helpful, which other logs might help? Apache error and access logs? I don't know where they are on the XS, but on typical systems that I manage they can be found in /var/log/apache*/* -- James Cameron http://quozl.linux.org.au/ ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel
Re: [Server-devel] Database error troubleshooting
cron.log attached, not very helpful, which other logs might help? David From: server-devel-boun...@lists.laptop.org [mailto:server-devel-boun...@lists.laptop.org] On Behalf Of David Leeming Sent: Wednesday, 9 May 2012 11:28 a.m. To: 'XS Devel' Subject: [Server-devel] Database error troubleshooting I have a resource person at a remote school contacting me to say their production XS is displaying "Error: database connection failed" on the Moodle home page. It had been running OK for some weeks with a low load - only 20 laptops. He is able to follow simple instructions with the terminal and we managed to check dish space - not a problem, the partitions are only 20% or so used. What else can I suggest to try? David Leeming Solomon Islands cron.log Description: Binary data ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel
[Server-devel] Database error troubleshooting
I have a resource person at a remote school contacting me to say their production XS is displaying "Error: database connection failed" on the Moodle home page. It had been running OK for some weeks with a low load - only 20 laptops. He is able to follow simple instructions with the terminal and we managed to check dish space - not a problem, the partitions are only 20% or so used. What else can I suggest to try? David Leeming Solomon Islands ___ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel