April, 2012
Set PHP configuration options in Apache using directives
Apache directives to change the PHP configuration: php_value name value Sets the value of the specified directive. php_flag name on|off Sets a boolean configuration directive. php_admin_value name value Sets the value of the specified directive. This can not be used in .htaccess files. php_admin_flag name on|off Used to set a boolean configuration directive. This can [...]
Install development tools and kernel headers for Fedora
Development Tools Installation yum groupinstall ‘Development Tools’ Kernel headers Installation yum install kernel-devel kernel-headers or yum install kernel-devel-$(uname -r) kernel-headers-$(uname -r)
CentOS SSH Server Installation
You need to install the following package: su – yum -y install openssh-server Start the service chkconfig sshd on service sshd start
Remote Desktop Support in CentOS
Remote Desktop Support Become root su – Installation yum install vino Setting up Remote Desktop Access Goto System->Preferences->Remote Desktop and enable these settings on the remote desktop window preferences: 1. Allow other users to view your desktop. 2. Allow other users to control your desktop. 3. Require the user to enter this password: your_password 4. [...]
How do I find out the MAC address of my Linux system?
I know that is something common but people keep questioning me about how to get the ethernet mac address on their linux system. So, here it is. Issue the following command: ifconfig eth0 | grep HWaddr
QR code
QR Code (Quick Response Code) is two dimensional code which is categorized in matrix code. The code consists of black modules arranged in a square pattern on a white background. The information encoded can be made up of four standardized kinds of data (numeric, alphanumeric, byte/binary, Kanji). The QR Code was designed for high speed [...]
Retrieve useful information from SQL Server
Today we will see how can we retrieve various information from Microsoft SQL Server using SQL queries. Get all users: SELECT * FROM sys.server_principals; Get database size: USE master GO EXEC sp_spaceused Get user privilleges for current database: USE master GO SELECT SYSOBJECTS.name AS ‘objectname’, SYSUSERS.name AS ‘username’ , Action = CASE SYSPROTECTS.action [...]
Check Status of Linux Service
To check if a local Linux service is running or not, open terminal window and paste the following command: /etc/init.d/service_name status for example /etc/init.d/apache2 status
Create your own online radio stream in Ubuntu
Installation sudo apt-get install icecast2 sudo apt-get install ices2 Ices2 installation ask you to join DecNet choose the third choise to skip configuration. Icecast Configuration Open a terminal window and issue the following command: sudo gedit /etc/icecast2/icecast.xml We are going to change the source and the admin password. Locate authentication section (‹authentication›) in xml [...]
Calculate MySQL Database size
Today we will see how we can retrieve MySQL database size. All databases: SELECT table_schema "Database", SUM( data_length + index_length) / 1024 / 1024 "size in MB" FROM information_schema.TABLES GROUP BY table_schema ; Specific database: SELECT table_schema "Database", SUM( data_length + index_length) / 1024 / 1024 "size in MB" FROM information_schema.TABLES WHERE table_schema=’information_schema’;