i need help

[mike303]

hi all

i really need your help.i have a root server with suse 10.1 and with plesk 8.2.
running 4 onlineshops with 10 domains and considering mail traffic!

yesterday the mail system worked not correctly. i found that the /var/plesk/mail/auth was empty. ok, i google for this and /usr/local/psa/admin/sbin/mail_auth_dump is me friend. but this file was not aviable. then i use the update function from Plesk Controlpanel. after this /usr/local/psa/admin/mail_auth_dump was not on his place. then i used /usr/local/psa/admin/sbin/autoinstaller. after some questions and downloads i updated to 8.6. now the /usr/local/psa/admin/sbin/mail_auth_dump was aviable and i could restore the passwd.db and the mailsystem accept pop3/imap requests again. BUT now is the plesx webpanel not aviable. no service is lisen on port 8443. the web server for plesk won't start because his config file /usr/local/psa/admin/conf/httpsd.conf is empty, the httpsd.conf.def does not help. the drweb sevice won't start because plesx service is not aviable. and so on. for short: how can i repair this.

i'm not new in linux but a big noob for 'plesx'. has anybody some time and nerves to help me?

 

[dash]

httpsd.conf.def is processed during upgrade to make httpsd.conf

So try to do the following:
replace httpsd.conf with httpsd.conf.def
and replace the following variables in it:
@admin_root@ => /usr/local/psa/admin
@admin_user@ => psaadm
@admin_group@ => psaadm
@fullhost@ => your_server_full_host_name

remove @vzsc_redirect@ if your server is not running under virtuozzo environment.

 

[mike303]

thank you, plesk is now running again. ;-)

but one error i found. when i go under Domains and then i select one of my domains then this happens:
ERROR: PleskMainDBException
MySQL query failed: Unknown column 'guid' in 'field list'

0: /usr/local/psa/admin/plib/common_func.php3:250
db_query(string 'select `id`,`name`,`displayName`,`cr_date`,`status`,`dns_zone_id`,`htype`,`cl_id`,`limits_id`,`params_id`,`cert_rep_id`,`real_size`,`guid` from domains where `id`=7')
1: /usr/local/psa/admin/plib/class.Table.php:180
Table->select()
2: /usr/local/psa/admin/plib/class.Domain.php:147
Domain->fetchAttrsFromTable_()
3: /usr/local/psa/admin/plib/class.Domain.php:97
Domain->Domain(integer '7')
4: /usr/local/psa/admin/plib/class.PhDomain.php:77
PhDomain->PhDomain(integer '7')
5: /usr/local/psa/admin/plib/common_func.php3:2930
objectMaker(string 'PhDomain', integer '7')
6: /usr/local/psa/admin/auto_prepend/auth.php3:325

 

[dash]

you need to add guidcolumn into clients and domains tables in psa database

'VARCHAR(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'

Looks like upgrade procedure was failed on your server...

 

[mike303]

YES! Thanks you.