Is The Database System Gone Again? [resolved]

mrdee

Jul 13 2008, 12:42 PM

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.

Saint_Michael

Jul 13 2008, 12:51 PM

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.

mrdee

Jul 13 2008, 09:13 PM

The issue seems to be resolved now.
Thanks for your help, Saint Michael.

serverph

Jul 14 2008, 06:11 PM

Topic is resolved.

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

serverph

Jul 15 2008, 06:26 PM

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.

mrdee

Jul 16 2008, 07:41 PM

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?

truefusion

Jul 16 2008, 11:43 PM

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.

mrdee

Jul 18 2008, 05:40 PM

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.

truefusion

Jul 18 2008, 06:07 PM

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.

sonesay

Jul 18 2008, 11:40 PM

Yeah you are probably right the problem is probably not directly related to database problems because all queries still work but scripts that require session data to be saved don't work that's why phpmyadmin fails as well.

Latest Entries

rvalkass

Jul 23 2008, 10:21 AM

Topic is resolved.

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

mrdee

Jul 23 2008, 10:06 AM

It looks like this topic can now be closed (again).
For a few days now, my page and PHPMyAdmin have been working normally (touch wood, as, knowing my luck, whenever I post a message here about an issue being resolved, as soon as I go away from this forum and check the page again, the error is back in all its glory).
Hopefully, this will now be the end of it, as it has been going on for far too long.
I guess people can understand my frustration when you have errors that keep coming back in minutes, especially when they affect pages which you rely on for input and requests from your visitors. (In my case a newsletter subscription, shopping cart and comment and query form).

Anyway, as far as I am concerned, this is now resolved (again).

ADD REPLY / Got an Opinion!	a humble request :-)	RAPID SEARCH!	Free Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE

Is The Database System Gone Again? [resolved] - Errors on PHPMyAdmin again

Is The Database System Gone Again? [resolved] - Errors on PHPMyAdmin again

Latest Entries