Postgresql UTF8 problem
  • Vote Up0Vote Down KR4KOSKR4KOS
    Posts: 12Member
    Hello,

    I have a problem with Postgresql

        warning: no files found matching '*.pot' under directory 'pytz'
        warning: no previously-included files found matching 'test_zdump.py'
    Successfully installed amqplib anyjson argparse configobj docopt kombu mutagen poster PyDispatcher pyinotify pytz
    Cleaning up...
    * Checking for user pypo
     * Creating user pypo
    * Creating INI files
    * Initializing INI files
    * Airtime Version: 2.5.1
    * 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
     * Unfortunately your postgresql database has not been created using a UTF-8 encoding.
     * As of Airtime 2.1, installs will fail unless the encoding has been set to UTF-8. Please verify this is the case
     * and try the install again
    There was an error during install. Exit code 1
    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)


    Can you help me ?
    I have tested to purge and reinstall postgresql but doesn't work
  • 3 Comments sorted by
  • Vote Up0Vote Down Voisses TechVoisses Tech
    Posts: 1,423Member
    What cause this problem?
    • Did you do an upgrade?
    • Is this a new installation
    • Did you amend something in the database?

    When did this occur?

    • by adding or changing any settings


    basically give some more details why you felt this occur.


    Good Luck

    VOISSES


    Anyone reading this a find it funny about my grammar , I make no apology ,Go get a translator.
    "The Problem with education today is that it takes a university degree to switch on a light bulb"
    "You learn from your mistakes but wise people learn from others mistakes avoid Making mistakes there is not sufficient rooms to make them"
    "Innuendo","If's","Assumptions" and "Fear" are for politician.Who,What,where,When and How are for those seeking knowledge and care about Humanity.
    "I might be in Mud but that does not Make me a Wild Hog(pig)"
    “Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius — and a lot of courage to move in the opposite direction.”
    "The only thing that remains constant is change itself"
    May the force be with you,until our path or destiny bring us in tandem.
  • Vote Up0Vote Down David DerzsiDavid Derzsi
    Posts: 1Member
    hello

    i have the same problem. i'm trying to install airtime 2.5.1 using easy install on ubuntu 12.04.4 x64 VPS from digital ocean. Tried to reinstall the postgresql package several times but no luck, changed the locale to en_US.utf8 on the server beacause i was getting locale warning when i was doing apt-get update etc. 

    dtk@drvsrv:~/airtime$ sudo -u postgres psql -l
    [sudo] password for dtk: 
    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"?

    Is this normal?

    nothing else installed on the server, only planning to use it for airtime.

    dtk@drvsrv:~/airtime$ sudo apt-get install airtime
    Reading package lists... Done
    Building dependency tree       
    Reading state information... Done
    airtime is already the newest version.
    0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
    1 not fully installed or removed.
    After this operation, 0 B of additional disk space will be used.
    Do you want to continue [Y/n]? y
    Setting up airtime (2.5.1-1) ...
    Setting up apache2...
    Site airtime-vhost.conf disabled.
    To activate the new configuration, you need to run:
      service apache2 reload
    Enabling site airtime-vhost.conf.
    To activate the new configuration, you need to run:
      service apache2 reload
    Module rewrite already enabled
    Site default already disabled
    Configuring php5...
     * Restarting web server apache2                                                apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
     ... waiting apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
                                                                             [ OK ]
    Setting up icecast2...
    Restarting icecast2: Starting icecast2
    Detaching from the console
    icecast2.
    Setting up monit configuration...
     * Stopping daemon monitor monit                                         [ OK ] 
     * Starting daemon monitor monit                                         [ OK ] 
    Liquidsoap symlink points to the right place!
    * Making sure /etc/default/locale is set properly
    LANG=en_US.UTF-8
    * Checking for existing Airtime installation...
     * None found.
    * Temporarily stopping any previous running services

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

    *** Creating Virtualenv for Airtime ***
    Already using interpreter /usr/bin/python
    The --no-site-packages flag is deprecated; it is now the default behavior.
    New python executable in /usr/lib/airtime/airtime_virtualenv/bin/python
    Installing distribute.............................................................................................................................................................................................done.
    Installing pip...............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
        
    Requirement already satisfied (use --upgrade to upgrade): wsgiref in /usr/lib/python2.7
    Downloading/unpacking anyjson
      Running setup.py egg_info for package anyjson
        
    Downloading/unpacking configobj
      Running setup.py egg_info for package configobj
        
    Downloading/unpacking kombu
      Running setup.py egg_info for package kombu
        
    Downloading/unpacking amqplib
      Running setup.py egg_info for package amqplib
        
    Downloading/unpacking PyDispatcher
      Running setup.py egg_info for package PyDispatcher
        
        warning: no previously-included files matching '*.bat' found anywhere in distribution
        warning: no previously-included files matching './CVS' found anywhere in distribution
        warning: no previously-included files matching '.cvsignore' found anywhere in distribution
    Requirement already satisfied (use --upgrade to upgrade): argparse in /usr/lib/python2.7
    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'
    Downloading/unpacking mutagen
      Running setup.py egg_info for package mutagen
        
    Downloading/unpacking poster
      Running setup.py egg_info for package poster
        
    Downloading/unpacking docopt
      Running setup.py egg_info for package docopt
        
    Installing collected packages: pyinotify, anyjson, configobj, kombu, amqplib, PyDispatcher, pytz, mutagen, poster, docopt
      Running setup.py install for pyinotify
        
      Running setup.py install for anyjson
        
      Running setup.py install for configobj
        
      Running setup.py install for kombu
        
      Running setup.py install for amqplib
        
      Running setup.py install for PyDispatcher
        
        warning: no previously-included files matching '*.bat' found anywhere in distribution
        warning: no previously-included files matching './CVS' found anywhere in distribution
        warning: no previously-included files matching '.cvsignore' found anywhere in distribution
      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'
      Running setup.py install for mutagen
        changing mode of build/scripts-2.7/mutagen-pony from 644 to 755
        changing mode of build/scripts-2.7/mid3iconv from 644 to 755
        changing mode of build/scripts-2.7/moggsplit from 644 to 755
        changing mode of build/scripts-2.7/mutagen-inspect from 644 to 755
        changing mode of build/scripts-2.7/mid3v2 from 644 to 755
        
        changing mode of /usr/lib/airtime/airtime_virtualenv/bin/mutagen-pony 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-inspect to 755
        changing mode of /usr/lib/airtime/airtime_virtualenv/bin/mid3v2 to 755
      Running setup.py install for poster
        
      Running setup.py install for docopt
        
    Successfully installed pyinotify anyjson configobj kombu amqplib PyDispatcher pytz mutagen poster docopt
    Cleaning up...
    * Checking for user pypo
    User already exists.
    * Creating INI files
    * Initializing INI files
    * Airtime Version: 2.5.1
    * 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
     * Unfortunately your postgresql database has not been created using a UTF-8 encoding.
     * As of Airtime 2.1, installs will fail unless the encoding has been set to UTF-8. Please verify this is the case
     * and try the install again
    There was an error during install. Exit code 1
    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)

    Post edited by David Derzsi at 2014-06-05 07:04:13
  • Vote Up0Vote Down KR4KOSKR4KOS
    Posts: 12Member
    It's Debian 6
    New Install
    Upgraded
    I have not changed anything in the database

Add a Comment