Unable to setup new shows
  • Airtime was working great - mounting to icecast fine: http://69.90.148.151:8000/

    Stepped away for a period, returned to put some more test programming in and now no longer can enter programs:

    See here: http://screencast.com/t/vMCNqgbg

    Airtime logs attached.
  • 11 Comments sorted by
  • Hi!,

    Thanks for the screencast, if you can still recreate this problem, the most helpful thing to do would be provide a dump of the Airtime database so we can recreate your environment:

    sudo -u postgres pg_dump airtime


    Martin
    Airtime Pro Hosting: http://airtime.pro
  • Here's the db dump:


    -- PostgreSQL database dump
    --

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

    --
    -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: airtime
    --

    CREATE PROCEDURAL LANGUAGE plpgsql;


    ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO airtime;

    SET search_path = public, pg_catalog;

    --
    -- Name: calculate_position(); Type: FUNCTION; Schema: public; Owner: airtime
    --

    CREATE FUNCTION calculate_position() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
    BEGIN
    IF(TG_OP='INSERT') THEN
    UPDATE cc_playlistcontents SET position = (position + 1)
    WHERE (playlist_id = new.playlist_id AND position >= new.position AND id != new.id);
    END IF;
    IF(TG_OP='DELETE') THEN
    UPDATE cc_playlistcontents SET position = (position - 1)
    WHERE (playlist_id = old.playlist_id AND position > old.position);
    END IF;
    RETURN NULL;
    END;
    $$;


    ALTER FUNCTION public.calculate_position() OWNER TO airtime;

    SET default_tablespace = '';

    SET default_with_oids = false;

    --
    -- Name: cc_access; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_access (
    id integer NOT NULL,
    gunid character(32),
    token bigint,
    chsum character(32) DEFAULT ''::bpchar NOT NULL,
    ext character varying(128) DEFAULT ''::character varying NOT NULL,
    type character varying(20) DEFAULT ''::character varying NOT NULL,
    parent bigint,
    owner integer,
    ts timestamp without time zone
    );


    ALTER TABLE public.cc_access OWNER TO airtime;

    --
    -- Name: cc_access_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE cc_access_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.cc_access_id_seq OWNER TO airtime;

    --
    -- Name: cc_access_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: airtime
    --

    ALTER SEQUENCE cc_access_id_seq OWNED BY cc_access.id;


    --
    -- Name: cc_access_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('cc_access_id_seq', 1, false);


    --
    -- Name: cc_files; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_files (
    id integer NOT NULL,
    gunid character(32) NOT NULL,
    name character varying(255) DEFAULT ''::character varying NOT NULL,
    mime character varying(255) DEFAULT ''::character varying NOT NULL,
    ftype character varying(128) DEFAULT ''::character varying NOT NULL,
    filepath text DEFAULT ''::text,
    state character varying(128) DEFAULT 'empty'::character varying NOT NULL,
    currentlyaccessing integer DEFAULT 0 NOT NULL,
    editedby integer,
    mtime timestamp(6) without time zone,
    md5 character(32),
    track_title character varying(512),
    artist_name character varying(512),
    bit_rate character varying(32),
    sample_rate character varying(32),
    format character varying(128),
    length time without time zone,
    album_title character varying(512),
    genre character varying(64),
    comments text,
    year character varying(16),
    track_number integer,
    channels integer,
    url character varying(1024),
    bpm character varying(Cool,
    rating character varying(Cool,
    encoded_by character varying(255),
    disc_number character varying(Cool,
    mood character varying(64),
    label character varying(512),
    composer character varying(512),
    encoder character varying(64),
    checksum character varying(256),
    lyrics text,
    orchestra character varying(512),
    conductor character varying(512),
    lyricist character varying(512),
    original_lyricist character varying(512),
    radio_station_name character varying(512),
    info_url character varying(512),
    artist_url character varying(512),
    audio_source_url character varying(512),
    radio_station_url character varying(512),
    buy_this_url character varying(512),
    isrc_number character varying(512),
    catalog_number character varying(512),
    original_artist character varying(512),
    copyright character varying(512),
    report_datetime character varying(32),
    report_location character varying(512),
    report_organization character varying(512),
    subject character varying(512),
    contributor character varying(512),
    language character varying(512)
    );


    ALTER TABLE public.cc_files OWNER TO airtime;

    --
    -- Name: cc_files_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE cc_files_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.cc_files_id_seq OWNER TO airtime;

    --
    -- Name: cc_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: airtime
    --

    ALTER SEQUENCE cc_files_id_seq OWNED BY cc_files.id;


    --
    -- Name: cc_files_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('cc_files_id_seq', 1, false);


    --
    -- Name: cc_perms; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_perms (
    permid integer NOT NULL,
    subj integer,
    action character varying(20),
    obj integer,
    type character(1)
    );


    ALTER TABLE public.cc_perms OWNER TO airtime;

    --
    -- Name: cc_playlist; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_playlist (
    id integer NOT NULL,
    name character varying(255) DEFAULT ''::character varying NOT NULL,
    state character varying(128) DEFAULT 'empty'::character varying NOT NULL,
    currentlyaccessing integer DEFAULT 0 NOT NULL,
    editedby integer,
    mtime timestamp(6) without time zone,
    creator character varying(32),
    description character varying(512)
    );


    ALTER TABLE public.cc_playlist OWNER TO airtime;

    --
    -- Name: cc_playlist_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE cc_playlist_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.cc_playlist_id_seq OWNER TO airtime;

    --
    -- Name: cc_playlist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: airtime
    --

    ALTER SEQUENCE cc_playlist_id_seq OWNED BY cc_playlist.id;


    --
    -- Name: cc_playlist_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('cc_playlist_id_seq', 1, false);


    --
    -- Name: cc_playlistcontents; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_playlistcontents (
    id integer NOT NULL,
    playlist_id integer,
    file_id integer,
    "position" integer,
    cliplength time without time zone DEFAULT '00:00:00'::time without time zone,
    cuein time without time zone DEFAULT '00:00:00'::time without time zone,
    cueout time without time zone DEFAULT '00:00:00'::time without time zone,
    fadein time without time zone DEFAULT '00:00:00'::time without time zone,
    fadeout time without time zone DEFAULT '00:00:00'::time without time zone
    );


    ALTER TABLE public.cc_playlistcontents OWNER TO airtime;

    --
    -- Name: cc_playlistcontents_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE cc_playlistcontents_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.cc_playlistcontents_id_seq OWNER TO airtime;

    --
    -- Name: cc_playlistcontents_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: airtime
    --

    ALTER SEQUENCE cc_playlistcontents_id_seq OWNED BY cc_playlistcontents.id;


    --
    -- Name: cc_playlistcontents_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('cc_playlistcontents_id_seq', 1, false);


    --
    -- Name: cc_playlisttimes; Type: VIEW; Schema: public; Owner: airtime
    --

    CREATE VIEW cc_playlisttimes AS
    SELECT pl.id, COALESCE(t.length, '00:00:00'::time without time zone) AS length FROM (cc_playlist pl LEFT JOIN (SELECT cc_playlistcontents.playlist_id AS id, (sum((cc_playlistcontents.cliplength)::interval))::time without time zone AS length FROM cc_playlistcontents GROUP BY cc_playlistcontents.playlist_id) t ON ((pl.id = t.id)));


    ALTER TABLE public.cc_playlisttimes OWNER TO airtime;

    --
    -- Name: cc_pref; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_pref (
    id integer NOT NULL,
    subjid integer,
    keystr character varying(255),
    valstr text
    );


    ALTER TABLE public.cc_pref OWNER TO airtime;

    --
    -- Name: cc_pref_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE cc_pref_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.cc_pref_id_seq OWNER TO airtime;

    --
    -- Name: cc_pref_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: airtime
    --

    ALTER SEQUENCE cc_pref_id_seq OWNED BY cc_pref.id;


    --
    -- Name: cc_pref_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('cc_pref_id_seq', 2, true);


    --
    -- Name: cc_schedule; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_schedule (
    id integer NOT NULL,
    playlist_id integer,
    starts timestamp without time zone NOT NULL,
    ends timestamp without time zone NOT NULL,
    group_id integer,
    file_id integer,
    clip_length time without time zone DEFAULT '00:00:00'::time without time zone,
    fade_in time without time zone DEFAULT '00:00:00'::time without time zone,
    fade_out time without time zone DEFAULT '00:00:00'::time without time zone,
    cue_in time without time zone DEFAULT '00:00:00'::time without time zone,
    cue_out time without time zone DEFAULT '00:00:00'::time without time zone,
    schedule_group_played boolean DEFAULT false,
    media_item_played boolean DEFAULT false,
    instance_id integer NOT NULL
    );


    ALTER TABLE public.cc_schedule OWNER TO airtime;

    --
    -- Name: cc_schedule_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE cc_schedule_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.cc_schedule_id_seq OWNER TO airtime;

    --
    -- Name: cc_schedule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: airtime
    --

    ALTER SEQUENCE cc_schedule_id_seq OWNED BY cc_schedule.id;


    --
    -- Name: cc_schedule_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('cc_schedule_id_seq', 1, false);


    --
    -- Name: cc_sess; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_sess (
    sessid character(32) NOT NULL,
    userid integer,
    login character varying(255),
    ts timestamp without time zone
    );


    ALTER TABLE public.cc_sess OWNER TO airtime;

    --
    -- Name: cc_show; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_show (
    id integer NOT NULL,
    name character varying(255) DEFAULT ''::character varying NOT NULL,
    url character varying(255) DEFAULT ''::character varying,
    genre character varying(255) DEFAULT ''::character varying,
    description character varying(512),
    color character varying(6),
    background_color character varying(6)
    );


    ALTER TABLE public.cc_show OWNER TO airtime;

    --
    -- Name: cc_show_days; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_show_days (
    id integer NOT NULL,
    first_show date NOT NULL,
    last_show date,
    start_time time without time zone NOT NULL,
    duration character varying(255) NOT NULL,
    day smallint,
    repeat_type smallint NOT NULL,
    next_pop_date date,
    show_id integer NOT NULL,
    record smallint DEFAULT 0
    );


    ALTER TABLE public.cc_show_days OWNER TO airtime;

    --
    -- Name: cc_show_days_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE cc_show_days_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.cc_show_days_id_seq OWNER TO airtime;

    --
    -- Name: cc_show_days_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: airtime
    --

    ALTER SEQUENCE cc_show_days_id_seq OWNED BY cc_show_days.id;


    --
    -- Name: cc_show_days_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('cc_show_days_id_seq', 1, false);


    --
    -- Name: cc_show_hosts; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_show_hosts (
    id integer NOT NULL,
    show_id integer NOT NULL,
    subjs_id integer NOT NULL
    );


    ALTER TABLE public.cc_show_hosts OWNER TO airtime;

    --
    -- Name: cc_show_hosts_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE cc_show_hosts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.cc_show_hosts_id_seq OWNER TO airtime;

    --
    -- Name: cc_show_hosts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: airtime
    --

    ALTER SEQUENCE cc_show_hosts_id_seq OWNED BY cc_show_hosts.id;


    --
    -- Name: cc_show_hosts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('cc_show_hosts_id_seq', 1, false);


    --
    -- Name: cc_show_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE cc_show_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.cc_show_id_seq OWNER TO airtime;

    --
    -- Name: cc_show_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: airtime
    --

    ALTER SEQUENCE cc_show_id_seq OWNED BY cc_show.id;


    --
    -- Name: cc_show_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('cc_show_id_seq', 1, false);


    --
    -- Name: cc_show_instances; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_show_instances (
    id integer NOT NULL,
    starts timestamp without time zone NOT NULL,
    ends timestamp without time zone NOT NULL,
    show_id integer NOT NULL,
    record smallint DEFAULT 0,
    rebroadcast smallint DEFAULT 0,
    instance_id integer,
    file_id integer,
    soundcloud_id integer,
    time_filled time without time zone
    );


    ALTER TABLE public.cc_show_instances OWNER TO airtime;

    --
    -- Name: cc_show_instances_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE cc_show_instances_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.cc_show_instances_id_seq OWNER TO airtime;

    --
    -- Name: cc_show_instances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: airtime
    --

    ALTER SEQUENCE cc_show_instances_id_seq OWNED BY cc_show_instances.id;


    --
    -- Name: cc_show_instances_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('cc_show_instances_id_seq', 1, false);


    --
    -- Name: cc_show_rebroadcast; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_show_rebroadcast (
    id integer NOT NULL,
    day_offset character varying(255) NOT NULL,
    start_time time without time zone NOT NULL,
    show_id integer NOT NULL
    );


    ALTER TABLE public.cc_show_rebroadcast OWNER TO airtime;

    --
    -- Name: cc_show_rebroadcast_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE cc_show_rebroadcast_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.cc_show_rebroadcast_id_seq OWNER TO airtime;

    --
    -- Name: cc_show_rebroadcast_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: airtime
    --

    ALTER SEQUENCE cc_show_rebroadcast_id_seq OWNED BY cc_show_rebroadcast.id;


    --
    -- Name: cc_show_rebroadcast_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('cc_show_rebroadcast_id_seq', 1, false);


    --
    -- Name: cc_smemb; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_smemb (
    id integer NOT NULL,
    uid integer DEFAULT 0 NOT NULL,
    gid integer DEFAULT 0 NOT NULL,
    level integer DEFAULT 0 NOT NULL,
    mid integer
    );


    ALTER TABLE public.cc_smemb OWNER TO airtime;

    --
    -- Name: cc_subjs; Type: TABLE; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE TABLE cc_subjs (
    id integer NOT NULL,
    login character varying(255) DEFAULT ''::character varying NOT NULL,
    pass character varying(255) DEFAULT ''::character varying NOT NULL,
    type character(1) DEFAULT 'U'::bpchar NOT NULL,
    first_name character varying(255) DEFAULT ''::character varying NOT NULL,
    last_name character varying(255) DEFAULT ''::character varying NOT NULL,
    lastlogin timestamp without time zone,
    lastfail timestamp without time zone,
    skype_contact character varying(255),
    jabber_contact character varying(255),
    email character varying(255)
    );


    ALTER TABLE public.cc_subjs OWNER TO airtime;

    --
    -- Name: cc_subjs_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE cc_subjs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.cc_subjs_id_seq OWNER TO airtime;

    --
    -- Name: cc_subjs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: airtime
    --

    ALTER SEQUENCE cc_subjs_id_seq OWNED BY cc_subjs.id;


    --
    -- Name: cc_subjs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('cc_subjs_id_seq', 1, true);


    --
    -- Name: schedule_group_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE schedule_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.schedule_group_id_seq OWNER TO airtime;

    --
    -- Name: schedule_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('schedule_group_id_seq', 1, false);


    --
    -- Name: show_group_id_seq; Type: SEQUENCE; Schema: public; Owner: airtime
    --

    CREATE SEQUENCE show_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


    ALTER TABLE public.show_group_id_seq OWNER TO airtime;

    --
    -- Name: show_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: airtime
    --

    SELECT pg_catalog.setval('show_group_id_seq', 1, false);


    --
    -- Name: id; Type: DEFAULT; Schema: public; Owner: airtime
    --

    ALTER TABLE cc_access ALTER COLUMN id SET DEFAULT nextval('cc_access_id_seq'::regclass);


    --
    -- Name: id; Type: DEFAULT; Schema: public; Owner: airtime
    --

    ALTER TABLE cc_files ALTER COLUMN id SET DEFAULT nextval('cc_files_id_seq'::regclass);


    --
    -- Name: id; Type: DEFAULT; Schema: public; Owner: airtime
    --

    ALTER TABLE cc_playlist ALTER COLUMN id SET DEFAULT nextval('cc_playlist_id_seq'::regclass);


    --
    -- Name: id; Type: DEFAULT; Schema: public; Owner: airtime
    --

    ALTER TABLE cc_playlistcontents ALTER COLUMN id SET DEFAULT nextval('cc_playlistcontents_id_seq'::regclass);


    --
    -- Name: id; Type: DEFAULT; Schema: public; Owner: airtime
    --

    ALTER TABLE cc_pref ALTER COLUMN id SET DEFAULT nextval('cc_pref_id_seq'::regclass);


    --
    -- Name: id; Type: DEFAULT; Schema: public; Owner: airtime
    --

    ALTER TABLE cc_schedule ALTER COLUMN id SET DEFAULT nextval('cc_schedule_id_seq'::regclass);


    --
    -- Name: id; Type: DEFAULT; Schema: public; Owner: airtime
    --

    ALTER TABLE cc_show ALTER COLUMN id SET DEFAULT nextval('cc_show_id_seq'::regclass);


    --
    -- Name: id; Type: DEFAULT; Schema: public; Owner: airtime
    --

    ALTER TABLE cc_show_days ALTER COLUMN id SET DEFAULT nextval('cc_show_days_id_seq'::regclass);


    --
    -- Name: id; Type: DEFAULT; Schema: public; Owner: airtime
    --

    ALTER TABLE cc_show_hosts ALTER COLUMN id SET DEFAULT nextval('cc_show_hosts_id_seq'::regclass);


    --
    -- Name: id; Type: DEFAULT; Schema: public; Owner: airtime
    --

    ALTER TABLE cc_show_instances ALTER COLUMN id SET DEFAULT nextval('cc_show_instances_id_seq'::regclass);


    --
    -- Name: id; Type: DEFAULT; Schema: public; Owner: airtime
    --

    ALTER TABLE cc_show_rebroadcast ALTER COLUMN id SET DEFAULT nextval('cc_show_rebroadcast_id_seq'::regclass);


    --
    -- Name: id; Type: DEFAULT; Schema: public; Owner: airtime
    --

    ALTER TABLE cc_subjs ALTER COLUMN id SET DEFAULT nextval('cc_subjs_id_seq'::regclass);


    --
    -- Data for Name: cc_access; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_access (id, gunid, token, chsum, ext, type, parent, owner, ts) FROM stdin;
    \.


    --
    -- Data for Name: cc_files; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_files (id, gunid, name, mime, ftype, filepath, state, currentlyaccessing, editedby, mtime, md5, track_title, artist_name, bit_rate, sample_rate, format, length, album_title, genre, comments, year, track_number, channels, url, bpm, rating, encoded_by, disc_number, mood, label, composer, encoder, checksum, lyrics, orchestra, conductor, lyricist, original_lyricist, radio_station_name, info_url, artist_url, audio_source_url, radio_station_url, buy_this_url, isrc_number, catalog_number, original_artist, copyright, report_datetime, report_location, report_organization, subject, contributor, language) FROM stdin;
    \.


    --
    -- Data for Name: cc_perms; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_perms (permid, subj, action, obj, type) FROM stdin;
    \.


    --
    -- Data for Name: cc_playlist; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_playlist (id, name, state, currentlyaccessing, editedby, mtime, creator, description) FROM stdin;
    \.


    --
    -- Data for Name: cc_playlistcontents; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_playlistcontents (id, playlist_id, file_id, "position", cliplength, cuein, cueout, fadein, fadeout) FROM stdin;
    \.


    --
    -- Data for Name: cc_pref; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_pref (id, subjid, keystr, valstr) FROM stdin;
    1 \N system_version 1.8.2
    2 1 shows_populated_until 2011-8-7 0:0:0
    \.


    --
    -- Data for Name: cc_schedule; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_schedule (id, playlist_id, starts, ends, group_id, file_id, clip_length, fade_in, fade_out, cue_in, cue_out, schedule_group_played, media_item_played, instance_id) FROM stdin;
    \.


    --
    -- Data for Name: cc_sess; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_sess (sessid, userid, login, ts) FROM stdin;
    \.


    --
    -- Data for Name: cc_show; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_show (id, name, url, genre, description, color, background_color) FROM stdin;
    \.


    --
    -- Data for Name: cc_show_days; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_show_days (id, first_show, last_show, start_time, duration, day, repeat_type, next_pop_date, show_id, record) FROM stdin;
    \.


    --
    -- Data for Name: cc_show_hosts; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_show_hosts (id, show_id, subjs_id) FROM stdin;
    \.


    --
    -- Data for Name: cc_show_instances; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_show_instances (id, starts, ends, show_id, record, rebroadcast, instance_id, file_id, soundcloud_id, time_filled) FROM stdin;
    \.


    --
    -- Data for Name: cc_show_rebroadcast; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_show_rebroadcast (id, day_offset, start_time, show_id) FROM stdin;
    \.


    --
    -- Data for Name: cc_smemb; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_smemb (id, uid, gid, level, mid) FROM stdin;
    \.


    --
    -- Data for Name: cc_subjs; Type: TABLE DATA; Schema: public; Owner: airtime
    --

    COPY cc_subjs (id, login, pass, type, first_name, last_name, lastlogin, lastfail, skype_contact, jabber_contact, email) FROM stdin;
    1 admin 21232f297a57a5a743894a0e4a801fc3 A \N \N \N \N \N
    \.


    --
    -- Name: cc_access_pkey; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_access
    ADD CONSTRAINT cc_access_pkey PRIMARY KEY (id);


    --
    -- Name: cc_files_gunid_idx; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_files
    ADD CONSTRAINT cc_files_gunid_idx UNIQUE (gunid);


    --
    -- Name: cc_files_pkey; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_files
    ADD CONSTRAINT cc_files_pkey PRIMARY KEY (id);


    --
    -- Name: cc_perms_all_idx; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_perms
    ADD CONSTRAINT cc_perms_all_idx UNIQUE (subj, action, obj);


    --
    -- Name: cc_perms_permid_idx; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_perms
    ADD CONSTRAINT cc_perms_permid_idx PRIMARY KEY (permid);


    --
    -- Name: cc_playlist_pkey; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_playlist
    ADD CONSTRAINT cc_playlist_pkey PRIMARY KEY (id);


    --
    -- Name: cc_playlistcontents_pkey; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_playlistcontents
    ADD CONSTRAINT cc_playlistcontents_pkey PRIMARY KEY (id);


    --
    -- Name: cc_pref_id_idx; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_pref
    ADD CONSTRAINT cc_pref_id_idx PRIMARY KEY (id);


    --
    -- Name: cc_pref_subj_key_idx; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_pref
    ADD CONSTRAINT cc_pref_subj_key_idx UNIQUE (subjid, keystr);


    --
    -- Name: cc_schedule_pkey; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_schedule
    ADD CONSTRAINT cc_schedule_pkey PRIMARY KEY (id);


    --
    -- Name: cc_sess_pkey; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_sess
    ADD CONSTRAINT cc_sess_pkey PRIMARY KEY (sessid);


    --
    -- Name: cc_show_days_pkey; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_show_days
    ADD CONSTRAINT cc_show_days_pkey PRIMARY KEY (id);


    --
    -- Name: cc_show_hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_show_hosts
    ADD CONSTRAINT cc_show_hosts_pkey PRIMARY KEY (id);


    --
    -- Name: cc_show_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_show_instances
    ADD CONSTRAINT cc_show_instances_pkey PRIMARY KEY (id);


    --
    -- Name: cc_show_pkey; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_show
    ADD CONSTRAINT cc_show_pkey PRIMARY KEY (id);


    --
    -- Name: cc_show_rebroadcast_pkey; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_show_rebroadcast
    ADD CONSTRAINT cc_show_rebroadcast_pkey PRIMARY KEY (id);


    --
    -- Name: cc_smemb_id_idx; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_smemb
    ADD CONSTRAINT cc_smemb_id_idx PRIMARY KEY (id);


    --
    -- Name: cc_subjs_id_idx; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_subjs
    ADD CONSTRAINT cc_subjs_id_idx PRIMARY KEY (id);


    --
    -- Name: cc_subjs_login_idx; Type: CONSTRAINT; Schema: public; Owner: airtime; Tablespace:
    --

    ALTER TABLE ONLY cc_subjs
    ADD CONSTRAINT cc_subjs_login_idx UNIQUE (login);


    --
    -- Name: cc_access_gunid_idx; Type: INDEX; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE INDEX cc_access_gunid_idx ON cc_access USING btree (gunid);


    --
    -- Name: cc_access_parent_idx; Type: INDEX; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE INDEX cc_access_parent_idx ON cc_access USING btree (parent);


    --
    -- Name: cc_access_token_idx; Type: INDEX; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE INDEX cc_access_token_idx ON cc_access USING btree (token);


    --
    -- Name: cc_files_md5_idx; Type: INDEX; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE INDEX cc_files_md5_idx ON cc_files USING btree (md5);


    --
    -- Name: cc_files_name_idx; Type: INDEX; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE INDEX cc_files_name_idx ON cc_files USING btree (name);


    --
    -- Name: cc_perms_subj_obj_idx; Type: INDEX; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE INDEX cc_perms_subj_obj_idx ON cc_perms USING btree (subj, obj);


    --
    -- Name: cc_pref_subjid_idx; Type: INDEX; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE INDEX cc_pref_subjid_idx ON cc_pref USING btree (subjid);


    --
    -- Name: cc_sess_login_idx; Type: INDEX; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE INDEX cc_sess_login_idx ON cc_sess USING btree (login);


    --
    -- Name: cc_sess_userid_idx; Type: INDEX; Schema: public; Owner: airtime; Tablespace:
    --

    CREATE INDEX cc_sess_userid_idx ON cc_sess USING btree (userid);


    --
    -- Name: calculate_position; Type: TRIGGER; Schema: public; Owner: airtime
    --

    CREATE TRIGGER calculate_position
    AFTER INSERT OR DELETE ON cc_playlistcontents
    FOR EACH ROW
    EXECUTE PROCEDURE calculate_position();


    --
    -- Name: cc_access_owner_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_access
    ADD CONSTRAINT cc_access_owner_fkey FOREIGN KEY (owner) REFERENCES cc_subjs(id);


    --
    -- Name: cc_files_editedby_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_files
    ADD CONSTRAINT cc_files_editedby_fkey FOREIGN KEY (editedby) REFERENCES cc_subjs(id);


    --
    -- Name: cc_original_show_instance_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_show_instances
    ADD CONSTRAINT cc_original_show_instance_fkey FOREIGN KEY (instance_id) REFERENCES cc_show_instances(id) ON DELETE CASCADE;


    --
    -- Name: cc_perm_host_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_show_hosts
    ADD CONSTRAINT cc_perm_host_fkey FOREIGN KEY (subjs_id) REFERENCES cc_subjs(id) ON DELETE CASCADE;


    --
    -- Name: cc_perm_show_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_show_hosts
    ADD CONSTRAINT cc_perm_show_fkey FOREIGN KEY (show_id) REFERENCES cc_show(id) ON DELETE CASCADE;


    --
    -- Name: cc_perms_subj_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_perms
    ADD CONSTRAINT cc_perms_subj_fkey FOREIGN KEY (subj) REFERENCES cc_subjs(id) ON DELETE CASCADE;


    --
    -- Name: cc_playlist_editedby_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_playlist
    ADD CONSTRAINT cc_playlist_editedby_fkey FOREIGN KEY (editedby) REFERENCES cc_subjs(id);


    --
    -- Name: cc_playlistcontents_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_playlistcontents
    ADD CONSTRAINT cc_playlistcontents_file_id_fkey FOREIGN KEY (file_id) REFERENCES cc_files(id) ON DELETE CASCADE;


    --
    -- Name: cc_playlistcontents_playlist_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_playlistcontents
    ADD CONSTRAINT cc_playlistcontents_playlist_id_fkey FOREIGN KEY (playlist_id) REFERENCES cc_playlist(id) ON DELETE CASCADE;


    --
    -- Name: cc_pref_subjid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_pref
    ADD CONSTRAINT cc_pref_subjid_fkey FOREIGN KEY (subjid) REFERENCES cc_subjs(id) ON DELETE CASCADE;


    --
    -- Name: cc_recorded_file_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_show_instances
    ADD CONSTRAINT cc_recorded_file_fkey FOREIGN KEY (file_id) REFERENCES cc_files(id) ON DELETE CASCADE;


    --
    -- Name: cc_sess_userid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_sess
    ADD CONSTRAINT cc_sess_userid_fkey FOREIGN KEY (userid) REFERENCES cc_subjs(id) ON DELETE CASCADE;


    --
    -- Name: cc_show_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_show_instances
    ADD CONSTRAINT cc_show_fkey FOREIGN KEY (show_id) REFERENCES cc_show(id) ON DELETE CASCADE;


    --
    -- Name: cc_show_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_show_days
    ADD CONSTRAINT cc_show_fkey FOREIGN KEY (show_id) REFERENCES cc_show(id) ON DELETE CASCADE;


    --
    -- Name: cc_show_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_show_rebroadcast
    ADD CONSTRAINT cc_show_fkey FOREIGN KEY (show_id) REFERENCES cc_show(id) ON DELETE CASCADE;


    --
    -- Name: cc_show_inst_fkey; Type: FK CONSTRAINT; Schema: public; Owner: airtime
    --

    ALTER TABLE ONLY cc_schedule
    ADD CONSTRAINT cc_show_inst_fkey FOREIGN KEY (instance_id) REFERENCES cc_show_instances(id) ON DELETE CASCADE;


    --
    -- 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;


    --
    -- PostgreSQL database dump complete
    --

    Cheers,
  • Could you run that command again with this little change:

    sudo -u postgres pg_dump airtime > out.dump


    and post out.dump as an attachment. HTML messes up the character's ASCII coding.
    Airtime Pro Hosting: http://airtime.pro
  • Here's the file.
  • Ok I imported your database but you erased all your shows? I don't have the same schedules on my calendar as you did in your video.

    Airtime Pro Hosting: http://airtime.pro
  • I purged and re-installed Airtime in hopes of rectifying the issue - still same behavior - can't create a new show.
  • Also of note - when I click [Add This Show] once it does not take ... it acts as if it is going to save the show on the second click by doesn't create the program in the calendar.
  • Vote Up0Vote Down NaomiNaomi
    Posts: 228Member
    Hey, most likely the reason for this behaviour is that your session expired and you needed to login in again to Airtime if you had stepped away from your computer. We don't have a good way of informing the user they have been logged out of the app if only an ajax request is made. If you use firebug or something similar you might see a 401 response when you were trying to add more shows later.
  • Hi Naomi,

    That doesn't appear to be the issue - I reboot the server, cleared my sessions in browser, and tried again.

    This short screencast illustrates the behavior:

    http://screencast.com/t/bqauJsKmKh

  • Vote Up0Vote Down Paul BaranowskiPaul Baranowski
    Posts: 389Member, Administrator, Sourcefabric Team
    Can you run "airtime-check-system" and post the results here?


    Paul Baranowski
    CTO, Sourcefabric, http://sourcefabric.org

    +1 (416) 832-6436 (Cell)
    Skype: paulbaranowski
    720 Bathurst St. / Suite 203 / Toronto / ON / M5S 2R4 / Canada



    On Mon, Jun 20, 2011 at 12:54 PM, G Potter <
    airtime-support@lists.sourcefabric.org> wrote:

    > **
    > Hi Naomi,
    >
    > That doesn't appear to be the issue - I reboot the server, cleared my
    > sessions in browser, and tried again.
    >
    > This short screencast illustrates the behavior:
    >
    > http://screencast.com/t/bqauJsKmKh
    >
    >
    >



  • That seems to check fine.

    root@vps:~# airtime-check-system
    CPU = Intel(R) Xeon(R) CPU X3450 @ 2.67GHz
    Total RAM = 524288 kB
    Free RAM = 99632 kB
    OS = Ubuntu 10.04.2 LTS Intel 80386
    AIRTIME_CONFIG_FILES = OK
    POSTGRESQL_DATABASE = OK
    PYTHON_KOMBU_VERSION = 1.1.6
    PYTHON_POSTER_VERSION = 0.8.1
    RABBITMQ_SERVER = OK
    AIRTIME_VERSION_URL = http://localhost:80/api/version/api_key/%%api_key%%
    APACHE_CONFIGURED = YES
    AIRTIME_VERSION = 1.8.2
    PLAYOUT_ENGINE_PROCESS_ID = 20239
    PLAYOUT_ENGINE_RUNNING_SECONDS = 70624
    LIQUIDSOAP_PROCESS_ID = 19676
    LIQUIDSOAP_RUNNING_SECONDS = 70630
    ICECAST_PROCESS_ID = 19968

    -- System setup looks OK!

    - - - - - - - - - - - -


    Rabbit appears fine

    root@vps:~# rabbitmqctl status
    Status of node rabbit@vps ...
    [{running_applications,[{rabbit,"RabbitMQ","1.7.2"},
    {mnesia,"MNESIA CXC 138 12","4.4.12"},
    {os_mon,"CPO CXC 138 46","2.2.4"},
    {sasl,"SASL CXC 138 11","2.1.8"},
    {stdlib,"ERTS CXC 138 10","1.16.4"},
    {kernel,"ERTS CXC 138 10","2.13.4"}]},
    {nodes,[rabbit@vps]},
    {running_nodes,[rabbit@vps]}]
    ...done.

    - - - - - - - - - - - -


    I've attached the postgres dump as well as the airtime log directory too.