|
|
In case you happen to forget the root password, here is what you do to reset it.
[sql-serv]# service mysqld stop
[sql-serv]# mysqld_safe –skip-grant-tables &
This will start MySQL without asking you for any password. Once started and you’re on MySQL CLI, you can update the root password:
mysql > UPDATE user SET Password=PASSWORD(‘new-password-here’) WHERE User=’root’;
mysql > flush privileges;
mysql > exit
Now you can start MySQL as normal.
service mysqld start
Try to login with your new password
mysql -uroot -pnew-password-here
1 person likes this post.
Unlike
How to install opensips in a Red Hat Enterprise Linux 5 server with mysql
How to install opensips 1.5 in a Red Hat Enterprise Linux 5
platform with Mysql Support.
The following document will guide you thru the installation
of the newly released opensips vesion 1.5 in Red Hat Enterprise
Linux 5.3 along with mysql. I will divide this process in 2 phases
1.- Installation of Red Hat Enterprise Linux 5.3
2.- Installation and configuration of Opensips, webmin and mysql
The following components and paramenters will be used for the purpose
of this installation guide, securing your opensips environment is
beyond this installation guide,
-Red Hat Enterprise Linux Server release 5.3 (Tikanga), 2.6.18-128.1.6.el5
-mysql-server-5.0.45-7.el5.i386
-An HP DL380 3.20 2gb of RAM
-Fully Qualified Domain Name of the server will be simulacro.sipcorner.com
-IP address of the server 10.10.10.101
1.-Installation of Red Hat Enterprise Linux 5 (Phase 1)
Let’s Proceed to install Red Hat Enterprise Linux 5
-Proceed to Insert the RHEL 5 DVD in your server
At the RHEL boot screen “press enter”
The system will ask you to either test the media or skip the media test,
I personally choose to skip the media since I know the integrity of the DVD
is good, but if you have doubts about the integrity of your media I will
suggest you to continue with the media test.
-At the RED HAT ENTERPRISE LINUX 5 initial Install screen select NEXT
-Proceed to select the language, I selected English(English)
-Proceed to select the appropriate keyboard for the System, I selected
U.S. English
-Proceed to enter the Red Hat installation number and select OK
-Select to Install Red Hat Enterprise Linux Server, then select OK
-Because I have RHEL 5 currently installed in my Hard Drive, and I
want to install a new copy of RHEL 5, the system will now asked me if
I want to remove all linux partitions on the selected drives and create a default
layot, since I want to do this, I will simply select the NEXT button
-As a precaution, the system will asked me if I really want to remove all the
existing Linux partitions in the Hard Drive, Since i want to do this I select
the Yes button.
-The system will now asked to configure the ethernet0 interface, since I want
the system to have an static IP address, I select the eth0 interface and I
select EDIT.
-The EDIT Interface screen will open, and I will now proceed to enter my network
information manually, then select OK, next I proceed to enter the FQDN for this
server, for example simulacro.sipcorner.com, next I will proceed to continue
entering my network information, such as my gateway, primary DNS and Secondar
DNS servers, then I will proceed to select the NEXT button
-Proceed to select your timezone accordinally
-Proceed to enter a Password for the Root Account
-Red Hat Enterprise Linux 5 default installation includes a set of software
applicable for general internet usage, although you can choose to install
additional components, such as servers and others, for the purposes of this
document, I will proceed to check the Web Server option and also I will proceed
to check the Customize now option, then I will select NEXT.
-Because I checked the customize option, I am now being presented with [...]
 Facebook reminder app – User Interface
It was quite challenging, but I managed to convert this into a facebook app. It was challenging due to poor documentation at facebook how to make facebook apps, and obsolete tutorials and blogs on this subject, since facebook has updated their apps api in June 2010.
Anyways, now the reminder service is there, up and running. If you have a facebook account, all you need to do is search for ‘reminders’, and it’ll show you a reminders app with a telephone icon as follows:
Just click it, and it’ll ask you that the app wants your basic info and your email address. Accept it, and you are all setup to use the reminder app.
Or even simpler, just click the app screenshot above and it’ll take you to facebook and install the app for you, if you gave it permission to do so.
The interface is simple to use, made in JavaScript, very user friendly.
All the items are self explanatory, along with a help icons which tell you how to use the associated fields.
As a new user, $10 are added to your account. You have to register your phone numbers where you would like to receive the reminder calls.
Give it a try and I am sure you’ll find it a very useful app. Just a note, that the phone reminder part is good only for North America. Rest of the world can use only email reminders. Based on demand, I’ll see if I can open the International routes to certain countries.
3 people like this post.
Unlike
It is very annoying that almost all the answers on how to enable telnet root access on a Linux server are like, ‘why you want telnet access, don’t use it, use ssh, telnet is insecure’. Thank you very much but I know that already, and I also know why I need telnet root access.
Anyways, if you need to access your CentOS server via telnet and as root user, here is what you do:
yum install telnet-server
service xinetd restart
Next, edit /etc/pam.d/remote file and comment out the first line, i.e.
#auth required pam_securetty.so
And this is all. Now you can telnet into your server as root user.
Like
Unlike
This was a little bit tricky, but thanks to the power of the freely available (though hard to find sometimes) knowledge on the Internet, and Google’s searches, I just finished this task and thought to write a blog about it. Though the following is for advance users only.
On a server running Proxmox VE with a few instances of CentOS 5.2, each with asterisk and other related stuff, and network interface 192.168.91.1/24, a colleague of mine wanted to hook up two extensions. The problem was that he was at 10.18.0.10/16, though on the same switch as the Proxmox server. There were no routers involved.
Those of you who know Proxmox, know that its network interface is a bridged interface and ifconfig shows it as vmbr0. The Asterisk server instance itself was at 192.168.91.13.
So what I did was as follows:
Assigned a new virtual IP address to vmbr0 to match my colleague’s network:
ifconfig vmbr0:0 10.1.18.1 netmask 255.255.0.0 up
Next, created the following iptables rule, to direct all the traffic on this new interface, coming from 10.1 network to the asterisk server at 192.168.91.13
iptables -A PREROUTING -t nat -i vmbr0 –source 10.1.0.0/16 \
-j DNAT –to-destination 192.168.91.13
And that was it. Now he could point his extensions to 10.1.18.1 to get to the asterisk server. SIP registrations and media all worked well with these settings. At this time I also learned something new, that in Windows XP Pro, you could have multiple IP addresses assigned to the same NIC. So I assigned my workstation a 10.1 address, and was able to reach the same asterisk server using both the IP addresses, without a need to disconnect any of my ssh sessions, and praise the age of amazing technologies we live in.
Like
Unlike
SNMP – Simple Network Monitoring Protocol, as it name suggests, is a protocol used to monitor various properties of network equipment. These properties are identified by something called OIDs (Object Identifiers) which are long numeric strings and identify various things, like hardware version, time on the device, data flow rate, and tons of other stuff.O OIDs and grouped in what is called a MIB (Management Information [...]
If you have a busy system, the activity output on the Asterisk CLI screen is totally useless. It scrolls so fast with so much information that you really can’t make sense of anything you see on the screen, and there is no way to limit this information to only to certain important commands and outputs which you really care about for your system. So then how to troubleshoot a call on such a system.
By default Asterisk stores call activity log in folder /var/log/asterisk either in file named messages or file named full. As the name suggests, the full file has more detailed record, and this is what we shall consider for the purpose of this blog.
This file can be hundred of mega byte in size based on how busy your system is. In order to analyze the contents of this file for a particular call, first of all what you need to do is to find the session id for that call. If you carefully note on the What you need to do for troubleshooting purposes is to extract a single call from it in a separate file and and then analyze it.
Consider the following example. Today a client of mine called regarding some issue calling a particular number. We shall assume the number was 7055623000. Now for my particular dial plan, which is very complex, but because I have personally hand coded it all from scratch, I know every line of it. So I would know where a particular call starts and how the dial plan flows. But even if I won’t, I would ask the client for:
The number the client was having trouble with
The time when the client was having this trouble.
When you have the number, i.e. 7055623000 in this case and you know the time of problem was around 11:40, open the log file in a text editor or viewer and search for this number. In my dialplan it would look something like following:
[2011-02-24 11:40:15] VERBOSE[13102] logger.c: — Executing [7055623000@outbound:1] SetGlobalVar(“SIP/200.10-b6b41328″, “CALL_DIRECTION=OUT”) in new stack
[2011-02-24 11:40:15] VERBOSE[13102] logger.c: — Executing [7055623000@outbound:2] Set(“SIP/200.10-b6b41328″, “userid=”10″”) in new stack
[2011-02-24 11:40:15] VERBOSE[13102] logger.c: — Executing [7055623000@outbound:3] NoOp(“SIP/200.10-b6b41328″, ” – - – Incoming CID is 0 – - – “) in new stack
[2011-02-24 11:40:15] VERBOSE[13102] logger.c: — Executing [7055623000@outbound:4] GotoIf(“SIP/200.10-b6b41328″, “1?5:7″) in new stack
[2011-02-24 11:40:15] VERBOSE[13102] logger.c: — Executing [7055623000@outbound:5] Verbose(“SIP/200.10-b6b41328″, ” – - – Changing caller id for outbound call – - – “) in new stack
[2011-02-24 11:40:15] VERBOSE[13102] logger.c: — Executing [7055623000@outbound:6] Macro(“SIP/200.10-b6b41328″, “set_callerid|200″) in new stack
[2011-02-24 11:40:15] VERBOSE[13102] logger.c: — Executing [s@macro-set_callerid:1] Set(“SIP/200.10-b6b41328″, “ext=200″) in new stack
[2011-02-24 11:40:15] VERBOSE[13102] logger.c: — Executing [s@macro-set_callerid:2] NoOp(“SIP/200.10-b6b41328″, “_______________________________________________________________________________________________”) in new stack
[2011-02-24 11:40:15] VERBOSE[13102] logger.c: — Executing [s@macro-set_callerid:3] NoOp(“SIP/200.10-b6b41328″, ” S E T C A L L E R I D A N D N A M E [...]
Few days ago I got this nasty error from MySQL for one of my Piwik’s tables:
SQLSTATE[HY000]: General error: 145 Table ‘./piwik/log_link_visit_action’ is marked as crashed and should be repaired
It was the first time that I dealt with this type of situation, and thought mention the fixing procedure here for those facing similar issue.
Basically any corrupted MySQL table can be fixed using this procedure.
One cause of this error is the disk hitting 100%, so use df and du -sk / to try and figure out where your clogs are.
Now using the mysql> prompt and run the following:
check table <table_name>;
This will show you the error message.
Now go back to the Linux command prompt and issue the following command:
myisamchk -r /var/lib/mysql/<database_name>/<table_name>.MYI
This will, in most cases, will fix the corrupted table, and you’ll be back on the track.
Like
Unlike
A phone reminder is a reminder which is sent to you over the phone. It amazingly makes various things in your life more manageable which otherwise would stay mismanaged because you simply forget about them. Life is busy for everyone in this age, and with so much going on, it is very easy to forget many important tasks and chores.
VisionVoIP is one of the very few providers of this wonderful service, through a very simple, easy to use and user friendly interface. I use it on daily bases, and am kind of addicted to it. I have setup various monthly, daily and weekly reminders on it which I receive via phone, email and text messages. Anything which I consider important, I immediately make a reminder of it at VisionVoIP. It is kind of my personal assistant which keeps track of my schedule.
This service from VisionVoIP is not very well known yet, and it’ll take time until it gets recognized, unless Angelia Jolie or Megan Fox start using it, and make it famous more quickly.
Here I shall describe how their wonderful service works.
Sign Up
First of all you sign up, as you would for any service. It is pretty simple, quick and painless process. You click on the ‘Register’ link on top right corner of the page, it’d pop up a dialog box and ask for your email address and timezone. Time zone is important, otherwise your reminders will not be sync with your real time.
VisionVoIP Telephony Services – Registration
Registering your phone numbers
For security purposes, by default this service doesn’t allow to receive reminders on any number. Otherwise a spammer can type in your number and spam you with unwanted messages. There can be other misleading calls generated to people not sign up to receive these calls. So it is important that you register the numbers where you want to receive your reminder calls.
Its a simple two step process which you do in your ‘Profile’, by clicking on the Profile link on top right of the screen. This will pop-up your profile information. Here click on the link [Add a new number]. Now the screen will look like following:
VisionVoIP’s Phone Reminder service – Phone registration dialog
As you can see here, at the very bottom it gives you a field to enter your phone number and click on the ‘Get Validation Code’ button. How it works is that you enter a valid 10 digit North American number in this field, and click on this button. In a few seconds you receive a call on this number, and it tells you a 4 digit validation code, something like 1348. In the meanwhile on this screen, your number is appeared in front on the Phone Numbers title, with a field to enter your validation code, and click Register. See the screen shot below:
VisionVoIP’s Phone Reminder service – Dialog box for registering a phone number
Once registration is successful, the number will be added to the registered phone numbers list.
If for any reason [...]
 I was having this trouble with myl Droid/Milestone smart phone from Telus, and the Telus client care was not able to fix it. When I searched the Internet I found out that it was a well known and common bug effecting a lot of Android users. What happens is that apparently because of no reason you start getting message on your device saying “Running out of disk storage space” whereas there is tons of space available both for system internal storage and for other purposes. Deleting apps and other stuff doesn’t help taking this message away.
The side effect of this bug is that some apps stop working. In my case the text messaging would stop working, i.e. i won’t be able to receive any text messages. Some HTC users have also noticed similar problem.
Official answer to solve this problem is very ridiculous and Microsoftic, i.e., as you might have already guessed, format your system. Apparently these answer providers have came from the Windows background and don’t know in the Linux world we don’t format our systems, we fix them. In fact in the Linux world very few people actually know at all how to format a system, because we simply never need to do this. And as a side note, we don’t even reboot our Linux systems. They are started once, and thats it. Rebooting is again a necessity introduced by Microsoft, due to their poorly designed Windows kernel.
Anyways, what I have found so far helpful, which worked for me, is to unmount the SD card and reboot the phone. in this case rebooting is required because there is no option in Android to mount the SD card again. Rebooting mounts it again and the error message is gone, and the text messaging starts to work.
To unmount it, go to Settings->SD card & phone storage->Unmount SD card.
Those who really want to, and can afford to format the system, go to Setttings->Privacy->Factory data reset.
5 people like this post.
Unlike
|
|
Recent Comments