You can modify the following option in “WHM Home » Server Configuration » Tweak Settings” under the “Stats and Logs” tab:
“The interval, in days, to retain Exim stats in the database”
Reducing this value will decrease the amount of data that is stored in the Eximstats database. If you decide to drop the eximstats tables completely, you can generate a new instance of the tables via:
/usr/local/cpanel/bin/updateeximstats
→ No Comments Tags: Cheat Sheets · Cpanel and WHM · Linux Commands · Linux Software / Scripts · Linux Tricks
This simple command will list the inodes used for any group on the server:
repquota -a | head -n5 ; repquota -a | grep username
Just replace where it says “username” with the group or username you want to check.
→ No Comments Tags: Cheat Sheets · Cpanel and WHM · Linux Commands · Linux Software / Scripts · Linux Tricks
Using the mysql upgrade option in cpanel will not work with cloud Linux. It’s also a little different than what the Cloudlinux site says.
How to install new package:
1) yum install governor-mysql –enablerepo=cloudlinux-updates-testing
2) /usr/share/lve/dbgovernor/mysqlgovernor.py –install
For upgrading to MySQL 5.5(for example), you should to do:
1) /usr/share/lve/dbgovernor/db-select-mysql –mysql-version=mysql55
2) /usr/share/lve/dbgovernor/db-select-mysql –install-now
3) for cPanel can be needed to rebuild php through easyapache
→ No Comments Tags: Cpanel and WHM · Linux Software / Scripts
update [table_name] set [field_name] = replace([field_name],’[string_to_find]‘,’[string_to_replace]‘);
Make sure and remove the [] tab when entering the variable.
If you know how to do this database wide without needing the table listed please post in the comments.
→ No Comments Tags: Linux Commands · Linux Tricks
Back up a MYSQL database:
Code: ——— mysqldump –opt -Q -u dwhs_dwhs -p dwhs_wrdprss*A* > /home/dwhs/workroom/dwhs_wrdprss1.sql ———
Restore a MYSQL database:
Code: ——— mysql -u dwhs_dwhs -p dwhs_wrdprss*B* < /home/dwhs/workroom/dwhs_wrdprss1.sql ———
→ No Comments Tags: Cheat Sheets · Cpanel and WHM · Linux Commands · Linux Tricks
How to install new package:
1) yum install governor-mysql –enablerepo=cloudlinux-updates-testing
2) /usr/share/lve/dbgovernor/mysqlgovernor.py –install
For upgrading to MySQL 5.5(for example), you should to do:
1) /usr/share/lve/dbgovernor/db-select-mysql –mysql-version=mysql55
2) /usr/share/lve/dbgovernor/db-select-mysql –install-now
3) You will need cPanel to rebuild php through easyapache next to finish the procedure.
→ No Comments Tags: Cpanel and WHM · Installing Linux · Linux Operating Systems · Linux Tricks
/scripts/cpbackup –force
→ No Comments Tags: Cpanel and WHM · Linux Back Up · Linux Commands
This is the free open source ffmpeg installer for cPanel which is installed from a bash shell script. The purpose of this script is to build a video streaming platform in your Gnu/Linux server. So you can start video streaming websites. This script not only installs ffmpeg but also all the corresponding packages.
The following packages will install automatically.
›ffmpeg
›Mplayer
›A52decoder
›Amrnb and Amrwb
›All codecs
›facc and faad2
›Ruby
›flvtool2
›Git
›Mplayer
›Lame
›Libogg
›Libvorbis
›Libtheora
›Libwmf
›opencoreamr
›vorbistools
›X264
›MP4Box
›Xvidcore
›Yasm
How to FFmpeg on a cPanel server:
cd /usr/local/src wget http://mirror.ffmpeginstaller.com/old/scripts/ffmpeg7/ffmpeginstaller.7.4.tar.gz tar -zxvf ffmpeginstaller.7.4.tar.gz cd ffmpeginstaller.7.4 ./install
You can get more details here: http://ffmpeginstaller.com/
→ No Comments Tags: Cpanel and WHM · Linux Drivers · Linux Software / Scripts · Linux Tricks
It’s really easy to test your CGI (or a perl script) by adding a test.cgi script with the permissions: 755
Just make sure there is no white space on the top or bottom of the file and the file only has exactly what’s show below. Make sure the name is test.cgi and put in your main folder. Then go to www.your-main-domain.com/test.cgi
#!/usr/bin/perl # hello.pl -- my first perl script! print "Content-type: text/html\n\n"; print <<"EOF"; <HTML> <HEAD> <TITLE>Hello, world!</TITLE> </HEAD> <BODY> <H1>Hello, world!</H1> </BODY> </HTML> EOF
→ No Comments Tags: Cheat Sheets · Cpanel and WHM · Linux Security · Linux Software / Scripts · Linux Tricks
You just need to log in with root and run this command:
ffmpeg -version→ No Comments Tags: Cpanel and WHM · Linux Commands · Linux Drivers · Linux Tricks
