You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
I've tried to connect freeswitch to our MySQL database through ODBC driver as it described in the docs. Some of the tables was created successfully, but one table isn't probably compatible and throws error:
2024-04-25 15:11:31.982216 0.00% [ERR] switch_odbc.c:529 ERR: [CREATE TABLE channels (
uuid VARCHAR(256),
direction VARCHAR(32),
created VARCHAR(128),
created_epoch INTEGER,
name VARCHAR(1024),
state VARCHAR(64),
cid_name VARCHAR(1024),
cid_num VARCHAR(256),
ip_addr VARCHAR(256),
dest VARCHAR(1024),
application VARCHAR(128),
application_data VARCHAR(4096),
dialplan VARCHAR(128),
context VARCHAR(128),
read_codec VARCHAR(128),
read_rate VARCHAR(32),
read_bit_rate VARCHAR(32),
write_codec VARCHAR(128),
write_rate VARCHAR(32),
write_bit_rate VARCHAR(32),
secure VARCHAR(64),
hostname VARCHAR(256),
presence_id VARCHAR(4096),
presence_data VARCHAR(4096),
accountcode VARCHAR(256),
callstate VARCHAR(64),
callee_name VARCHAR(1024),
callee_num VARCHAR(256),
callee_direction VARCHAR(5),
call_uuid VARCHAR(256),
sent_callee_name VARCHAR(1024),
sent_callee_num VARCHAR(256),
initial_cid_name VARCHAR(1024),
initial_cid_num VARCHAR(256),
initial_ip_addr VARCHAR(256),
initial_dest VARCHAR(1024),
initial_dialplan VARCHAR(128),
initial_context VARCHAR(128)
);
[STATE: HY000 CODE 1118 ERROR: [MySQL][ODBC 8.3(w) Driver][mysqld-8.0.30]Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
To Reproduce
Steps to reproduce the behavior:
Create fresh new MySQL database on version 8.0.30 with utf8mb4_general_ci collation
Add MySQL ODBC connection into /etc/freeswitch/autoload_configs/switch.conf.xml
Restart/Start FreeSWITCH
FreeSWITCH crashes
Expected behavior
Create tables in database properly without crashing :)
Describe the bug
I've tried to connect freeswitch to our MySQL database through ODBC driver as it described in the docs. Some of the tables was created successfully, but one table isn't probably compatible and throws error:
To Reproduce
Steps to reproduce the behavior:
Expected behavior
Create tables in database properly without crashing :)
Package version or git hash
The text was updated successfully, but these errors were encountered: