Topic: V3.0 PCI Initialise / Regen DB Failure

[kevlime]

Migrated from SME 7.5 and Sail 2.5,  followed Docs for upgrade all goes fine and database migration from V2 scripts runs, first step detection regen/init of PCI cards works ok but on doing the commit results in following error message:

DBD::SQLite::db do failed: table lineIO has no column named channel(1) at dbdimp.c line 271 at /usr/lib/perl5/site_perl/sark/SarkSubs.pm line 1147, <IN> line 9

Have tried removing sail V3 and /home/sark/db and reinstalled with signal-event post-upgrade ;signal-event reboots.

Software Versions
SME 8b5 uptodate
Sail 3.0.0.36 



PCI Cards Detected
usb:001/002          xpp_usb-     e4e4:1151 Astribank-multi USB-firmware
pci:0000:06:00.0     wctdm+       e159:0001 Wildcard TDM400P REV E/F

/etc/dahdi/system.conf
# Autogenerated by /usr/sbin/dahdi_genconf on Sat Jul 17 12:35:28 2010
# If you edit this file and execute /usr/sbin/dahdi_genconf again,
# your manual changes will be LOST.
# Dahdi Configuration File
#
# This file is parsed by the Dahdi Configurator, dahdi_cfg
#
# Span 1: WCTDM/4 "Wildcard TDM400P REV E/F Board 5" (MASTER)
fxsks=1
echocanceller=mg2,1
fxsks=2
echocanceller=mg2,2
fxsks=3
echocanceller=mg2,3
fxsks=4
echocanceller=mg2,4

# Global data

loadzone   = us
defaultzone   = us


/etc/dahdi/dahdi-channels
; Autogenerated by /usr/sbin/dahdi_genconf on Sat Jul 17 12:35:28 2010
; If you edit this file and execute /usr/sbin/dahdi_genconf again,
; your manual changes will be LOST.
; Dahdi Channels Configurations (chan_dahdi.conf)
;
; This is not intended to be a complete chan_dahdi.conf. Rather, it is intended
; to be #include-d by /etc/chan_dahdi.conf that will include the global settings
;

; Span 1: WCTDM/4 "Wildcard TDM400P REV E/F Board 5" (MASTER)
;;; line="1 WCTDM/4/0 FXSKS"
signalling=fxs_ks
callerid=asreceived
group=0
context=from-pstn
channel => 1
callerid=
group=
context=default

;;; line="2 WCTDM/4/1 FXSKS"
signalling=fxs_ks
callerid=asreceived
group=0
context=from-pstn
channel => 2
callerid=
group=
context=default

;;; line="3 WCTDM/4/2 FXSKS"
signalling=fxs_ks
callerid=asreceived
group=0
context=from-pstn
channel => 3
callerid=
group=
context=default

;;; line="4 WCTDM/4/3 FXSKS"
signalling=fxs_ks
callerid=asreceived
group=0
context=from-pstn
channel => 4
callerid=
group=
context=default

[SARK devs]

This is a bug.

It will be fixed in -16 or -17 however for now you can manually  issue the following command at the Linux console...

Code: [Select]

sqlite3 /home/sark/db/sark.db "ALTER TABLE lineIO ADD COLUMN channel TEXT;"

Type this all in (or better still; copy and paste it) as one long line.

This should fix your problem and allow you to bring your Digium card on-line.

Kind Regards

S

[kevlime]

Thanks for speedy response, applied the table update then tried init/regen/commit sequence failed with issue for missing column channel in IPphone

so added with:

sqlite3 /home/sark/db/sark.db "ALTER TABLE IPphone ADD COLUMN channel TEXT;"

Now Init/Regen Commit sequence is working, now to try some testing.

[SARK devs]

Thanks - let us know how you get on with it

Kind REgards

S

[kevlime]

OK think I have found the next bug.   Each time the Init/Regen sequence is run results in the astribanks port being added incrementally see below now up to 190 extensions it would appear that whilst previously with the DB error they were being added to the database,  I have deleted a few then re Init/Regen it isn't renumbering just adding on another 38 extensions each time although dahdi~_channels.conf and system.conf are the same each time in terms of spans and port numbering.

Let me know what additional info you may require, is there an easy way to do a bulk delete of extensions in V3?

Code: [Select]

SIP/4000 default Communications Grandstream GXP 2000 N/A N/A  Unregistered N/A  Both remote [End-point is Offline]  [Click to Edit]  [Click to Delete]
Analogue/501 DAHDI Ext(FXS) 1 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/502 DAHDI Ext(FXS) 1 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/503 DAHDI Ext(FXS) 2 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/504 DAHDI Ext(FXS) 3 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/505 DAHDI Ext(FXS) 4 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/506 DAHDI Ext(FXS) 5 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/507 DAHDI Ext(FXS) 6 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/508 DAHDI Ext(FXS) 7 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/509 DAHDI Ext(FXS) 8 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/510 DAHDI Ext(FXS) 10 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/511 DAHDI Ext(FXS) 11 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/512 DAHDI Ext(FXS) 12 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/513 DAHDI Ext(FXS) 13 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]

****SNIP SNIP SNIP****


Analogue/658 DAHDI Ext(FXS) 6 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/659 DAHDI Ext(FXS) 7 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/660 DAHDI Ext(FXS) 8 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/661 DAHDI Ext(FXS) 10 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/662 DAHDI Ext(FXS) 11 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/663 DAHDI Ext(FXS) 12 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/664 DAHDI Ext(FXS) 13 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/665 DAHDI Ext(FXS) 14 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/666 DAHDI Ext(FXS) 15 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/667 DAHDI Ext(FXS) 16 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/668 DAHDI Ext(FXS) 17 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/669 DAHDI Ext(FXS) 18 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/670 DAHDI Ext(FXS) 19 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/671 DAHDI Ext(FXS) 20 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/672 DAHDI Ext(FXS) 21 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/673 DAHDI Ext(FXS) 22 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/674 DAHDI Ext(FXS) 23 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/675 DAHDI Ext(FXS) 24 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/676 DAHDI Ext(FXS) 25 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/677 DAHDI Ext(FXS) 26 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/678 DAHDI Ext(FXS) 27 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/679 DAHDI Ext(FXS) 28 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/680 DAHDI Ext(FXS) 29 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/681 DAHDI Ext(FXS) 30 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/682 DAHDI Ext(FXS) 31 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/683 DAHDI Ext(FXS) 32 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/684 DAHDI Ext(FXS) 33 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/685 DAHDI Ext(FXS) 34 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/686 DAHDI Ext(FXS) 35 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/687 DAHDI Ext(FXS) 36 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/688 DAHDI Ext(FXS) 37 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]
Analogue/689 DAHDI Ext(FXS) 38 N/A N/A Analogue N/A [Remote Device is on-line] [Click to Edit] [Click to Delete]

Number of extensions 190
Number Registered 189


[SARK devs]

is there an easy way to do a bulk delete of extensions in V3?

You can delete them using standard SQL

Code: [Select]

delete from IPphone;

Or you could try

Code: [Select]

delete from IPphone WHERE pkey<'514';
Can you tell us what hardware you have please - is it an Astribank channel bank?

also can you do a select * for one of the analogue extensions so we can see the data??

Thanks in advance


Kind Regards

S

[kevlime]

I didn't want to start deleting rows from the db in case of relationships etc and haven't looked at the db structure, so thanks for the prompt reply.


With regard to the hardware the machine has one TDM 400 with 4 FXO  and an Astribank V1 channelbank with 32 FXS ports and ports 9-14 the input output ports.

dahdi_harware -v
usb:001/002          xpp_usb+     e4e4:1152 Astribank-multi FPGA-firmware
 LABEL=[usb:0000138]        CONNECTOR=@usb-0000:00:02.1-1
        XBUS-00/XPD-00: FXS      (14)  Span 1  DAHDI-SYNC
        XBUS-00/XPD-10: FXS      (   Span 2
        XBUS-00/XPD-20: FXS      (   Span 3
        XBUS-00/XPD-30: FXS      (   Span 4
pci:0000:06:00.0     wctdm+       e159:0001 Wildcard TDM400P REV E/F

Ok so deleted all extensions then did Init/Regen/Commit and it added the 38 from the astribank  haven't test anything else.   Then Issued subsequent Init/Regen/Commit and now upto 74 

output of select*

Code: [Select]

sqlite> select * from 'IPphone' ;
501|||DAHDI Ext(FXS) 1|||||||||||||Analogue||1
502|||DAHDI Ext(FXS) 2|||||||||||||Analogue||2
503|||DAHDI Ext(FXS) 3|||||||||||||Analogue||3
504|||DAHDI Ext(FXS) 4|||||||||||||Analogue||4
505|||DAHDI Ext(FXS) 5|||||||||||||Analogue||5
506|||DAHDI Ext(FXS) 6|||||||||||||Analogue||6
507|||DAHDI Ext(FXS) 7|||||||||||||Analogue||7
508|||DAHDI Ext(FXS) 8|||||||||||||Analogue||8
509|||DAHDI Ext(FXS) 10|||||||||||||Analogue||10
510|||DAHDI Ext(FXS) 11|||||||||||||Analogue||11
511|||DAHDI Ext(FXS) 12|||||||||||||Analogue||12
512|||DAHDI Ext(FXS) 13|||||||||||||Analogue||13
513|||DAHDI Ext(FXS) 14|||||||||||||Analogue||14
514|||DAHDI Ext(FXS) 15|||||||||||||Analogue||15
515|||DAHDI Ext(FXS) 16|||||||||||||Analogue||16
516|||DAHDI Ext(FXS) 17|||||||||||||Analogue||17
517|||DAHDI Ext(FXS) 18|||||||||||||Analogue||18
518|||DAHDI Ext(FXS) 19|||||||||||||Analogue||19
519|||DAHDI Ext(FXS) 20|||||||||||||Analogue||20
520|||DAHDI Ext(FXS) 21|||||||||||||Analogue||21
521|||DAHDI Ext(FXS) 22|||||||||||||Analogue||22
522|||DAHDI Ext(FXS) 23|||||||||||||Analogue||23
523|||DAHDI Ext(FXS) 24|||||||||||||Analogue||24
524|||DAHDI Ext(FXS) 25|||||||||||||Analogue||25
525|||DAHDI Ext(FXS) 26|||||||||||||Analogue||26
526|||DAHDI Ext(FXS) 27|||||||||||||Analogue||27
527|||DAHDI Ext(FXS) 28|||||||||||||Analogue||28
528|||DAHDI Ext(FXS) 29|||||||||||||Analogue||29
529|||DAHDI Ext(FXS) 30|||||||||||||Analogue||30
530|||DAHDI Ext(FXS) 31|||||||||||||Analogue||31
531|||DAHDI Ext(FXS) 32|||||||||||||Analogue||32
532|||DAHDI Ext(FXS) 33|||||||||||||Analogue||33
533|||DAHDI Ext(FXS) 34|||||||||||||Analogue||34
534|||DAHDI Ext(FXS) 35|||||||||||||Analogue||35
535|||DAHDI Ext(FXS) 36|||||||||||||Analogue||36
536|||DAHDI Ext(FXS) 37|||||||||||||Analogue||37
537|||DAHDI Ext(FXS) 38|||||||||||||Analogue||38
538|||DAHDI Ext(FXS) 1|||||||||||||Analogue||1
539|||DAHDI Ext(FXS) 2|||||||||||||Analogue||2
540|||DAHDI Ext(FXS) 3|||||||||||||Analogue||3
541|||DAHDI Ext(FXS) 4|||||||||||||Analogue||4
542|||DAHDI Ext(FXS) 5|||||||||||||Analogue||5
543|||DAHDI Ext(FXS) 6|||||||||||||Analogue||6
544|||DAHDI Ext(FXS) 7|||||||||||||Analogue||7
545|||DAHDI Ext(FXS) 8|||||||||||||Analogue||8
546|||DAHDI Ext(FXS) 10|||||||||||||Analogue||10
547|||DAHDI Ext(FXS) 11|||||||||||||Analogue||11
548|||DAHDI Ext(FXS) 12|||||||||||||Analogue||12
549|||DAHDI Ext(FXS) 13|||||||||||||Analogue||13
550|||DAHDI Ext(FXS) 14|||||||||||||Analogue||14
551|||DAHDI Ext(FXS) 15|||||||||||||Analogue||15
552|||DAHDI Ext(FXS) 16|||||||||||||Analogue||16
553|||DAHDI Ext(FXS) 17|||||||||||||Analogue||17
554|||DAHDI Ext(FXS) 18|||||||||||||Analogue||18
555|||DAHDI Ext(FXS) 19|||||||||||||Analogue||19
556|||DAHDI Ext(FXS) 20|||||||||||||Analogue||20
557|||DAHDI Ext(FXS) 21|||||||||||||Analogue||21
558|||DAHDI Ext(FXS) 22|||||||||||||Analogue||22
559|||DAHDI Ext(FXS) 23|||||||||||||Analogue||23
560|||DAHDI Ext(FXS) 24|||||||||||||Analogue||24
561|||DAHDI Ext(FXS) 25|||||||||||||Analogue||25
562|||DAHDI Ext(FXS) 26|||||||||||||Analogue||26
563|||DAHDI Ext(FXS) 27|||||||||||||Analogue||27
564|||DAHDI Ext(FXS) 28|||||||||||||Analogue||28
565|||DAHDI Ext(FXS) 29|||||||||||||Analogue||29
566|||DAHDI Ext(FXS) 30|||||||||||||Analogue||30
567|||DAHDI Ext(FXS) 31|||||||||||||Analogue||31
568|||DAHDI Ext(FXS) 32|||||||||||||Analogue||32
569|||DAHDI Ext(FXS) 33|||||||||||||Analogue||33
570|||DAHDI Ext(FXS) 34|||||||||||||Analogue||34
571|||DAHDI Ext(FXS) 35|||||||||||||Analogue||35
572|||DAHDI Ext(FXS) 36|||||||||||||Analogue||36
573|||DAHDI Ext(FXS) 37|||||||||||||Analogue||37
574|||DAHDI Ext(FXS) 38|||||||||||||Analogue||38

Let me know if you need any further info

[SARK devs]

OK - I think we've found it.

Would you like to try a  patch?

You need to edit /etc/e-smith/web/functions/sarkPCI.   This is the module that creates the hardware hooks.  At or around line 374 you should find the following...

Code: [Select]

."Values ('$pkey','DAHDI Ext(FXS) $targetchan','$technology','$targetchan')" );
You need to change it to...

Code: [Select]

."Values ('$pkey','DAHDI Ext(FXS) $targetchan','$carrier','$targetchan')" );
..and save it back.

you will, unfortunately, need to do a database delete again but thereafter it should, with a little luck, behave itself.

Thank you for your help.

Kind Regards

S

[kevlime]

Ok , patch doesn't seem to have stopped the incremental addition of extensions

Applied the patch.

emptied the DB, and repopulated using the migration script then ran Init/RegenCommit, 38 extensions, re run Init/Regen/Commit they still double up.

select * (output snipped)

Code: [Select]

501|||DAHDI Ext(FXS) 1|||||||||||||AnalogFXS||1
502|||DAHDI Ext(FXS) 2|||||||||||||AnalogFXS||2
503|||DAHDI Ext(FXS) 3|||||||||||||AnalogFXS||3
504|||DAHDI Ext(FXS) 4|||||||||||||AnalogFXS||4
 

I am not physically near the machine at the moment but can try changing tonight/tomorrow FXO modules on the TDM card to FXS to see if incrmental additions takes place across the TDM as well as the Astribank

Let me know if you need any more debug outputs etc.

[SARK devs]

OK - Thanks

I'll put up a system with an analogue card on it and trace it through.
I'll get back to you shortly

Kind Regards
S

[SARK devs]

OK we know what's wrong.  We will fix in svn trunk first and then backport to 3.0.  It may take a little while. 

KInd Regards

S

[kevlime]

Bit of a followup (without updating sail), finally got to machine and changed daughter boards on TDM400 to 2 FXO & 2 FXS.  Removed Astribank

Situation remains for TDM cards as well with each PCI Init/Regen/Commit incrmental extensions bieng added.

[SARK devs]

Thanks for the update.

We don't have an Astribank to hand but we've simulated the fault using a couple of TDM400 cards.   Wew will devote a slice of time to it in the next week or so. 

Kind Regards and thanks again

S