[SOLVED] PSQL error? (Debian)
  • Vote Up0Vote Down Mike NMike N
    Posts: 17Member
    root@server2:~# sudo -u postgres psql -l
    could not change directory to "/root"
    psql: could not connect to server: No such file or directory
            Is the server running locally and accepting
            connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

    I get this error once I re-install.
    Post edited by Mike N at 2012-09-04 06:19:42
  • 4 Comments sorted by
  • Vote Up0Vote Down Mike NMike N
    Posts: 17Member
    I have now fixed that error and I am now greeted with a new one.

    ******************************** Install Begin *********************************
    Ensuring python-virtualenv version > 1.4.8...Success!

    *** Creating Virtualenv for Airtime ***
    Already using interpreter /usr/bin/python
    New python executable in /usr/lib/airtime/airtime_virtualenv/bin/python
    Installing distribute.................................................................................................................................................................................done.

    *** Installing Python Libraries ***
    Unpacking /var/lib/airtime/tmp/python_apps/python-virtualenv/airtime_virtual_env.pybundle
    Downloading/unpacking pyinotify
      Running setup.py egg_info for package pyinotify
    Downloading/unpacking anyjson
      Running setup.py egg_info for package anyjson
    Downloading/unpacking poster
      Running setup.py egg_info for package poster
    Downloading/unpacking amqplib
      Running setup.py egg_info for package amqplib
    Downloading/unpacking mutagen
      Running setup.py egg_info for package mutagen
    Downloading/unpacking kombu
      Running setup.py egg_info for package kombu
    Downloading/unpacking configobj
      Running setup.py egg_info for package configobj
    Downloading/unpacking pytz
      Running setup.py egg_info for package pytz
        warning: no files found matching '*.pot' under directory 'pytz'
        warning: no previously-included files found matching 'test_zdump.py'
    Installing collected packages: amqplib, anyjson, configobj, kombu, mutagen, poster, pyinotify, pytz
      Running setup.py install for amqplib
      Running setup.py install for anyjson
      Running setup.py install for configobj
      Running setup.py install for kombu
      Running setup.py install for mutagen
        changing mode of build/scripts-2.6/mid3v2 from 644 to 755
        changing mode of build/scripts-2.6/mid3iconv from 644 to 755
        changing mode of build/scripts-2.6/moggsplit from 644 to 755
        changing mode of build/scripts-2.6/mutagen-pony from 644 to 755
        changing mode of build/scripts-2.6/mutagen-inspect from 644 to 755
        changing mode of /usr/lib/airtime/airtime_virtualenv/bin/mid3v2 to 755
        changing mode of /usr/lib/airtime/airtime_virtualenv/bin/mid3iconv to 755
        changing mode of /usr/lib/airtime/airtime_virtualenv/bin/moggsplit to 755
        changing mode of /usr/lib/airtime/airtime_virtualenv/bin/mutagen-pony to 755
        changing mode of /usr/lib/airtime/airtime_virtualenv/bin/mutagen-inspect to 755
      Running setup.py install for poster
      Running setup.py install for pyinotify
      Running setup.py install for pytz
        warning: no files found matching '*.pot' under directory 'pytz'
        warning: no previously-included files found matching 'test_zdump.py'
    Successfully installed amqplib anyjson configobj kombu mutagen poster pyinotify pytz
    Cleaning up...

    *** Patching Python Libraries ***
     * Patching virtualenv libraries in /usr/lib/airtime/airtime_virtualenv/lib/python2.6

       ---Applying Patches for mutagen---
    patching file site-packages/mutagen/mp3.py
    Hunk #1 succeeded at 205 (offset -4 lines).
    patching file site-packages/mutagen/mp3.py
    Hunk #2 succeeded at 169 (offset -4 lines).
    * Checking for user pypo
     * Creating user pypo
    * Creating INI files
    * Initializing INI files
    * Airtime Version: 2.1.3
    * Storage directory setup
    * Skipping directory already exists: /srv/airtime/stor
    * Giving Apache permission to access /srv/airtime/stor
    * Skipping directory already exists: /srv/airtime/stor/organize
    * Giving Apache permission to access /srv/airtime/stor/organize
    * Checking database for correct encoding

    * Database Installation
     * Creating Airtime database user
      * Database user 'airtime' created.
     * Creating Airtime database
      * Database 'airtime' created.
     * Installing Postgres scripting language
     * Creating database tables
     * Setting Airtime version
     * Inserting stor directory location /srv/airtime/stor/ into music_dirs table
    * 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 Debian GNU/Linux 6.0.4 (squeeze) (squeeze) on i386 architecture
    * Clearing previous pypo cache
    * Waiting for pypo processes to start...
    Stopping daemon monitor: monit.
    Starting daemon monitor: monit.

    *** Verifying your system environment, running airtime-check-system ***
    AIRTIME_SERVER_RESPONDING      = OK
    KERNEL_VERSION                 = 2.6.32-042stab055.10
    MACHINE_ARCHITECTURE           = i686
    TOTAL_MEMORY_MBYTES            = 131072
    TOTAL_SWAP_MBYTES              = UNKNOWN
    AIRTIME_VERSION                = 2.1.3
    OS                             = Debian GNU/Linux 6.0.4 (squeeze) i686
    CPU                            = Intel(R) Xeon(R) CPU           L5630  @ 2.13GHz
    WEB_SERVER                     = Apache/2.2.16 (Debian)
    PLAYOUT_ENGINE_PROCESS_ID      = 25281
    PLAYOUT_ENGINE_RUNNING_SECONDS = 51
    PLAYOUT_ENGINE_MEM_PERC        = 5.0%
    PLAYOUT_ENGINE_CPU_PERC        = 0.4%
    LIQUIDSOAP_PROCESS_ID          = 25284
    LIQUIDSOAP_RUNNING_SECONDS     = 51
    LIQUIDSOAP_MEM_PERC            = 2.4%
    LIQUIDSOAP_CPU_PERC            = 1.3%
    MEDIA_MONITOR_PROCESS_ID       = 25222
    MEDIA_MONITOR_RUNNING_SECONDS  = 58
    MEDIA_MONITOR_MEM_PERC         = 4.4%
    MEDIA_MONITOR_CPU_PERC         = 0.0%
    RABBITMQ_PROCESS_ID            = FAILED
    RABBITMQ_RUNNING_SECONDS       = -1
    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
    configured to not write apport reports
                                          Errors were encountered while processing:
     airtime
    E: Sub-process /usr/bin/dpkg returned an error code (1)

  • Vote Up0Vote Down Mike NMike N
    Posts: 17Member
    Fixed.
  • Vote Up0Vote Down Albert FRAlbert FR
    Posts: 1,978Member, Airtime Moderator
    fo others people that's be a good thing to explain how ... :D
    ----
    Je peux le faire ;) [Pour vous] / I can do it [For You] Gnu/Linux & Media Architect
    Co-founder NessRadio.com
  • Vote Up0Vote Down Mike NMike N
    Posts: 17Member
    All I had to do was re-install RabbitMQ manually & start it up once. 
Add a Comment