Welcome Guest ( Log In | Register)



2 Pages V   1 2 >  
 Closed TopicStart new topic
> Is The Database System Gone Again? [resolved], Errors on PHPMyAdmin again
mrdee
post Jul 13 2008, 12:42 PM
Post #1


Super Member
*********

Group: [HOSTED]
Posts: 281
Joined: 18-July 07
From: Slough (UK)
Member No.: 46,682
I wonder if there is a problem with the PHPMyAdmin system again?

When trying to get into it, I once again get the following:

QUOTE
Warning: session_write_close() [function.session-write-close]: SQLite: session write query failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42

Warning: session_write_close() [function.session-write-close]: Failed to write session data (sqlite). Please verify that the current setting of session.save_path is correct (/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php:42) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 99


I first noticed it when, on my website, I tried to access a PHP Admin function to look at the contents of one of my databases, and where I got:

QUOTE
Warning: fopen() [function.fopen]: open_basedir restriction in effect. File(include/errors.xml) is not within the allowed path(s): (/home/mrdee:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/mrdee/public_html/admin/include/commonfunctions.php on line 682

Warning: fopen(include/errors.xml) [function.fopen]: failed to open stream: Operation not permitted in /home/mrdee/public_html/admin/include/commonfunctions.php on line 682
Cannot open XML data file: include/errors.xml


Does anyone know anything about this?

thanks.

(list)

Go to the top of the page
 
+Quote Post
Saint_Michael
post Jul 13 2008, 12:51 PM
Post #2


$p4m 0n j00 $h4m3 m3 0nc3 $p4m 0n m3 $h4m3 m3 7\/\/1c3
*********************

Group: [HOSTED]
Posts: 6,564
Joined: 21-September 04
From: 9r33|\| 399$ 4|\|D 5P4/\/\
Member No.: 1,218
T17 GFX Crew
I just seen it, and sent in a support ticket to xistosupport about. I did that last time when the phpmyadmin was down and it was back after awhile so its just a matter of waiting now.

(list)

Go to the top of the page
 
+Quote Post
mrdee
post Jul 13 2008, 09:13 PM
Post #3


Super Member
*********

Group: [HOSTED]
Posts: 281
Joined: 18-July 07
From: Slough (UK)
Member No.: 46,682
The issue seems to be resolved now.
Thanks for your help, Saint Michael.


(list)

Go to the top of the page
 
+Quote Post
serverph
post Jul 14 2008, 06:11 PM
Post #4


Ancient Enigma
Group Icon

Group: [MODERATOR]
Posts: 1,787
Joined: 11-July 04
From: under the stars
Member No.: 76
Topic is resolved.

Please PM any moderator to continue this discussion. Until then, this topic is closed.

(list)

Go to the top of the page
 
+Quote Post
serverph
post Jul 15 2008, 06:26 PM
Post #5


Ancient Enigma
Group Icon

Group: [MODERATOR]
Posts: 1,787
Joined: 11-July 04
From: under the stars
Member No.: 76
topic re-opened as per original author's request. apparently, it's an ongoing problem which is going ON and OFF at random... and still need to be discussed further as to its resolution.

(list)

Go to the top of the page
 
+Quote Post
mrdee
post Jul 16 2008, 07:41 PM
Post #6


Super Member
*********

Group: [HOSTED]
Posts: 281
Joined: 18-July 07
From: Slough (UK)
Member No.: 46,682
OK, serverph,
thanks for keeping us in the picture. (at least someone does).

The system seems to be up and running now, hopefully the randomness of ON/OFF stops now.

Also thanks to the other MODS who helped in the matter.


Oops, spoke too soon.
The problem is back again in all its glory.
Idesperately need access to my MySQL databases, as visitors need to be able to sign up for newsletters etc.

Howe much more trouble do they intend to cause us?

(list)

Go to the top of the page
 
+Quote Post
truefusion
post Jul 16 2008, 11:43 PM
Post #7


Ephesians 6:10-17
Group Icon

Group: [MODERATOR]
Posts: 1,916
Joined: 22-June 05
From: The World of Gentoo
Member No.: 8,528
I don't think what you're dealing with ever was a database problem. You should be able to access the database regardless of that error through a script that doesn't require sessions. But, of course, there are security implications that come with accessing the database through a script that is executable by anyone.

(list)

Go to the top of the page
 
+Quote Post
mrdee
post Jul 18 2008, 05:40 PM
Post #8


Super Member
*********

Group: [HOSTED]
Posts: 281
Joined: 18-July 07
From: Slough (UK)
Member No.: 46,682
Here is a copy of an email I sent to Trap 17 (as advised by Opaque):
QUOTE
CPanel Username: mrdee
CPanel Password: *******
Server : GAMMA

Forum Username: mrdee
Forum Credits : 3.72
Forum Member URL : http://www.vlaanderen-flanders.org.uk

ERROR: Warning: fopen() [function.fopen]: open_basedir restriction in effect. File(include/errors.xml) is not within the allowed path(s): (/home/mrdee:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/mrdee/public_html/admin/include/commonfunctions.php on line 682

Warning: fopen(include/errors.xml) [function.fopen]: failed to open stream: Operation not permitted in /home/mrdee/public_html/admin/include/commonfunctions.php on line 682
Cannot open XML data file: include/errors.xml
URL to ERROR: http://www.vlaanderen-flanders.org.uk/*************
ERROR: Warning: session_write_close() [function.session-write-close]: SQLite: session write query failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42

Warning: session_write_close() [function.session-write-close]: Failed to write session data (sqlite). Please verify that the current setting of session.save_path is correct (/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php:42) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 99

ERROR URL: http://www.vlaanderen-flanders.org.uk:2082...Admin/index.php?

This has gone on for about a week now.
A few times the error was resolved, only to come back a while later.
Yesterday I had a message from xistosupport they had resolved the issue, now it has started all over again.

This has been going on for a week now, it has been resolved a few times, yesterday Xistosupport sent me a message they had resolved the issue, but today, it was the same all over again.
This really isn't funny anymore.

(list)

Go to the top of the page
 
+Quote Post
truefusion
post Jul 18 2008, 06:07 PM
Post #9


Ephesians 6:10-17
Group Icon

Group: [MODERATOR]
Posts: 1,916
Joined: 22-June 05
From: The World of Gentoo
Member No.: 8,528
Just to make sure of my assumptions, do me a favor and run the following script when ever this error occurs (fill in the needed information, of course):
CODE
<?php

$db_host = "localhost";
$db_user = ""; // insert database user
$db_pass = ""; // insert password for above user
$conn = mysql_connect($db_host, $db_user, $db_pass) or die(mysql_error());

$db_name = ""; // any database name will do, so long as it has data in it that we can pull from

mysql_select_db($db_name);

$sql = "SELECT * FROM `table_name`"; // replace table_name with an existing table from the database above that has data in it

if (mysql_num_rows(mysql_query($sql)) > 0){
echo "<span style=\"color: green; font-weight: bold;\">Database is working fine.</span>";
} else {
echo "<span style=\"color: red; font-weight: bold;\">ERROR: ".mysql_error()."</span>";
}

?>

I have not tested the code, but it should work and if valid, i'm expecting it to show green text.

I'd do this on my account, but the database has been working for me every time i've tried to access it.