Welcome Guest ( Log In | Register )




                Web Hosting

2 Pages V   1 2 >  
Reply to this topicNew Topic
Phpmyadmin Continues To Have Errors.
sparkx
post Jul 14 2008, 05:56 PM
Post #1


Sparkx
Group Icon

Group: [HOSTED]
Posts: 371
Joined: 11-October 06
From: Dana Point, CA, USA
Member No.: 16,496
myCENTs:0.61


 I am aware that there is already a topic about PHPMyAdmin but I am receiving a different error (and that topic is closed). It seems as if PHPMyAdmin has an error in it's code. I received the following error.
CODE
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
Now I am unsure what the first two warnings are about but the third one doesn't like the fact that HTML was already printed out. Is this caused by something in my control panel or is it the server itself? I have just recently removed all user's (except one) from all the databases and enabled remote MySQL access. I wouldn't think that would cause a problem unless I removed PHPMyAdmin's user, but I don't think you can do that can you?

Any Suggestions?

Sparkx
Go to the top of the page
 
+Quote Post
Quatrux
post Jul 14 2008, 07:15 PM
Post #2


the Q
Group Icon

Group: [HOSTED]
Posts: 1,206
Joined: 13-July 05
From: Lithuania, Vilnius
Member No.: 7,059
myCENTs:90.94


I can confirm that I have the same error when I'm trying to access phpMyAdmin through CPanel..

the third error I guess is due to the previous two errors, they outputted something and headers couldn't be sent, it's a cookie or just a simple header..

strange error that Database is full, I wonder which database is full, maybe the server's?

I just tried to browse my CMS and the Panel, when I tried to do something with MySQL, something more than SELECT, I got an error from my CMS:

"Error: Are you *u*king hacking theSite CMS Panel.."

As I don't really remember where I wrote this error message, but as I remember it never should have been able to be shown, so I guess when I did UPDATE or INSERT it didn't work and else if didn't work as it should and it showed the else error message biggrin.gif So I guess who's on that server can't really add anything more, it's out of Space? or somebody hacked something and put all the DB Free Space with trash information..???

So I guess we aren't able to store or change anything in our MySQL databases..
Go to the top of the page
 
+Quote Post
yordan
post Jul 16 2008, 10:08 PM
Post #3


Way Out Of Control - You need a life :)
Group Icon

Group: [MODERATOR]
Posts: 2,292
Joined: 16-August 05
Member No.: 7,896
myCENTs:99.39


And the problem seems located in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php
the "session write query failed" seems to mean a permissions problem rather than a real "database is full" problem.
I would say that somebody should perform a chmod somewhere in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php
Yordan
Go to the top of the page
 
+Quote Post
Quatrux
post Jul 17 2008, 06:25 AM
Post #4


the Q
Group Icon

Group: [HOSTED]
Posts: 1,206
Joined: 13-July 05
From: Lithuania, Vilnius
Member No.: 7,059
myCENTs:90.94


You think it's only a PHPMyAdmin problem? Why doesn't MySQL work as it should with PHP too when yo try to do something more, like insert a row..
Go to the top of the page
 
+Quote Post
yordan
post Jul 17 2008, 11:18 AM
Post #5


Way Out Of Control - You need a life :)
Group Icon

Group: [MODERATOR]
Posts: 2,292
Joined: 16-August 05
Member No.: 7,896
myCENTs:99.39


QUOTE(Quatrux @ Jul 17 2008, 08:25 AM) [snapback]125838[/snapback]
You think it's only a PHPMyAdmin problem? Why doesn't MySQL work as it should with PHP too when yo try to do something more, like insert a row..

Seems that MySQL works with my site, I can add records in my GuestBook, add and delete posts in my PhpBB forums. That's why I think that my MySQL databases are OK, and only phpMyAdmin has problems.
Go to the top of the page
 
+Quote Post
yordan
post Jul 17 2008, 01:14 PM
Post #6


Way Out Of Control - You need a life :)
Group Icon

Group: [MODERATOR]
Posts: 2,292
Joined: 16-August 05
Member No.: 7,896
myCENTs:99.39


QUOTE(Quatrux @ Jul 17 2008, 08:25 AM) [snapback]125838[/snapback]
You think it's only a PHPMyAdmin problem? Why doesn't MySQL work as it should with PHP too when yo try to do something more, like insert a row..

Just for diagnosis purposes, i did a simple test. I downloaded phpadmin from sourceforge (http://www.phpmyadmin.net/home_page/downloads.php ) and uploaded into my astahost account www folder, and configured the server as "localhost". It works perfectly.
This means that the problem is inside the cpanel, the sytem calls to cpanel phpmyadmin are not correctly performed.
Clearly, the problem is in cpanel, and not in MySQL.
Go to the top of the page
 
+Quote Post
turbopowerdmaxst...
post Jul 17 2008, 01:35 PM
Post #7


Premium Member
Group Icon

Group: [HOSTED]
Posts: 427
Joined: 16-February 06
From: Kolkata, India
Member No.: 11,322
myCENTs:29.11


Its not just a PHPMyAdmin problem. The error seems to be related to session data which has to be saved somewhere in the /tmp directory. My statistics page which is based on Tracewatch is showing errors as well.
Go to the top of the page
 
+Quote Post
xboxrulz
post Jul 18 2008, 05:26 AM
Post #8


Colonel Panic
Group Icon

Group: [MODERATOR]
Posts: 2,939
Joined: 25-March 05
From: Toronto, Ontario, Canada
Member No.: 3,233
myCENTs:32.22


My whole Drupal installation is popping up with ridiculously large amount of errors. Like for the past few months, Astahost servers have been crippling my website systems.

I can't fix the Drupal issue without getting into PHPMyAdmin either.

xboxrulz
Go to the top of the page
 
+Quote Post
Quatrux
post Jul 18 2008, 06:18 AM
Post #9


the Q
Group Icon

Group: [HOSTED]
Posts: 1,206
Joined: 13-July 05
From: Lithuania, Vilnius
Member No.: 7,059
myCENTs:90.94


QUOTE(yordan @ Jul 17 2008, 02:18 PM) [snapback]125843[/snapback]
Seems that MySQL works with my site, I can add records in my GuestBook, add and delete posts in my PhpBB forums. That's why I think that my MySQL databases are OK, and only phpMyAdmin has problems.


Hmm, well you're right, just did a test it works, but my CMS doesn't work, I can't login and do something to the Panel, so as others said, maybe it's a session problem, because it uses sessions, strange though, when I'll comeback I'll need to check a simple php script with the server by using sessions..

yeah, just took a look and to get that login error it could happen due to sessions also.. So maybe something is happening with permissions or the place the sessions are saved, never saw these kind of errors.

This post has been edited by Quatrux: Jul 18 2008, 06:23 AM
Go to the top of the page
 
+Quote Post
zorba4
post Jul 18 2008, 01:28 PM
Post #10


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 10
Joined: 9-March 08
Member No.: 28,999
myCENTs:22


Maybe somebody with a csh account shoud do a "ls -ld /tmp", just to check permissons for creating temporary files too...
Go to the top of the page
 
+Quote Post

2 Pages V   1 2 >
Reply to this topicNew Topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Collapse

> Similar Topics

    Topic Title Replies Topic Starter Views Last Action
No New Posts   5 96than 1,544 23rd November 2008 - 02:20 AM
Last post by: Arbitrary
No New Posts   13 FirefoxRocks 803 26th June 2008 - 03:24 AM
Last post by: docduke
No New Posts   5 demolaynyc 1,522 2nd June 2008 - 08:22 AM
Last post by: iGuest
No New Posts   4 xboxrulz 615 4th May 2008 - 05:33 AM
Last post by: xboxrulz
No New Posts   6 sparkx 537 13th March 2008 - 09:58 PM
Last post by: yordan
No New Posts   0 Habble 886 13th February 2008 - 04:18 AM
Last post by: Habble
No New Posts   5 Sten 479 8th February 2008 - 01:42 AM
Last post by: