Skip to content
This repository has been archived by the owner on Mar 21, 2023. It is now read-only.

Large INVITEs > 1500 bytes not being saved #177

Closed
davehorton opened this issue Feb 8, 2018 · 11 comments
Closed

Large INVITEs > 1500 bytes not being saved #177

davehorton opened this issue Feb 8, 2018 · 11 comments

Comments

@davehorton
Copy link

I am running some siprec traffic where the large multipart payloads can easily cause the size of INVITEs to exceed 1500, which is the size of the msg column in several tables. The impact is that these calls do not appear in the tables (well, the 100 Trying etc does but not the initial INVITE). I actually tried modifying the column size in mysql to 4096 but still am not seeing these messages. Any idea of a workaround that would let me store and retrieve these larger INVITE messages?

@lmangani
Copy link
Member

lmangani commented Feb 8, 2018

Hi Dave,
Check this out: https://github.com/sipcapture/homer-api/blob/master/scripts/mysql/rotation.ini#L78

Let me know if this sorts it.

@hamid-elaosta
Copy link

This doesn't appear to be useful for the Docker based versions. Even mounting this file externally as a volume, and increasing the SIP capture value, the DB is still created with the column too short for some of us with large INVITE packets. It would be useful to have this configurable for the Docker builds, or made larger by default to accommodate larger INVITEs.

@lmangani
Copy link
Member

Hi @hamid-elaosta I updated the default for new builds - alternatively, you can mount your own rotation.ini with any preference you wish and/or build a custom rotation container with any settings of your likes. New versions of the stack shall no longer have this problem as the partitions are created by the capture-server itself.

@hamid-elaosta
Copy link

@lmangani Thanks. I've been building with rotation.ini mounted in but it doesn't affect DB creation, I've also tried mounting the schema_data.sql with modified values in the docker-opensips build I'm using but I presume it's run from another copy other than that in /home-api/sql/mysql/data_schema.sql? That copy has my changes but the opensips database is still created with the 1500 length.

@lmangani
Copy link
Member

Partitions are created days in advance and existing one won't be modified by executions (unless you drop them ahead of running the rotation script) so keep this in mind as you test a solution.

@hamid-elaosta
Copy link

hamid-elaosta commented Jul 17, 2018

@lmangani Indeed. I am a clean db every startup, for some reason volume mounting the rotation.ini didn't affect table creation. Perhaps volumes are mounted after the tables are created?
I pulled your latest change from the homer-api repo and pre-building it with the correct value works fine now, thanks 👍

EDIT: At ~2700 character INVITEs I'm dangerously close to your 3000 limit already 😭

@rs03
Copy link

rs03 commented Oct 30, 2018

Even I am facing same issue.Can somebody please help me here? I have modified sip_capture_call = 3000 in MSG_TABLE_SIZE(vim /usr/src/homer-api/scripts/mysql/rotation.ini) , I can see modified msg field size in sipcapturecall table but still not getting entire INVITE data

@adubovikov
Copy link
Member

adubovikov commented Nov 1, 2018 via email

@rs03
Copy link

rs03 commented Nov 1, 2018 via email

@adubovikov
Copy link
Member

adubovikov commented Nov 1, 2018 via email

@adubovikov
Copy link
Member

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants