[asterisk-bugs] [JIRA] (ASTERISK-27515) prune_on_boot field missing in ps_contact table

[George Joseph (JIRA)]

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

George Joseph updated ASTERISK-27515:
-------------------------------------

    Status: Waiting for Feedback  (was: Triage)

I'm guessing you used the sql files in contrib/realtime/mysql?
When I run this on an existing database...
{noformat}
$ mysql --force -p -u asterisk asterisk < mysql_config.sql
{noformat}
I get a bunch of errors for the items that already exist but it does upgrade the ps_contacts table to add prune_on_boot.

Can you provide the exact command you used and the output?


> prune_on_boot field missing in ps_contact table 
> ------------------------------------------------
>
>                 Key: ASTERISK-27515
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-27515
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Channels/chan_pjsip
>    Affects Versions: 13.18.4
>            Reporter: Sunny
>
> After upgrading to Asterisk 13.18.4, when somebody is trying to register ast box 13.18.4 is throwing warning
> res_config_odbc.c:120 custom_prepare: SQL Prepare failed! [INSERT INTO ps_contacts (id, via_addr, qualify_timeout, call_id, reg_server, prune_on_boot, path, endpoint, via_port, authenticate_qualify, uri, qualify_frequency, user_agent, expiration_time, outbound_proxy) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
> Although I have updated the DB schema using the included the SQL files in the package and still prune_on_boot field missing (I am using mysql)
> So please alter the query for ps_contact table in 13.18.4 package



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