Airtime 2.1.2...Ubuntu 12.04 64bit (new install)--airtime won't install completely
  • Vote Up0Vote Down Jim BlaichJim Blaich
    Posts: 5Member
    with the latest airtime and after following the suggested installation procedures complying with each one completely I get the following messages.  Searching Google results in no suggestions that will resolve this problem.


    The top line is where the first error is seen:

    Unable to open PDO connection [wrapped: SQLSTATE[08006] [7] FATAL:  database "airtime" does not exist]
    Database connection problem.                           
    Check if database 'airtime' exists with corresponding p
    * Creating /etc/airtime                                
    * Creating /etc/monit/conf.d/monit-airtime-generic.cfg 
    * Creating /etc/cron.d/airtime-crons                   
    * Creating /usr/lib/airtime                            
    * Creating symbolic links in /usr/bin                  
    * Creating /var/log/airtime                            
    * Creating /usr/share/airtime                          
    * Creating /var/log/airtime                            
    * Creating /var/tmp/airtime                            
    * Waiting for media-monitor processes to start...      
    Starting Airtime Media Monitor: Done.                  
    * Detecting OS: ...  Found Ubuntu 12.04 LTS (precise) o
    * Clearing previous pypo cache                         
    * Waiting for pypo processes to start...               
     * Stopping daemon monitor monit                       
     * Starting daemon monitor monit                       
                                                           
    *** Verifying your system environment, running airtime-
    AIRTIME_STATUS_URL             = http://localhost:80/ap
    AIRTIME_SERVER_RESPONDING      = OK                    
    KERNEL_VERSION                 = UNKNOWN               
    MACHINE_ARCHITECTURE           = UNKNOWN               
    TOTAL_MEMORY_MBYTES            = UNKNOWN               
    TOTAL_SWAP_MBYTES              = UNKNOWN               
    AIRTIME_VERSION                = UNKNOWN               
    OS                             = Ubuntu 12.04 LTS x86_6
    CPU                            = AMD Phenom(tm) II X4 9
    WEB_SERVER                     = A
    PLAYOUT_ENGINE_PROCESS_ID      = FAILED
    PLAYOUT_ENGINE_RUNNING_SECONDS = 0
    PLAYOUT_ENGINE_MEM_PERC        = 0%
    PLAYOUT_ENGINE_CPU_PERC        = 0%
    LIQUIDSOAP_PROCESS_ID          = FAILED
    LIQUIDSOAP_RUNNING_SECONDS     = 0
    LIQUIDSOAP_MEM_PERC            = 0%
    LIQUIDSOAP_CPU_PERC            = 0%
    MEDIA_MONITOR_PROCESS_ID       = FAILED
    MEDIA_MONITOR_RUNNING_SECONDS  = 0
    MEDIA_MONITOR_MEM_PERC         = 0%
    MEDIA_MONITOR_CPU_PERC         = 0%
    RABBITMQ_PROCESS_ID            = FAILED
    RABBITMQ_RUNNING_SECONDS       = 0
    RABBITMQ_MEM_PERC              = 0%
    RABBITMQ_CPU_PERC              = 0%

    -- There appears to be a problem with your Airtime installation.

    dpkg: error processing airtime (--configure):
     subprocess installed post-installation script returned error exit status 1
    Errors were encountered while processing:
     airtime
    E: Sub-process /usr/bin/dpkg returned an error code (1)


    Would like to get this resolved.  I know there are many other people with the same problem.  This is a clean install as of a couple weeks ago--it's barely a 2 week old install of 64bit LTS Ubuntu 12.04.  


    Post edited by Adam Thomas at 2012-07-13 11:53:19
  • 11 Comments sorted by
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    Is this server edition or desktop edition? (We will try to reproduce this).

    Also what happens when you do

    sudo -u postgres psql airtime 

    from the terminal?


    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down tayfun dtayfun d
    Posts: 1Member
    Hi to all, I just  faced the same problem. 

    Martin;
    My VPS is preinstalled  Ubuntu 11.04 (GNU/Linux 2.6.32-042stab049.6 x86_64) 

    When I enter the following command via SSH I receive "could not change directory to "/root"
    psql: FATAL:  database "airtime" does not exist"

    Any chance to suggest me something ? 
    Martin Konecny said:


    Also what happens when you do

    sudo -u postgres psql airtime 

    from the terminal?





  • Vote Up0Vote Down Jim BlaichJim Blaich
    Posts: 5Member
    This is my personal workstation.  quad core, 12gb ram, 2tb storage, 64bit Ubuntu with KDE as the desktop manager.

    sudo -u postgres psql airtime

    results in:

    psql: FATAL:  database "airtime" does not exist   
    Post edited by Jim Blaich at 2012-06-22 14:37:14
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    Hi,

    I suspect your database is in non UTF-8 encoding which is required for Airtime 2.1.

    Please verify if this is the case by running the following command:

    sudo -u postgres psql -c "SHOW SERVER_ENCODING" airtime

    If this is the case, you will need to follow the instructions at this link:
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down Jim BlaichJim Blaich
    Posts: 5Member
    sudo -u postgres psql -c "SHOW SERVER_ENCODING" airtime
    [sudo] password for jimbo: 
    psql: FATAL:  database "airtime" does not exist


    I suspect all this means is that "there is no database called airtime"

    And I have to ask, why would my system lack something all the others don't lack?
    Post edited by Jim Blaich at 2012-06-26 22:05:45
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    Sorry please take off the "airtime" suffix

    sudo -u postgres psql -c "SHOW SERVER_ENCODING"
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down Jim BlaichJim Blaich
    Posts: 5Member
    udo -u postgres psql -c "SHOW SERVER_ENCODING"
     server_encoding 
    -----------------
     SQL_ASCII
    (1 row)

    As far as I know I have no databases.  I do not use any. I don't use postgres for any application that I am aware of.  And since there is no airtime database why would encoding matter?

  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    Please read this forum post:

    and

    Once you change your database to UTF8 encoding all will be fine. At the moment this is a royal pain in the butt to deal with, but unfortunately we *require* a UTF-8 based database or else files with UTF-8 encoding will not be stored properly.
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down Jim BlaichJim Blaich
    Posts: 5Member
    I don't have a database.  I don't use databases on this computer.  I don't have an airtime database to convert.  I've never used a database on this computer.  I don't have any other databases to convert.  Never had any and never will have any unless they are used by some other program without my knowledge.

    sudo apt-get purge postgres postgres-common
    [sudo] password for jimbo: 
    Reading package lists... Done
    Building dependency tree       
    Reading state information... Done
    E: Unable to locate package postgres
    E: Unable to locate package postgres-common

    Post edited by Jim Blaich at 2012-07-06 19:06:40
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    The correct command is

    sudo apt-get purge postgresql
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down Adam ThomasAdam Thomas
    Posts: 313Member
    Moved to Airtime Support.
Add a Comment