Koozali.org: home of the SME Server

Obsolete Releases => SME VoIP (Asterisk, SAIL etc) => Topic started by: compsos on August 22, 2013, 02:09:44 AM

Title: Strategy column missing from route table
Post by: compsos on August 22, 2013, 02:09:44 AM

Hi Jeff
After updating to 3.1.1.39 we could not dial out. Do not know about in.

In the cli we had errors about

Code: [Select]

sarkhpe,OutRoute,wdp1,,: Database Prepare failed, retval is 1, query is SELECT auth,path1,path2,path3,path4,alternate,strategy FROM Route WHERE pkey='wdp1'
Running the query from the console showed the following

Code: [Select]

# sqlite3 sark.db "SELECT auth,path1,path2,path3,path4,alternate,strategy FROM Route WHERE pkey='wdp1'"
Error: no such column: strategy
without 'strategy'

Code: [Select]

# sqlite3 sark.db "SELECT auth,path1,path2,path3,path4,alternate FROM Route WHERE pkey='wdp1'"
NO|61740840650|61740580623|61990180256|DAHDIGroup5|
We have added the added the column. It appears 'strategy' is normally used in queues (ie) ringall. Please advise if we should modify somewhere else and return DB to normal.

Thanks

Title: Re: Strategy column missing from route table
Post by: SARK devs on August 25, 2013, 06:41:14 PM

HI

The strategy column was added to the routes table in 3.1.1-29.   You will (or should) find the SQL fragment in /opt/sark/amacs/r1997.  Please check that this fragment exists in your release.  If it does not then we may have a problem with the rpm.   

You can leave the strategy you added manually as long as you defined it as TEXT.

Kind Regards

S

 

   

Title: Re: Strategy column missing from route table
Post by: compsos on August 25, 2013, 11:52:02 PM

Hi Jeff
Yes the SQL statement is there but what should have fired it off as the column was not in the DB

Code: [Select]

ALTER TABLE route ADD COLUMN strategy TEXT;

Title: Re: Strategy column missing from route table
Post by: SARK devs on August 26, 2013, 02:24:26 PM

When the rpm runs it should run a script called updatedb.sh which you will find in /opt/sark/scripts.     The script is idempotent (now there's a word that tells me I should get out more), it simply means that you can run the script as often as you like without breaking anything..

Code: [Select]

sh /opt/sark/scripts/updatedb.sh
It will generate lots of error messages - but in this case, that's a good thing.

Kind Regards

S

Title: Re: Strategy column missing from route table
Post by: compsos on August 27, 2013, 01:53:22 AM

Hi Jeff
Yes to get out is a good idea. Actually leaving today for Switzerland but can you turn on some better weather!!!

The link is sh /opt/sark/scripts/update_db.sh with the underscore. But why would it not have run during the 3.1.1-27 to 3.1.1-39 or left out the column? The console sql statements show that it was not there.

Thanks