Life as I see it

Because it is New Year and one of my client asked me if I have updated the dev server to the svn version of VICIDIAL 2.2.0. I finally had time to do it. So off I go updating from VICIDIAL 2.0.5 to the new one. It is quite easy to update but I hit some horrifying bloopers.

So here’s what I did and the bloopers that came with it.

I checked out the svn version but first because vicidialNOW doesnt have subversion installed I installed it first.

yum install svn
Reading repository metadata in from local files
Parsing package install arguments
Nothing to do


It didn’t work

so I barely remembered that svn is called subversion so I tried it once again.

yum install subversion

Oh yes it worked! Now off I go downloading the SVN version of VICIDIAL 2.2.0

[root@vici ~]# svn checkout svn://svn.eflo.net:43690/agc_2-X/trunk
svn: Can't connect to host 'svn.eflo.net': Connection refused


Nice eh? so I talked to Matt Florell the developer of VICIDIAL and he told me there’s a problem with it so I just have to use the svn port 3690. It worked. I got the SVN version.

Here’s the correct one.

svn checkout svn://svn.eflo.net:43690/agc_2-X/trunk

Once the server is done downloading the files. I typed:
perl install.pl
Pressed enter a lot of time and then its done installing the scripts needed. After its done I then type:

mysql -uroot -pmysuperdupersecretpassword asterisk

I got into the mysql server and did the upgrade, here’s the command:

\. /the/directory/where/you/put/2.2.0/trunk/extras/upgrade_2.2.0.sql

It went to the usual stuff and VIOLA! It’s done!

Here comes the scary part.

I logged in to the VICIDIAL admin interface. I tried using my credentials and it didn’t work. So I checked the mysql database. I found the user =”admin” with the password. I tried it again, it didn’t work. Due to massive intake of sweets Im quite hyperactive at that time (even now that I am writing this post after an hour). So I looked at the /etc/astguiclient.conf, and this is what made me almost lose it.

# The IP address of this machine
VARserver_ip => 10.10.1.2

# Database connection information
VARDB_server => 10.10.1.3
VARDB_database => asterisk

I panicked, I asked dumb questions to Matt. Here’s the conversation and sorry for my english .

me: I think i made a mistake I thought I was updating my single server then all of a sudden my astguiclient.conf is pointing to another mysql server will the database be corrupted?

Matt: I have no idea, don’t know your setup
I wouldn’t think it would cause that bad of a problem
you did ADMIN_backup.pl before your upgrade right?

me: oh so 2.0.5 agc and vicidial php scripts will still work on the new database?

Matt: no

me: oh so it will have problems?

Matt: I don’t think it will work at all actually

Now that’s a shock. I am doomed . I am actually in a panic. I told my client that I think made a mistake. I was thinking how to revert the database to its old glory and I found nothing. I lighted a smoke and logged in to the mysql, and press up arrow. It showed this:

[root@vici ~]# mysql -uroot -psupersecretpassword asterisk
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 695
Server version: 5.0.77 Source distribution

mysql>\. /the/directory/where/you/put/2.2.0/trunk/extras/upgrade_2.2.0.sql


Common sense broke to my brain and finally figured that install.pl DIDN’T TOUCH THE DATABASE! PFFFT!!!!!! So I changed the config at /etc/astguiclient.conf to make sure that it is connecting to localhost and not to other servers. I thought I caused a massive profit loss due to the downtime. Good thing I learned something from it though.

Here’s what I learned:

1) Dont ever reconfigure anything if you are hyperactive, or drank a lot of coffee or coke.

2) Read everything you see on your screen.

3) Dont assume anything.

4) Back up everything if you are upgrading something.

5) READ THE UPGRADE DOCUMENT

Also here’s a comment from Matt:

Matt: nice
you should mention:
“read the UPGRADE doc!!!”
me: hahahaha
Matt:
Matt:
there are several little things in there that need to be done during an upgrade, but it is also really important that the person doing the upgrade understands all of the things that are changing by doing the upgrade.

You can say this is basic to all the tech people but I think I somehow forgotten about it.