It Works! But no content
  • Vote Up0Vote Down johngoughjohngough
    Posts: 113Member
    Hi guys just installed as per the Wiki instructions and after I reboot I go localhost and get -

    It works!

    This is the default web page for this server.

    The web server software is running but no content has been added, yet.

    Where am I going wrong? The icecast server side is working and I can access the mountpoint but no Airtime.

    Any suggestions?

    Also - If we are deleting pulseaudio then where are we getting sound from? direct from gstreamer?

    Cheers
    J
  • 23 Comments sorted by
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    Hi John,

    Can you try

    "sudo rm /etc/apache2/sites-available/default-000"

    and then

    "sudo service apache2 restart"
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down johngoughjohngough
    Posts: 113Member
    Hi Martin, Thanks for the quick reply. The results are below

    johder@Editing-ubuntu:~$ sudo rm /etc/apache2/sites-available/default-000
    rm: cannot remove `/etc/apache2/sites-available/default-000': No such file or directory
    johder@Editing-ubuntu:~$ sudo service apache2 restart
    * 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 ]
    johder@Editing-ubuntu:~$



  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    hi,

    could you check for errors the logs:
    /etc/service/pypo-liquidsoap/log/main/current
    /etc/service/pypo-fetch/log/main/current
    /etc/service/pypo-push/log/main/current
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    johngough wrote on Tue, 15 February 2011 18:56
    Hi Martin, Thanks for the quick reply. The results are below

    johder@Editing-ubuntu[/email]:~$ sudo rm /etc/apache2/sites-available/default-000
    rm: cannot remove `/etc/apache2/sites-available/default-000': No such file or directory
    johder@Editing-ubuntu[/email]:~$ sudo service apache2 restart
    * 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 ]
    johder@Editing-ubuntu[/email]:~$





    John,

    My mistake, there should be a file in your /etc/apache2/site-enabled/ directory named default-000 or 000-default. Take a look in there and remove that file, and then run "sudo service apache2 restart" again.

    If you cant find that file, please run "ls /etc/apache2/sites-enabled" and post the output here.

    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down johngoughjohngough
    Posts: 113Member
    Hi Martin/Andrey

    I removed /etc/apache2/site-enabled/default-000 and can now get to the login page of Airtime but I get -

    DB:Error No Such Table - Airtime

    Andrey do you want me to post the logs? The last few lines are -

    /etc/service/pypo-fetch/log/main/curren

    @400000004d5be24d017490f4 2011/02/16 14:42:11 [single_4240:3] Prepared "/opt/pypo/files/basic/silence.mp3" (RID 0).
    @400000004d5be56b11571834 2011/02/16 14:55:29 [src_4259:3] Buffer emptied, start buffering...
    @400000004d5be56b13ba54c4 2011/02/16 14:55:29 [airtime(dot)mp3:3] Source failed (no more tracks) stopping output...
    @400000004d5be56b13c29ddc 2011/02/16 14:55:29 [airtime(dot)mp3:3] Closing connection...
    @400000004d5be56c0f57835c 2011/02/16 14:55:30 [airtime(dot)mp3:3] Connecting mount airtime.mp3 for source@127.0.0.1...
    @400000004d5be56c1811b864 2011/02/16 14:55:30 [airtime(dot)mp3:3] Connection setup was successful.

    /etc/service/pypo-liquidsoap/log/main/current

    @400000004d5be24d017490f4 2011/02/16 14:42:11 [single_4240:3] Prepared "/opt/pypo/files/basic/silence.mp3" (RID 0).
    @400000004d5be56b11571834 2011/02/16 14:55:29 [src_4259:3] Buffer emptied, start buffering...
    @400000004d5be56b13ba54c4 2011/02/16 14:55:29 [airtime(dot)mp3:3] Source failed (no more tracks) stopping output...
    @400000004d5be56b13c29ddc 2011/02/16 14:55:29 [airtime(dot)mp3:3] Closing connection...
    @400000004d5be56c0f57835c 2011/02/16 14:55:30 [airtime(dot)mp3:3] Connecting mount airtime.mp3 for source@127.0.0.1...
    @400000004d5be56c1811b864 2011/02/16 14:55:30 [airtime(dot)mp3:3] Connection setup was successful


    sudo gedit /etc/service/pypo-push/log/main/current

    @400000004d5be68237c440b4 *** Daemontools: starting daemon
    @400000004d5be6830214303c
    @400000004d5be6830214380c ###########################################
    @400000004d5be68302148a14 # *** pypo *** #
    @400000004d5be68302148dfc # Liquidsoap + External Scheduler #
    @400000004d5be683021491e4 # Playout System #
    @400000004d5be683021491e4 ###########################################
    @400000004d5be683021495cc
    @400000004d5be683021495cc
    @400000004d5be68302169584 2011-02-16 15:00:09,034 DEBUG - [api_client.py : __get_airtime_version() : line 117] - Trying to contact http://localhost/api/version/api_key/AAA
    @400000004d5be68307fcc6e4 2011-02-16 15:00:09,133 DEBUG - [api_client.py : __get_airtime_version() : line 120] - Data:
    @400000004d5be68307fcda6c Notice: Object of class DB_Error could not be converted to int in /home/johder/src/Airtime/application/models/Preference.php on line 35
    @400000004d5be68307fcea0c {"version":"1.6.0-alpha"}
    @400000004d5be6830800744c 2011-02-16 15:00:09,134 ERROR - [api_client.py : __get_airtime_version() : line 148] - Unable to detect Airtime Version - tuple index out of range, Response: <addinfourl at 157235884 whose fp = <socket._fileobject object at 0x95e7cac>>
    @400000004d5be6830803eeec Unable to get Airtime version number.
    @400000004d5be6830804259c
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    John, if you go to the following address
    http://localhost/api/version/api_key/AAA

    What do you see? You should see a line of text similar to "{"version":"1.6.0-alpha"}"
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down johngoughjohngough
    Posts: 113Member
    Fatal error: Uncaught exception 'Zend_Session_Exception' with message 'Zend_Session::start() - /home/johder/src/Airtime/library/Zend/Session.php(Line:480): Error #2 session_start(): Function spl_autoload_call() hasn't defined the class it was called for Array' in /home/johder/src/Airtime/library/Zend/Session.php:493 Stack trace: #0 /home/johder/src/Airtime/library/Zend/Session/Namespace.php( 143): Zend_Session::start(true) #1 /home/johder/src/Airtime/application/models/Preference.php(4 9): Zend_Session_Namespace->__construct('title_name') #2 /home/johder/src/Airtime/application/Bootstrap.php(78): Application_Model_Preference::GetHeadTitle() #3 /home/johder/src/Airtime/library/Zend/Application/Bootstrap/ BootstrapAbstract.php(665): Bootstrap->_initTitle() #4 /home/johder/src/Airtime/library/Zend/Application/Bootstrap/ BootstrapAbstract.php(618): Zend_Application_Bootstrap_BootstrapAbstract->_executeResource('title') #5 /home/johder/src/Airtime/library/Zend/Application/Bootstrap/ BootstrapAbstract.php(582): Zend_Application_Boot in /home/johder/src/Airtime/library/Zend/Session.php on line 493







  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    Are you using the final version, or are you still using the beta/RC?

    I think we fixed this problem for the final release.
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down johngoughjohngough
    Posts: 113Member
    I'm following -

    http://wiki.sourcefabric.org/display/CC/Installing+Airtime+f rom+Source+%28v1.6%29

    I was under the impression this was the latest version download/install procedure??

  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    Sorry for the confusion. Yes that is the latest version download/install procedure, so in that case I'm assuming you used git to download the software? Please let me know if this is the case, it might mean we have a bug in the final release.
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down johngoughjohngough
    Posts: 113Member
    No need to apologize Martin. I'm literally doing everything step by step in the install guide. I'm cutting and pasting each line(exactly) and amending files as instructed. I'm also using a clean install of Ubuntu 10.4 Lucid.

    I didn't install anything other than what is in the install guide

    I'm using the default gnome terminal and I am assuming I'm getting the code from the Git server? Do I need to install Git software before installing?

    Thanks for your help
    J

  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    John,

    As a temporary solution, try clearing your browser's cookie cache.
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down PabloPablo
    Posts: 2Member
    I'm having the same problem on Ubuntu 10.04.

    The error message is:

    Notice: Object of class DB_Error could not be converted to int in /home/pablo/airtime/application/models/Preference.php on line 35

    Fatal error: Uncaught exception 'Zend_Controller_Response_Exception' with message 'Cannot send headers; headers already sent in /home/pablo/airtime/application/models/Preference.php, line 35' in /home/pablo/airtime/library/Zend/Controller/Response/Abstrac t.php:321 Stack trace: #0 /home/pablo/airtime/library/Zend/Controller/Response/Abstrac t.php(148): Zend_Controller_Response_Abstract->canSendHeaders(true) #1 /home/pablo/airtime/library/Zend/Controller/Action/Helper/Re director.php(223): Zend_Controller_Response_Abstract->setRedirect('/login', 302) #2 /home/pablo/airtime/library/Zend/Controller/Action/Helper/Re director.php(301): Zend_Controller_Action_Helper_Redirector->_redirect('/login') #3 /home/pablo/airtime/library/Zend/Controller/Action/Helper/Re director.php(399): Zend_Controller_Action_Helper_Redirector->setGotoSimple('index', 'login', 'default', Array) #4 /home/pablo/airtime/application/controllers/plugins/Acl_plug in.php(136): Zend_Controller_Action_Helper_Redirector->gotoSimpleAndExit('index', 'login', 'default') # in /home/pablo/airtime/library/Zend/Controller/Response/Abstrac t.php on line 321

    Clearing the cookies and cache did not solved my problem.
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    Pablo,

    Please provide us the output of "/var/log/postgresql/postgresql-8.4-main.log" when this happens.
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down johngoughjohngough
    Posts: 113Member
    Hi Martin, I'm still having this problem on my studio machine, however everything works fine on another machine of same spec at home. Strange??

    Here is the log output from - /var/log/postgresql/postgresql-8.4-main.log

    2011-02-22 11:57:01 GMT LOG: database system was shut down at 2011-02-22 11:57:00 GMT
    2011-02-22 11:57:01 GMT LOG: incomplete startup packet
    2011-02-22 11:57:01 GMT LOG: database system is ready to accept connections
    2011-02-22 11:57:01 GMT LOG: autovacuum launcher started
    2011-02-22 12:33:22 GMT ERROR: table "cc_access" does not exist
    2011-02-22 12:33:22 GMT STATEMENT:

    DROP TABLE "cc_access" CASCADE
    2011-02-22 12:33:22 GMT ERROR: table "cc_backup" does not exist
    2011-02-22 12:33:22 GMT STATEMENT:

    DROP TABLE "cc_backup" CASCADE
    2011-02-22 12:33:22 GMT ERROR: table "cc_files" does not exist
    2011-02-22 12:33:22 GMT STATEMENT:
    DROP TABLE "cc_files" CASCADE
    2011-02-22 12:33:22 GMT ERROR: table "cc_perms" does not exist
    2011-02-22 12:33:22 GMT STATEMENT:

    DROP TABLE "cc_perms" CASCADE
    2011-02-22 12:33:22 GMT ERROR: table "cc_show" does not exist
    2011-02-22 12:33:22 GMT STATEMENT:

    DROP TABLE "cc_show" CASCADE
    2011-02-22 12:33:23 GMT ERROR: table "cc_show_instances" does not exist
    2011-02-22 12:33:23 GMT STATEMENT:
    DROP TABLE "cc_show_instances" CASCADE
    2011-02-22 12:33:23 GMT ERROR: table "cc_show_days" does not exist
    2011-02-22 12:33:23 GMT STATEMENT:
    DROP TABLE "cc_show_days" CASCADE
    2011-02-22 12:33:23 GMT ERROR: table "cc_show_hosts" does not exist
    2011-02-22 12:33:23 GMT STATEMENT:
    DROP TABLE "cc_show_hosts" CASCADE
    2011-02-22 12:33:23 GMT ERROR: table "cc_playlist" does not exist
    2011-02-22 12:33:23 GMT STATEMENT:
    DROP TABLE "cc_playlist" CASCADE
    2011-02-22 12:33:23 GMT ERROR: table "cc_playlistcontents" does not exist
    2011-02-22 12:33:23 GMT STATEMENT:
    DROP TABLE "cc_playlistcontents" CASCADE
    2011-02-22 12:33:23 GMT ERROR: table "cc_pref" does not exist
    2011-02-22 12:33:23 GMT STATEMENT:
    DROP TABLE "cc_pref" CASCADE
    2011-02-22 12:33:23 GMT ERROR: table "cc_schedule" does not exist
    2011-02-22 12:33:23 GMT STATEMENT:

    DROP TABLE "cc_schedule" CASCADE
    2011-02-22 12:33:23 GMT ERROR: table "cc_sess" does not exist
    2011-02-22 12:33:23 GMT STATEMENT:
    DROP TABLE "cc_sess" CASCADE
    2011-02-22 12:33:23 GMT ERROR: table "cc_smemb" does not exist
    2011-02-22 12:33:23 GMT STATEMENT:

    DROP TABLE "cc_smemb" CASCADE
    2011-02-22 12:33:24 GMT ERROR: table "cc_subjs" does not exist
    2011-02-22 12:33:24 GMT STATEMENT:
    DROP TABLE "cc_subjs" CASCADE
    2011-02-22 12:33:24 GMT ERROR: table "cc_trans" does not exist
    2011-02-22 12:33:24 GMT STATEMENT:
    DROP TABLE "cc_trans" CASCADE
    2011-02-22 12:33:24 GMT ERROR: sequence "schedule_group_id_seq" does not exist
    2011-02-22 12:33:24 GMT STATEMENT: DROP SEQUENCE schedule_group_id_seq CASCADE
    2011-02-22 12:33:24 GMT ERROR: sequence "show_group_id_seq" does not exist
    2011-02-22 12:33:24 GMT STATEMENT:
    DROP SEQUENCE show_group_id_seq CASCADE
    2011-02-22 12:33:24 GMT ERROR: function calculate_position() does not exist
    2011-02-22 12:33:24 GMT STATEMENT: DROP FUNCTION calculate_position() CASCADE
    2011-02-22 12:33:24 GMT ERROR: function show_content() does not exist
    2011-02-22 12:33:24 GMT STATEMENT:
    DROP FUNCTION show_content() CASCADE
    2011-02-22 12:33:24 GMT ERROR: relation "cc_show_schedule" does not exist
    2011-02-22 12:33:24 GMT STATEMENT:
    CREATE TRIGGER show_content AFTER INSERT OR DELETE ON cc_show_schedule
    FOR EACH ROW EXECUTE PROCEDURE show_content()
    2011-02-22 12:35:18 GMT LOG: incomplete startup packet
    2011-02-22 12:35:19 GMT LOG: received fast shutdown request
    2011-02-22 12:35:19 GMT LOG: aborting any active transactions
    2011-02-22 12:35:19 GMT LOG: autovacuum launcher shutting down
    2011-02-22 12:35:19 GMT LOG: shutting down
    2011-02-22 12:35:21 GMT LOG: database system is shut down
    2011-02-22 12:36:04 GMT LOG: database system was shut down at 2011-02-22 12:35:21 GMT
    2011-02-22 12:36:04 GMT LOG: incomplete startup packet
    2011-02-22 12:36:04 GMT LOG: database system is ready to accept connections
    2011-02-22 12:36:04 GMT LOG: autovacuum launcher started
  • Vote Up0Vote Down johngoughjohngough
    Posts: 113Member
    Ok I'm fixed.

    I didn't save changes to the apache config file.

    Pablo maybe check all the lines again I forgot to ammend - upload_tmp_dir = /tmp or it didn't save with all the other changes.
    Also some lines need to be uncommented i.e timezone

    Hope this helps.
    Thanks sourcefabric. Airtime looks great.
    J
  • Vote Up0Vote Down mellowtothemaxmellowtothemax
    Posts: 37Member
    Unfortunately I am still receiving the error 'DB Error:no such table' when i try to access localhost. The login page loads but I am unable to log in.

    I have checked and rechecked the installation procedure.

    I am running it on a new installed virtual machine in Virtualbox which might cause the problem but I doubt it since it looks like a database issue.

    Any help would be much appreciated.

    Attached is the file /var/log/postgresql/postgresql-8.4-main.log
  • Vote Up0Vote Down Ofir GalOfir Gal
    Posts: 130Member
    Try to re-install Airtime

    /airtime/install/php airtime-uninstall.php
    /airtime/install/php airtime-install.php

    Please look for any error messages in the installation.
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    mttm,

    I'm not sure why your cc_pref table is missing, but the quick way to try and fix this is just reinstall as Ofir mentioned. If this doesn't work, please provide us with the information displayed during install.
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down mellowtothemaxmellowtothemax
    Posts: 37Member
    OK, my apologies it seems I had missed a couple of lines in the installation procedure

    sudo pear channel-discover pear.phing.info
    sudo pear install phing/phing-2.4.2

    I thought it was for debian only.

    Anyway I had tried the uninstall script as mentioned but the table airtime would not delete fully and when I run the install script, it would not recreate the database as it existed already. I could not manually delete the table in postgresql using 'dropdb airtime' (I am not very familiar with it). I kept getting the error 'users are still connected to it' and so I just re-installed the OS in Virtualbox and started the installation from scratch, this time including the 2 lines I had missed.

    The error message does not appear when I access localhost anymore and I can fully log in to the web user interface.

    Thank you for your assistance
  • Vote Up0Vote Down Ofir GalOfir Gal
    Posts: 130Member
    Great news mellowtothemax.

    I've edited the installation wiki
    to make the "Debian only" section clearer.
  • Vote Up0Vote Down VerheekVerheek
    Posts: 158Member
    Seems to me it was necessary to restart apache2 after running the uninstall and then running it again to drop the database and user. But I haven't had to do the restart in subsequent versions.

    Jeremy
  • Vote Up0Vote Down Marcus V Magalhães Marcus V Magalhães 
    Posts: 6Member
    sudo rm /etc/apache2/sites-enabled/000-default
    sudo service apache2 restart
Add a Comment