#619 db path field to small

1.10.x
closed-fixed
modules (454)
5
2013-05-10
2013-02-27
No

Hello,

When trying to use opensips 1.9 with oversip path support, I got the following db error: "ERROR:db_postgres:db_postgres_submit_query: 0x7fddaad0ac18 PQsendQuery Error: ERROR: value too long for type character varying(128)"

The Path field to be inserted in location table was larger than 128 charaters limit ('<sip:82.138.xx.xxx:5060;transport=tcp;lr;ovid=54f722f3>,<sip:_ODguMTc2LjE2LjIwNV81NTQwMQ--@82.138.xx.xxx:5060;transport=udp;lr;ovid=54f722f3;ob>')

I solved my issue by extending the path field to VARCHAR(255) but I am not sure if it is sufficient.

Discussion

  • Bogdan-Andrei Iancu

    • assigned_to: nobody --> bogdan_iancu
    • milestone: --> 1.9.x
    • status: open --> closed-fixed
     
  • Bogdan-Andrei Iancu

    Hi Vallimamod, thanks for the report - the size was increased in SVN trunk and 1.9.

    Best regards,
    Bogdan

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks