Sitestudio problem

When you try to edit the pages using Sitestudio..

if it shows the below message and keep on displaying the same and nothing happens...

Please wait for graphics need to be generated 

check:
/hsphere/shared/Sitestudio/imaker.sh status

if it says stopped.

run
/hsphere/shared/Sitestudio/imaker.sh restart

Command to logout all the logged in users

who -u|grep -v root|awk '{print $6}'|kill  `awk '{print $0}'`

To view the mail accounts password's in plesk

Please follow the steps,  


1. Login to the MySQL,     


mysql -uadmin -p`cat /etc/psa/.psa.shadow`  


2. Select the database.     


  use psa;  


3. View the password.   


SELECT accounts.id, mail.mail_name, accounts.password, domains.name FROM domains LEFT JOIN mail ON domains.id = mail.dom_id LEFT JOIN accounts ON mail.account_id = accounts.id;


   

mysql check and repair

1.mysqlcheck databaseName tableName 

            Checks the specified table in the specified database. 

2.mysqlcheck databaseName 

 

            Checks all tables in the specified database. 

3.mysqlcheck -A  

            Checks all tables in all databases. 

4.mysqlcheck -a databaseName tableName 

            Analyzes the specified table in the specified database. 

5.mysqlcheck -r databaseName tableName 

          Repairs the specified table in the specified database.

6.mysqlcheck -r databaseName 

         Checks all tables in the specified database. 

7.mysqlcheck -r 

         Repair all Mysql databases

How to import and export contacts in squirrel mail

We need to install a plugin to do that.


1. Ddownload the following plugin "abook_import_export" according to the sqmail version you are using.


2. Extract the tar file and place the directory in the following location


/hsphere/shared/apache/htdocs/wmail/plugins


3. Then open the config.php file from 


/hsphere/shared/apache/htdocs/wmail/config/config.php


4. Search for the word "plugins", you will find so many lines like 


$plugins[1] = 'show_user_and_ip';


5. Add the line for your plugin,


$plugins[2] = 'abook_import_export';

Import and Export mysql tables

To export the mysql table

#mysqldump -u user -ppassword "databasename" "tablename" > tablename.txt

To import tables

#mysql -u user -ppassword "databasename" < tablename.txt

How to Disable .htaccess Server Wide

Open the apache configuration file using the text editor

#vi httpd.conf

Add the following in the file

<Directory />
 AllowOverride None
</Directory>

now the htaccess disabled in the server