[Command]# cat /etc/redhat-release ...
Wednesday, December 28, 2011
How to change SSH port on Centos,Ubuntu,Debian
Keeping the default 22 SSH port is really not a good practice. I had seen many people do not bother about changing their SSH port even they configured many security features.
This article applies for Ubuntu/Debian/Centos/Redhat O/S
Note- Mess with others things on SSH config file is really harmful and it may lock your server from accessing via SSH. So you will need console access to reset SSH or contact server provider to do this. So do with your own risk!
Steps
Use NANO editor for edit files or vi editor. If you dont have NANO installed...
Tuesday, December 27, 2011
Asterisk as a SIP client
In sip.conf under [general] add a register definition:
Format:
register => user[:secret[:authuser]]@host[:port][/extension]
or
register => fromuser@fromdomain:secret@host
or
register => fromuser@fromdomain:secret:authuser@host:port/extension
Example1:
register => username:pwd:username@216.144.238.155/extension
; Register 2345@mysipprovider.com with authname 2345 at mysipprovider.com at sip provider as 1234 here:
register => 2345:password@mysipprovider.com/1234
; Register 1235@mysipprovider.com with authname 1235 and...
Asterisk configuration templates
Templates are a means to avoid repetitive sections in Asterisk configuration fileslike extensions.conf, sip.conf or iax.conf. Templates are not to be confused withmacros in extensions.conf.For template configurations, the syntax for defining a section is as follows: [section](options)label = valueThe options field is used to define templates, refer to templates and hidetemplates. Any object can be used as a template.No whitespace is allowed between the closing "]" and the parenthesis "(". Adding to an existing section(this is actually not template-related,...
Monday, December 26, 2011
Change the Linux User Root Password
su to root Type "passwd" (without quotes) It will then prompt you to type your new pass, and then to confirm it. ...
Wednesday, December 21, 2011
How to Reset forgotten root password on Centos/Red Hat
If you are desperate because you have forgotten root password, don’t be. This tutorial will show you how to reset root. Please note that you cannot perform this remotely, you must be physically at the machine. 1. Step : Reboot The Server 2. Step : Look for the centos blue screen saying booting press DOWN arrow key ...
Repairing a Corrupted Database in MYSQL
[root@123]# mysqlcheck --auto-repair --databases database-name -uUser -pPass (for {INNODB} and MYSQL service should be running) And [root@123]# myisamchk /var/lib/mysql/database-name/*.MYI ( for {MyISAM} and MYSQL service should be stopped) ...
Sunday, December 18, 2011
HOW TO CHANGE NAME OF AUTHOR in Blogger
1.Log in to your dashboard--> template- -> Edit HTML 2.Click on "Expand Widget Templates" 3.Scroll down to where you see this:<span class='post-author vcard'><b:if cond='data:top.showAuthor'><data:top.authorLabel/><span class='fn'><data:post.author/></span></b:if></span> 4.Replace <data:post.author/> of above code with your new name. 5.Click on "Save Templates" and Refresh your site....
Friday, December 16, 2011
Dialplan that will act as a plug-in replacement for AgentCallbackLogin
This is a sample dialplan that will act as a plug-in replacement for AgentCallbackLogin for Asterisk 1.6's. It offers the following features: - Single log-on and log-off, managing queue/agent associations centrally - Agent pause (with pause reason) and unpause - Managed device state - the queue will not try calling members that are busy on other queues or because of other calls - Tracking of the current hot-desk extension - Fully compatible with QueueMetrics - Very compact and easy to expand It requires Asterisk...
Friday, December 9, 2011
Multiple Logins In Windows Live Messenger
The support for multi-WLM is not enabled by default, but can be easily turned on and enable with registry hack. Run Registry Editor (regedit). Navigate to the following registry key: KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows Live\Messenge For 64-bit (x64) OS, go to following registry branch instead: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows Live\Messenger In the right pane, right click on any blank space, select New on context menu, and then click on DWORD (32-bit) Value. Name the...
Thursday, December 8, 2011
Adding User Accounts in MYSQL
CREATE USER 'sam'@'localhost' IDENTIFIED BY 'some-password'; GRANT ALL PRIVILEGES ON *.* TO 'sam'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; (telling the server to reload the grant tables using flush command) The accounts created by these statements have the following properties: Two of the accounts have a user name of sam and a password of some_pass. Both accounts are superuser accounts with full privileges to do anything. The 'sam'@'localhost' account can be used only when connecting...
Monday, December 5, 2011
Exporting Table Data in a File
SELECT * FROM table_name INTO OUTFILE 'C:/new_file.xls' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; ...
Friday, December 2, 2011
Remote UNIX connection
If getting an error in asterisk cli (1.6.1.8) -- Remote UNIX connection -- Remote UNIX connection disconnected -- Remote UNIX connection -- Remote UNIX connection disconnected -- Remote UNIX connection -- Remote UNIX connection disconnected -- Remote UNIX connection -- Remote UNIX connection disconnected -- Remote UNIX connection -- Remote UNIX connection disconnected -- Remote UNIX connection -- Remote UNIX connection disconnected then use the following command in asterisk cli cli>core set verbose 0 ...
Thursday, December 1, 2011
SHOW CREATE TABLE displays the CREATE TABLE statement to create a given table.
Shows the CREATE TABLE statement that creates the given table. The statement requires the SELECT privilege for the table. As of MySQL 5.0.1, this statement also works with views. mysql> SHOW CREATE TABLE tablename ...
check directory/dir/file size in linux
#check partition sizes df -h
#check directory size du -s -h /var/log/
#check every directory and file sizes under a dir.
du -s -h /var/log/*
#check individual size size du -s -h /var/log/lastlog...
Send Mail from CLI (LINUX)
mail -s .ANY SUBJECT. emailid@gmail.com => return Key body message here => ctrl+d for CC return key to check the logs: cd /var/log tail -100 maillog ...
Change the system date in Linux
Set the current date to May 7 2011 8:42:45pm.#date -s "7 May 2011 20:42:45" ...
Asterisk updating from 1.6.1.8 to 1.6.2.19
wget http://pkgs.fedoraproject.org/repo/pkgs/asterisk/asterisk-1.6.2.19.tar.gz/5dfb9352bacfa7f4dc2ef72cb83715c2/asterisk-1.6.2.19.tar.gz tar -zxvf asterisk-1.6.2.19.tar.gz cd asterisk-1.6.2.19 ./configure make make install (Do not delete G729 module) asterisk -vvvgc asterisk -vr http://www.blog.manhag.org/2010/05/installing-the-free-g729-codec-for-asterisk/ Download from here: (Depend on 32bit or 64bit)["i686" means 32-bit. If it was 64-bit, it would be "x86_64"] Check by "uname -a" command wget http://asterisk.hosting.lv/bin/codec_g729-ast14-gcc4-glibc-pentium.so...
How to Compile Asterisk module like (app_Voicemail.c)
First :
At starting of the file add this lines
#ifndef AST_MODULE
#define AST_MODULE "app_voicemail"
#endif
AFTER THAT COMPILE THE MODULE
cd /usr/src/asterisk-1.6.1.8/apps/
gcc -shared app_voicemail.c -o app_voicemail.so
cp app_voicemail.so /usr/lib/asterisk/modules/
CLI> restart ...
MYSQL Packet too large
go to /etc/my.cnf If you are using MySQL 4.0 or newer, enter: [mysqld] # Allow packets up to 16M (change its value) max_allowed_packet=16M If you are using an older version of MySQL, enter: [mysqld] # Allow packets up to 16M set-variable = max_allowed_packet=16M To store 8 MB objects (default is 16M)....
LoopProtection in OTRS
Go to Admin-> Sysconfig-> search for PostmasterMaxEmailsLoopProtection!!! Send no more emails to 'emailid@.com'! Max. count of 40 has been reached! PostmasterMaxEmails 40 Default Change its value from 40 to whatever you want...
[otrs] State change New to Open
To add the option on NOTE for changing the state of ticket, go to: Frontend::Agent::Ticket::ViewNote Then --> Ticket::Frontend::AgentTicketNote###State: "YES" --> UpdateAfter adding this, you will have the otion to change the state of a ticket under notes. ...
Check Size of Database [in MB]
Run the below command SELECT table_schema "Data Base Name", sum( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ; ...
Setting for MYSQL replication in my.cnf
In /etc/my.cnf server-id=2 replicate-same-server-id = 0 auto-increment-increment = 2 auto-increment-offset = 2 replicate-do-db = databasename ...
Trouble Shooting MySQL Replication.
Mysql> Show slave status; Above command will show the status of replication. we see two column -- value for both should be 'Yes'. a. SlaveIORunning -- 'Yes' b.SlaveSQLRunning --'Yes' Incase of replication failure value for the columns will be 'No'. If value is 'No' look for the error. Note the logfile and logposition being read. Stop slave. First Diagnose error and resync replication from the log position it broke. ...
Maintenance of Replicated Mysql Server
Deleting Binlogs of mysql. -----> Log into Secondary Server mysql> show slave status; Above command will give the file name being read by slave machine. Go to master and execute---> mysql> purge binlogs to 'file_name_got_from_above_command' In case of master to master replication we have to delete binlog from both machines. Do the same as above on both machines. ...
Complete Master to Slave MySQL DB Replicate
My.ini/My.cnf configuration for Master ------------------------------- log-bin=mysql-bin server-id=1 -------------------------------- INNODB Specific options -------------------------------- innodb_flush_log_at_trx_commit=1 sync_binlog=1 -------------------------------- Restart MySql Service FLUSH PRIVILEGES; ----------------------------------------- mysql>USE exampledb; mysql>FLUSH TABLES WITH READ LOCK; Take a backup (or MYSQLDUMP) of the DB to be replicated Restore DB on Slave **************************************************...
Subscribe to:
Posts (Atom)
