[SR-Users] database scheme generation and synchronization

Daniel-Constantin Mierla miconda at gmail.com
Fri Nov 21 14:49:26 CET 2014


Hello,

the sql scripts to create the tables are in
utils/kamctl/{mysql|postgres|...}

The one you were looking at are probably from ser side and should be
removed.

Cheers,
Daniel

On 21/11/14 02:13, Måns Nilsson wrote:
> Greetings, 
>
> I'm fighting a number of errors in the 'acc' table like so: 
>
> Nov 21 01:43:05 landsort postgres[53327]: [4-1] ERROR:  column "time" of relation "acc" does not exist at character 78
>
> That is, I believe, the default column name. 
>
> Thing is, though, that the DDL that I used to build the table, is the
> one in in scripts/ and it does not does not contain that string:
> 	(on master but it is the same in 4.2 which is what I've got in production) 
>
> $ for d in mysql oracle postgres ; do egrep '\btime\b' scripts/${d}/*create* ; done 
> $
>
> How are those files generated? 
>
> How do I come about to submitting an useful patch? 
>
> What is the desired datatype for the time column? 
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141121/f9b2d2e1/attachment.html>


More information about the sr-users mailing list