[asterisk-bugs] [JIRA] (ASTERISK-29499) sip_to_pjsql.py: Fails to write SQL file

[Benjamin Keith Ford (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-29499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Benjamin Keith Ford updated ASTERISK-29499:
-------------------------------------------

    Assignee: Daniel
      Status: Waiting for Feedback  (was: Triage)

After looking at the converter script, there are several things that could have gone wrong. Unfortunately there isn't any logging in that area.

One thing to check is making sure permissions are correct for the user and file you are trying to convert. If that doesn't work, do you mind attaching your sip.conf so we can run some tests? If there is information in there that you don't want publicly visible, you can email it directly to asteriskteam at digium.com.

Can you post the exact command you are running on the terminal? Although I doubt it, it could be an argument parsing issue.

> sip_to_pjsql.py: Fails to write SQL file
> ----------------------------------------
>
>                 Key: ASTERISK-29499
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-29499
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Contrib/General
>    Affects Versions: 18.3.0
>         Environment: Ubuntu 18.04.5 LTS - VMWare esxi 6.7
>            Reporter: Daniel
>            Assignee: Daniel
>
> when attempting to upgrade to pjsip via sip_to_pjsql.py 
> I get the below error
> Please, report any issue at:
>     https://issues.asterisk.org/
> Reading sip.conf
> Converting to PJSIP realtime sql...
> Writing pjsip.sql
> Traceback (most recent call last):
>   File "/tmp/pjsipnew/sip_to_pjsql.py", line 79, in <module>
>     write_pjsip(pjsip_filename, pjsip, non_mappings)
>   File "/tmp/pjsipnew/sip_to_pjsql.py", line 17, in write_pjsip
>     pjsip.write(fp)
>   File "/tmp/pjsipnew/sqlconfigparser.py", line 72, in write
>     print("Could not open file " + config_file + " for writing")
> TypeError: cannot concatenate 'str' and 'file' objects



--
This message was sent by Atlassian JIRA
(v6.2#6252)