Cannot find registry resource for Application ID

Cannot find registry resource for Application ID This error is shown when you access an application link in the 'Applications' tab in Parallels Plesk Panel: Internal error: Can not find registry resource for Application ID fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b Can not find registry resource for Application ID fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b Resolution 1.Check there is an aps_registry_object record for this application...

Read More

Exim Commands

Exim Commands Debug a mail delivery:  /usr/sbin/exim -bt -d email@address.com Retry message delivery:  /usr/sbin/exim -M messageID Force delivery of all message:  /usr/sbin/exim -qf Force delivery of all message and delete of frozen ones:  /usr/sbin/exim -qff Shows log delivery for a message:  /usr/sbin/exim -Mvl messageID Display message body:  /usr/sbin/exim -Mvb messageID Display message...

Read More

Check how much memory your PHP script is using

Check how much memory your PHP script is using? The answer is the memory_get_peak_usage() function. At the end of your PHP script (footer script for a PHP site, you get the idea), put this line: echo memory_get_peak_usage(); Or you can write the data down in a text file: file_put_contents('mu.txt', memory_get_peak_usage()); The output is in bytes.More friendly output,Add to the footer of the templates: <?phpfunction...

Read More

How to run a stored procedure in sql server every hour

How to run a stored procedure in sql server every hour Following step bellow: In SQL Server Management Studio navigate to SQL Server Agent-->Jobs Right click on the Job Folder and select new job On the dialog that pops up, give the job a name click on steps, then on new, you will see a dialog like the following, pick correct DB and...

Read More

Mysql change the default character set and collation of a table

Mysql change the default character set and collation of a table To change the default character set and collation of a table including those of existing columns (note the convert to clause): alter table convert to character set utf8 collate utf8_general_ci; Note: You can't alter multiple tables at once in mysql, just write a query file to alter all tables and execute that fil...

Read More

SQL SERVER – Find Row Count in Table – Find Largest Table in Database

SQL SERVER – Find Row Count in Table – Find Largest Table in Database How many rows are there in any particular table? This script will gives row number for every table in database. USE AdventureWorks GO SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count FROM sys.dm_db_partition_stats st WHERE index_id < 2 ORDER BY st.row_count...

Read More

Disable exim email on single cPanel Account

Disable exim email on single cPanel Account  A week ago one of our clients account been compromised and the attacker used the server to blast emails. as a system administrator my task was to prevent any outgoing email from the account before I start to investigate the attack and remove any kind of scripts from the hosting account. Studying cPanel files made me to come around following solution. To disable email for one...

Read More