Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't Access PLESK 8.2 MySQL query failed: Incorrect information in...

Status
Not open for further replies.

giganetwireless

IS-IT--Management
Jul 18, 2007
20
Hello Group..

NEWBIE

FC6
PLESK 8.2
Main drive and Slave drive


Note: I have uploaded /etc/log/messages as a txt file to
After making changes I listed at the base of this post when logged into PLESK 8.2 I found that when accessing => Server => Mail I was receiveing an error from PLESK stating that it couldn't make a write to /tmp/???, I am sorry I didn't save the message now! :(
Anyhow I tried using 'service mysqld restart' and since that PLESK has become totally inaccessible and is displaying the following error message:

ERROR: PleskMainDBException MySQL query failed: Incorrect information in file: './psa/misc.frm'
0: /usr/local/psa/admin/plib/common_func.php3:216 db_query(string 'select param, val from misc')
1: /usr/local/psa/admin/plib/common_func.php3:513 get_param(string 'mysql41_compatible')
2: /usr/local/psa/admin/plib/common_func.php3:410 db_set_names()
3: /usr/local/psa/admin/plib/common_func.php3:389 db_connect_real(string 'localhost', string 'admin', string '*********', string 'psa')
4: /usr/local/psa/admin/plib/common_func.php3:369 db_connect()
5: /usr/local/psa/admin/auto_prepend/auth.php3:87

How would I repair this situation, I unfortunately have no backup as iPower just loaded PLESK 8.2 onto this new drive last week for me.

Backups first from now on!


This problem is also affecting email send/receive ability. :?


I followed an Online guide to begin securing a LINUX box at:
http://forums.overclockersclub.com/index.php?showtopic=15248

Exactly what was done
1) Set PermitRootLogin to no
2) Added user admin to 'su -' to 'root'
3) Installed 'chkrootkit'
4) Ran 'yum update'
5) Secured SSH
* Changed port from 22 to 54000
* Modified '/etc/hosts.allow' to my IP 72.169.152.210
* Modified '/etc/hosts.deny' to sshd: ALL
6) Modified '/etc/httpd/httpd.conf' ServerSignature 'off'
7) Modified '/etc/php.ini' 'expose_php = off'
8) Modified '/etc/mail/sendmail.mc' added 'define(`confSMTP_LOGIN_MSG','')'
Could not get the command below to make the config go 'LIVE'
'm4 /etc/mail/sendmail.mc > /etc/sendmail.cf'

Then when I used '/sbin/service sendmail restart' command I receive the following error:

Shutting down sm-client: [FAILED]
Shutting down sendmail: [FAILED]
Starting sendmail: sendmail: usage: sendmail [ -t ] [ -fsender ] [ -Fname ] [ -bp ] [ -bs ] [ arg ... ]
[FAILED]
Starting sm-client: /etc/selinux/targeted/contexts/files/file_contexts: Multiple same specifications for /usr/local/sitebuilder/tmp(/.*)?.
sendmail: illegal option -- L
sendmail: usage: sendmail [ -t ] [ -fsender ] [ -Fname ] [ -bp ] [ -bs ] [ arg ... ]
[FAILED]
9) Installed LibSafe
10) Modified mount '/tmp' with 'noexec'
Added this line to 'fstab' '/etc/fstab':
loop, noexec, nosuid, rw 00
11) Tried to mask fingerprint but settings wouldn't take.

After trying to mask fingerprint I noticed if I run a 'ls' in /root the contents of /root have been populated with files modified while trying to hide fingerprints and iptables-init.d.original
(below are /root contents):

anaconda-ks.cfg
install.log
install.log.syslog
ip_default_ttl~
iptables-init.d.original
olddrive
psa
psa_installer_v3.1.2_build070321.17_os_FedoraCore_6_i386
rmem_default~
rmem_defaulx~
rmem_defauly~
rmem_defaulz~
swsoft


Can someone please provide some mentoring/guidance so I can restore access to PLESK and very hopefully email function will be restored with PLESK access restoration?
Thank you for sharing your knowledge.:)

Regards
 
Rename or Remove'/etc/hosts.allow'
Rename or Remove '/etc/hosts.deny'
remove 'noexec' from fstab at '/tmp'

And please read everything and test before moving on to the next item on your wannahaves list!
 
Thank you for the reply...

I renamed 'hosts.allow' && 'hosts.deny'.
I removed 'noexec' from /etc 'fstab', however, when I attempt to save the settings ':w!' I receive this error, it won't open to save??

"fstab"
"fstab" E212: Can't open file for writing
Press ENTER or type command to continue


What is it requiring of me to write the file?

thank you
 
you have to be root to access system wide or security files.

"su - root" first
 
Thank you for the reply

THat what was wierd, I was logged in as 'root'...
A few minutes later I used ':w!' and it successfully wrote to the file???

I have found through input from other forums that it will most likely be required that I re-install PLESK to regain access to PLESK and to enable a new mysql connection to enable the email accounts again for my wireless clients.

I'm not so sure I like this PLESK proprietarism so much.??

Have a good one
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top