[asterisk-bugs] [Asterisk 0018407]: 'usegmtime=yes' is ignored and CDR(end) is not inserted

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18407 
====================================================================== 
Reported By:                joscas
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   18407
Category:                   CDR/cdr_pgsql
Reproducibility:            always
Severity:                   trivial
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.8.0 
JIRA:                       SWP-2678 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-12-01 06:44 CST
Last Modified:              2010-12-07 16:39 CST
====================================================================== 
Summary:                    'usegmtime=yes' is ignored and CDR(end) is not
inserted
Description: 
CDRs get inserted on the server local time and it doesn't insert the
CDR(end).
====================================================================== 

---------------------------------------------------------------------- 
 (0129434) joscas (reporter) - 2010-12-07 16:39
 https://issues.asterisk.org/view.php?id=18407#c129434 
---------------------------------------------------------------------- 
--
-- PostgreSQL database dump
--

-- Dumped from database version 8.3.12
-- Dumped by pg_dump version 9.0.1
-- Started on 2010-11-26 14:21:47 CET

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 1462 (class 1259 OID 16387)
-- Dependencies: 3
-- Name: cdr; Type: TABLE; Schema: public; Owner: asterisk; Tablespace: 
--

CREATE TABLE cdr (
    id bigserial PRIMARY KEY,
    clidnum character varying(80),
    clidname character varying(80),
    dialednum character varying(80),
    calldate timestamp with time zone,
    answer timestamp with time zone,
    callend timestamp with time zone,
    duration numeric(14,6),
    billsec numeric(14,6),
    disposition character varying(45),
    uniqueid character varying(32),
    sequence integer
);


ALTER TABLE public.cdr OWNER TO asterisk;

--
-- TOC entry 1733 (class 0 OID 0)
-- Dependencies: 3
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2010-11-26 14:21:49 CET

--
-- PostgreSQL database dump complete
-- 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-12-07 16:39 joscas         Note Added: 0129434                          
======================================================================