Urgent Help - Cant access site front page or login area - it says Warning: a technical problem (SQL server) is preventing access

Monde en
#1

Dear People at spip:

can someone help i run big spip site hosted on ovh i think the version is 3.0 series and not 3.1 (not sure)

Cant access site front page or login area - it says the following

===
Site under construction
Warning: a technical problem (SQL server) is preventing access to this part of the site. Thank you for your patience.

here is the screen shot of part of the error log:

error-log2-jul.png
​
​Please recommend course of action to restore the site

regards

Harsh Kapoor

#2

What I do in such situation is first , making sure that I have backup of database and IMG folder. Then I empty tmp folder by renaming it, and creating a new one. Using example .htaccess file (htaccess.txt) is also helpful. But before that I do not delete the existed .htaccess file, I just rename it to have a backup.

error-log2-jul.png

#3

Dear Kamran:

Thanks for responding promptly. I am told that there has been a technical incident at the host server at the Data centre in Paris. So am waiting to see if this problem will resolve by itself. I will see how i can obtain a back up and that the back from today may be damaged, the other option to get a back up from last week. [will mean loosing many articles]

then i will do as you suggest. Chnage name of the tmp folder and create a new empty one

htaccess i will have to get this from the installer pack but (i dont know which exact SPIP version of tthe 3.0 tree i am running. I hope the htaccess file doesnt change with versions does it

I hope your suggestion works

thanks

-Harsh

error-log2-jul.png

#4

The problem persists despite course of action suggested by Kamran

  1. I renamed the tmp folder [havent deleted its contents] and created a new one called tmp,

(I have back up of the sql database and the IMG folder)

  1. also renamed the existing .htaccess file and placed the htaccess.tx and renamed it to .htaccess.

BUT I still see the warning message on the screen:

error-log2-jul.png

#5

check the connection file connect.php, and make sure you have correct info there.

error-log2-jul.png

#6

Very grateful for your help Kamran. I just checked all is working fine without even looking up the connect file is fine and it has taken some time for the your previous course of action measures to start working

thanks a ton

salaams & greetings

Harsh

error-log2-jul.png

#7

Hi

You should first check that the connection to the database is working. Check also all the logs (SPIP logs in /tmp/log and, if you have access, the server's logs). It will be difficult to solve the problem without checking the logs.
Check also the permissions on your SPIP directories.

George

Quoting Harsh Kapoor <aiindex@gmail.com>:

Very grateful for your help Kamran. I just checked all is working fine
without even looking up the connect file is fine and it has taken some time
for the your previous course of action measures to start working

thanks a ton

salaams & greetings
Harsh

On Tue, Jul 4, 2017 at 5:24 AM, Kamran Mir Hazar <mirhazar.kamran@gmail.com>
wrote:

check the connection file connect.php, and make sure you have correct info
there.

On Tue, Jul 4, 2017 at 1:05 AM, Harsh Kapoor <aiindex@gmail.com> wrote:

The problem persists despite course of action suggested by Kamran
1. I renamed the tmp folder [havent deleted its contents] and created a
new one called tmp,
(I have back up of the sql database and the IMG folder)

2. also renamed the existing .htaccess file and placed the htaccess.tx
and renamed it to .htaccess.

BUT I still see the warning message on the screen:

Site under construction
Warning: a technical problem (SQL server) is preventing access to this
part of the site. Thank you for your patience.

Please advice what is to be done?
regards
Harsh Kapoor

On Mon, Jul 3, 2017 at 3:27 AM, Kamran Mir Hazar <
mirhazar.kamran@gmail.com> wrote:

What I do in such situation is first , making sure that I have backup of
database and IMG folder. Then I empty tmp folder by renaming it, and
creating a new one. Using example .htaccess file (htaccess.txt) is also
helpful. But before that I do not delete the existed .htaccess file, I just
rename it to have a backup.

On Sun, Jul 2, 2017 at 11:42 PM, Harsh Kapoor <aiindex@gmail.com> wrote:

Dear People at spip:

can someone help i run big spip site hosted on ovh i think the version
is 3.0 series and not 3.1 (not sure)

Cant access site front page or login area - it says the following

===
Site under construction
Warning: a technical problem (SQL server) is preventing access to this
part of the site. Thank you for your patience.

here is the screen shot of part of the error log:

​
​Please recommend course of action to restore the site

regards
Harsh Kapoor

_______________________________________________
spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en

#8

Dear George, measures suggested by Kamran have worked. The site is up
and working
thanks to all
-Harsh

On Tue, Jul 4, 2017 at 2:02 PM, George Kandalaft
<george@middleeastwatch.net> wrote:

Hi

You should first check that the connection to the database is working. Check
also all the logs (SPIP logs in /tmp/log and, if you have access, the
server's logs). It will be difficult to solve the problem without checking
the logs.
Check also the permissions on your SPIP directories.

George

Quoting Harsh Kapoor <aiindex@gmail.com>:

Very grateful for your help Kamran. I just checked all is working fine
without even looking up the connect file is fine and it has taken some
time
for the your previous course of action measures to start working

thanks a ton

salaams & greetings
Harsh

On Tue, Jul 4, 2017 at 5:24 AM, Kamran Mir Hazar
<mirhazar.kamran@gmail.com>
wrote:

check the connection file connect.php, and make sure you have correct
info
there.

On Tue, Jul 4, 2017 at 1:05 AM, Harsh Kapoor <aiindex@gmail.com> wrote:

The problem persists despite course of action suggested by Kamran
1. I renamed the tmp folder [havent deleted its contents] and created a
new one called tmp,
(I have back up of the sql database and the IMG folder)

2. also renamed the existing .htaccess file and placed the htaccess.tx
and renamed it to .htaccess.

BUT I still see the warning message on the screen:

Site under construction
Warning: a technical problem (SQL server) is preventing access to this
part of the site. Thank you for your patience.

Please advice what is to be done?
regards
Harsh Kapoor

On Mon, Jul 3, 2017 at 3:27 AM, Kamran Mir Hazar <
mirhazar.kamran@gmail.com> wrote:

What I do in such situation is first , making sure that I have backup
of
database and IMG folder. Then I empty tmp folder by renaming it, and
creating a new one. Using example .htaccess file (htaccess.txt) is also
helpful. But before that I do not delete the existed .htaccess file, I
just
rename it to have a backup.

On Sun, Jul 2, 2017 at 11:42 PM, Harsh Kapoor <aiindex@gmail.com>
wrote:

Dear People at spip:

can someone help i run big spip site hosted on ovh i think the version
is 3.0 series and not 3.1 (not sure)

Cant access site front page or login area - it says the following

===
Site under construction
Warning: a technical problem (SQL server) is preventing access to this
part of the site. Thank you for your patience.

here is the screen shot of part of the error log:

Please recommend course of action to restore the site

regards
Harsh Kapoor

_______________________________________________
spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en

_______________________________________________
spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en