Comments (11)
lmangani
commented on July 18, 2024
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.
from homer-api.
hamid-elaosta
commented on July 18, 2024
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.
from homer-api.
lmangani
commented on July 18, 2024
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.
from homer-api.
hamid-elaosta
commented on July 18, 2024
@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.
from homer-api.
lmangani
commented on July 18, 2024
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.
from homer-api.
hamid-elaosta
commented on July 18, 2024
@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 😭
from homer-api.
rs03
commented on July 18, 2024
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
from homer-api.
adubovikov
commented on July 18, 2024
You should also activate the de-fragmentation/reassmbling for UDP/TCP
packets in your socket_pcap.xml file
…On Tue, 30 Oct 2018 at 18:10, Rita Singh ***@***.***> wrote:
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
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<#177 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AETdJWujLOfwS1tHqiiVUT0paQXywb7Fks5uqIfugaJpZM4R-mMj>
.
from homer-api.
rs03
commented on July 18, 2024
Hi
Thanks for reply...yes i have set reasm to true and if I do so ..I don't
see fragmented packets in database/homer
…On 1 Nov 2018 13:25, "Alexandr Dubovikov" ***@***.***> wrote:
You should also activate the de-fragmentation/reassmbling for UDP/TCP
packets in your socket_pcap.xml file
On Tue, 30 Oct 2018 at 18:10, Rita Singh ***@***.***> wrote:
> 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
>
> —
> You are receiving this because you are subscribed to this thread.
> Reply to this email directly, view it on GitHub
> <https://github.com/sipcapture/homer-api/issues/
177#issuecomment-434386997>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/
AETdJWujLOfwS1tHqiiVUT0paQXywb7Fks5uqIfugaJpZM4R-mMj>
> .
>
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#177 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/Aj5EZ8oWjH_U-NvsaYwAkoaDo2mENPr5ks5uqqjvgaJpZM4R-mMj>
.
from homer-api.
adubovikov
commented on July 18, 2024
check with wireshark and HEP dissector if you have received the full packet
…On Thu, 1 Nov 2018 at 09:00, Rita Singh ***@***.***> wrote:
Hi
Thanks for reply...yes i have set reasm to true and if I do so ..I don't
see fragmented packets in database/homer
On 1 Nov 2018 13:25, "Alexandr Dubovikov" ***@***.***>
wrote:
> You should also activate the de-fragmentation/reassmbling for UDP/TCP
> packets in your socket_pcap.xml file
>
> On Tue, 30 Oct 2018 at 18:10, Rita Singh ***@***.***>
wrote:
>
> > 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
> >
> > —
> > You are receiving this because you are subscribed to this thread.
> > Reply to this email directly, view it on GitHub
> > <https://github.com/sipcapture/homer-api/issues/
> 177#issuecomment-434386997>,
> > or mute the thread
> > <https://github.com/notifications/unsubscribe-auth/
> AETdJWujLOfwS1tHqiiVUT0paQXywb7Fks5uqIfugaJpZM4R-mMj>
> > .
> >
>
> —
> You are receiving this because you commented.
> Reply to this email directly, view it on GitHub
> <
#177 (comment)
>,
> or mute the thread
> <
https://github.com/notifications/unsubscribe-auth/Aj5EZ8oWjH_U-NvsaYwAkoaDo2mENPr5ks5uqqjvgaJpZM4R-mMj
>
> .
>
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#177 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AETdJfbrzPkNIBvslqUCZ0GWtPNhLClFks5uqqorgaJpZM4R-mMj>
.
from homer-api.
adubovikov
commented on July 18, 2024
from homer-api.
Related Issues (20)
- Alarms config HOT 1
- Can't create alarm HOT 1
- Ipv6 calls are showing 0.0.0.0 ip when exported as pcap HOT 5
- Export search type uses current local time zone regardless of time zone selected in UI HOT 3
- Search uses "local" time instead of selected timezone if Export selected HOT 1
- click on Call-ID field does not display entire dialog if call started > 15 minutes before packet clicked HOT 3
- Wrong MOS calculation HOT 7
- incorrect content-length on json widget download (off by one) HOT 5
- homer_mysql_rotate fails. HOT 2
- NO msg field when retrieved call details using GET/POST http://localhost/api/v1/search/data HOT 1
- homer-api not connecting to the database HOT 3
- LDAP Authentication
- Homer 5 Install guide HOT 2
- Back-End homer-api for Java ? HOT 3
- unable to send json using statstrmr to homer api HOT 1
- does possible homer authenticat via microsoft active directory? HOT 2
- Duplicated records on homer 5 HOT 2
- homer_pgsql_rotate.pl no longer works HOT 7
- MySQL 8: function PASSWORD() removed. HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from homer-api.