NEW IncrediblePBX 2026-Debian13

[kenn10]

Try this:
3211 [2026-06-07 14:05:23] VERBOSE[238655][C-0000000b] pbx.c: Spawn extension (macro-hangupcall, s, 6) exited non-zero on 'PJSIP/210-00000010'
3212 [2026-06-07 14:05:23] WARNING[3194097] res_odbc.c: SQL Execute returned an error: 42S02: [ma-3.1.15][11.8.6-MariaDB-0+deb13u1 from Debian]Table 'asteriskcdrdb.transient_cdr' doesn't ex ist
3213 [2026-06-07 14:05:23] WARNING[3194097] res_odbc.c: SQL Execute error -1!
3214 [2026-06-07 14:05:23] WARNING[3194097] cdr_adaptive_odbc.c: cdr_adaptive_odbc: Insert failed on 'asteriskcdrdb:cdr'. CDR failed: INSERT INTO cdr (calldate, clid, src, dst, dcontext, channel, dstchannel, lastapp, lastdata, duration, billsec, disposition, amaflags, uniqueid, cnum, cnam, outbound_cnum, outbound_cnam, linkedid, sequence) VALUES ({ ts '2026-06-07 14:04: 38' }, '"John Doe" <18285551212>', '18285551212', '17704557141', 'from-internal', 'PJSIP/210-00000010', 'PJSIP/BulkVS-00000011', 'Dial', 'PJSIP/17704557141@BulkVS,300,Tb(func-apply-sipheaders^s^1,(1))U(sub-send-obrout', 44, 36, 'ANSWERED', 3, '1780855478.16', '210', 'Office 210', '18285551212', 'John Doe', '1780855478.16', 19)

 

[Samot]

Try this:
3211 [2026-06-07 14:05:23] VERBOSE[238655][C-0000000b] pbx.c: Spawn extension (macro-hangupcall, s, 6) exited non-zero on 'PJSIP/210-00000010'
3212 [2026-06-07 14:05:23] WARNING[3194097] res_odbc.c: SQL Execute returned an error: 42S02: [ma-3.1.15][11.8.6-MariaDB-0+deb13u1 from Debian]Table 'asteriskcdrdb.transient_cdr' doesn't ex ist
3213 [2026-06-07 14:05:23] WARNING[3194097] res_odbc.c: SQL Execute error -1!
3214 [2026-06-07 14:05:23] WARNING[3194097] cdr_adaptive_odbc.c: cdr_adaptive_odbc: Insert failed on 'asteriskcdrdb:cdr'. CDR failed: INSERT INTO cdr (calldate, clid, src, dst, dcontext, channel, dstchannel, lastapp, lastdata, duration, billsec, disposition, amaflags, uniqueid, cnum, cnam, outbound_cnum, outbound_cnam, linkedid, sequence) VALUES ({ ts '2026-06-07 14:04: 38' }, '"John Doe" <18285551212>', '18285551212', '17704557141', 'from-internal', 'PJSIP/210-00000010', 'PJSIP/BulkVS-00000011', 'Dial', 'PJSIP/17704557141@BulkVS,300,Tb(func-apply -sipheaders^s^1,(1))U(sub-send-obrout', 44, 36, 'ANSWERED', 3, '1780855478.16', '210', 'Office 210', '18285551212', 'John Doe', '1780855478.16', 19)

Now we would need to see

fwconsole m
MariaDB [asterisk]> use asteriskcdrdb;
MariaDB [asteriskcdrdb]> show columns from cdr;

Paste the output so we can see the structure and settings.

 

[kenn10]

Now we would need to see


Paste the output so we can see the structure and settings.

I already created the transient_cdr table and at that point everything works correctly. Not sure what showing the cdr table will do now.

+---------------+--------------+------+-----+---------------------+-------+
| Field         | Type         | Null | Key | Default             | Extra |
+---------------+--------------+------+-----+---------------------+-------+
| calldate      | datetime     | NO   | MUL | 1000-01-01 00:00:00 |       |
| clid          | varchar(80)  | NO   |     |                     |       |
| src           | varchar(80)  | NO   |     |                     |       |
| dst           | varchar(80)  | NO   | MUL |                     |       |
| dcontext      | varchar(80)  | NO   |     |                     |       |
| channel       | varchar(80)  | NO   |     |                     |       |
| dstchannel    | varchar(80)  | NO   | MUL |                     |       |
| lastapp       | varchar(80)  | NO   |     |                     |       |
| lastdata      | varchar(80)  | NO   |     |                     |       |
| duration      | int(11)      | NO   |     | 0                   |       |
| billsec       | int(11)      | NO   |     | 0                   |       |
| disposition   | varchar(45)  | NO   |     |                     |       |
| amaflags      | int(11)      | NO   |     | 0                   |       |
| accountcode   | varchar(20)  | NO   | MUL |                     |       |
| uniqueid      | varchar(32)  | NO   | MUL |                     |       |
| userfield     | varchar(255) | NO   |     |                     |       |
| did           | varchar(50)  | NO   | MUL |                     |       |
| recordingfile | varchar(255) | NO   | MUL |                     |       |
| cnum          | varchar(80)  | NO   |     |                     |       |
| cnam          | varchar(80)  | NO   |     |                     |       |
| outbound_cnum | varchar(80)  | NO   |     |                     |       |
| outbound_cnam | varchar(80)  | NO   |     |                     |       |
| dst_cnam      | varchar(80)  | NO   |     |                     |       |
| linkedid      | varchar(32)  | NO   | MUL |                     |       |
| peeraccount   | varchar(80)  | NO   |     |                     |       |
| sequence      | int(11)      | NO   |     | 0                   |       |
+---------------+--------------+------+-----+---------------------+-------+

 

[kenn10]

My suggestion for Sangoma would be to modify the FreePBX-17 backup/restore module so that if the transient_cdr table does not exist during a restore function, that it be created. That would solve the issue. The other problem is that even if you set transient_cdr to "no" in the Settings > Advanced Settings and fwconsole restart, it still errors out if that table is not there.

 

[Samot]

My suggestion for Sangoma would be to modify the FreePBX-17 backup/restore module so that if the transient_cdr table does not exist during a restore function, that it be created. That would solve the issue. The other problem is that even if you set transient_cdr to "no" in the Settings > Advanced Settings and fwconsole restart, it still errors out if that table is not there.

Oh there's other issues with how they handle the restore. This helped track that down.

 

[hecatae]

buggy stuff.

the ./upgrade-asterisk script menuselect does not work, so I used the opportunity to install extra stuff in Asterisk 23.4.0

the IncrediblePBX feed does not announce this version exists?

 

[Samot]

buggy stuff.

the ./upgrade-asterisk script menuselect does not work, so I used the opportunity to install extra stuff in Asterisk 23.4.0

the IncrediblePBX feed does not announce this version exists?

It doesn't work on the install either.

 

[hecatae]

It doesn't work on the install either.

Yes saw plenty of error

 

[kenn10]

This is what I have. It throws up menuselect and I select the things I want. The rm -rf asterisk-23 may cause an error if you don't have Asterisk-23 already installed. Change it to rm -rf asterisk-22.

  1 #!/bin/bash
  2
  3 echo "This utility upgrades to Asterisk 23 current release"
  4 read -p "Press Enter to proceed at your own risk or Ctrl-C to abort..."
  5 cd /usr/src
  6 rm -rf asterisk-23*
  7 wget https://downloads.asterisk.org/pub/telephony/asterisk/asterisk-23-current.tar.gz
  8 tar zxvf asterisk-23*
  9 rm -f asterisk-23*.tar.gz
 10 cd asterisk-23*
 11 contrib/scripts/get_mp3_source.sh
 12 contrib/scripts/install_prereq install
 13 make distclean
 14 tar zxvf /root/menuselect-incredible17*.tar.gz
 15 ./configure --with-pjproject-bundled --with-jansson-bundled
 16 make menuselect.makeopts
 17 menuselect/menuselect --disable-category MENUSELECT_TESTS menuselect.makeopts
 18 make menuselect
 19 read -p "Press Enter to proceed at your own risk or Ctrl-C to abort..."
 20 make && make install && ldconfig
 21 touch /etc/asterisk/stir_shaken.conf
 22 fwconsole restart

 

[kenn10]

the IncrediblePBX feed does not announce this version exists?

Obviously not.