errors installing airtime 1.9.5 - Airtime Support Discussions on Sourcefabric Forum

Ed Boon

Hi,

i'm trying to get airtime 1.9.5 to work on debian squeeze. i can see the login page, but it has "DB Error: no such table" in the header.

Furthermore i can see the following errors in the logs:

On install:

apt-get install airtime

Reading package lists... Done

Building dependency tree

Reading state information... Done

Suggested packages:

airtime-audio-samples

The following NEW packages will be installed:

airtime

.....

phing/phing is already installed and is the same as the released version 2.4.2

.....

Detaching from the console

icecast2.

[2012-01-13 21:58:49] WARN cfgfile/parse_xml_tags unknown element "threadpool" parsing "limits" at line 5

[2012-01-13 21:58:49] WARN cfgfile/parse_xml_tags unknown element "burst-on-connect" parsing "limits" at line 16

1709

1716

1719

Setting monit configuration...

.....

Ensuring python-virtualenv version > 1.4.8...Success!

....

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

* Failed inserting /srv/airtime/stor/ in cc_music_dirs

* Message DB Error: no such table

* Creating /usr/bin symlinks

* Installing airtime-import

* Installing airtime-update-db-settings

* Installing airtime-check-system

* Installing airtime-user

* Creating logs directory /var/log/airtime

* Creating Cron File

....

*** Verifying your system environment ***

.....

AIRTIME_VERSION_URL = http://localhost:80/api/version/api_key/%%api_key%%

APACHE_CONFIGURED = NO

AIRTIME_VERSION = Could not contact server

....

-- WARNING! It looks like the Liquidsoap engine is continually restarting.

-- 2012/01/13 21:59:29 [protocols.external:3] Didn't find "ufetch".

-- 2012/01/13 21:59:29 [protocols.external:3] Found "/usr/bin/wget".

-- 2012/01/13 21:59:29 [main:3] Liquidsoap 1.0.0-beta2

-- 2012/01/13 21:59:29 [main:3] Using: pcre=6.0.1 dtools=0.2.2 duppy=0.4.0 duppy.syntax=0.4.0 cry=0.2.0 mm=0.1.0 xmlplaylist=0.1.2 ogg=0.4.2 vorbis=0.6.0 mad=0.4.2 flac=0.1.0 flac.ogg=0.1.0 lame=0.3.0 alsa=0.2.1 samplerate=0.1.1 taglib=0.1.4 camomile=0.7.1 portaudio=@VERSION ladspa=0.1.2

-- 2012/01/13 21:59:29 [dynamic.loader:2] Could not load plugins in directory /usr/local/lib/liquidsoap/1.0.0-beta2/plugins.

-- 2012/01/13 21:59:29 [lang:3] Lastfm/audioscrobbler support was not compiled.

-- 2012/01/13 21:59:29 [frame:3] Using 44100Hz audio, 25Hz video, 44100Hz master.

-- 2012/01/13 21:59:29 [frame:3] Frame size must be a multiple of 1764 ticks = 1764 audio samples = 1 video samples.

-- 2012/01/13 21:59:29 [frame:3] Targetting 'frame.duration': 0.04s = 1764 audio samples = 1764 ticks.

-- 2012/01/13 21:59:29 [frame:3] Frames last 0.04s = 1764 audio samples = 1 video samples = 1764 ticks.

MEDIA_MONITOR_PROCESS_ID = 20367

MEDIA_MONITOR_RUNNING_SECONDS = 6

SHOW_RECORDER_PROCESS_ID = 20349

SHOW_RECORDER_RUNNING_SECONDS = 7

ICECAST_PROCESS_ID = 19889

-- There appears to be problems with your setup. Please visit

pypo.log:

2012-01-13 22:02:00,122 ERROR - [api_client.py : __get_airtime_version() : line 198] - Unable to detect Airtime Version - No JSON object could be decoded

2012-01-13 22:02:00,123 INFO - [api_client.py : is_server_compatible() : line 224] - Unable to get Airtime version number.

2012-01-13 22:02:05,130 DEBUG - [api_client.py : __get_airtime_version() : line 186] - Trying to contact http://localhost:80/api/version/api_key/%%api_key%%

2012-01-13 22:02:05,137 DEBUG - [api_client.py : __get_airtime_version() : line 193] - Data: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">

<title>403 Forbidden</title>

</head><body>

<h1>Forbidden</h1>

<p>You don't have permission to access /api/version/api_key/OCWZY7XT3F8NPLUGDM6A

on this server.</p>

<hr>

<address>Apache Server at localhost Port 80</address>

</body></html>

2012-01-13 22:02:05,138 ERROR - [api_client.py : __get_airtime_version() : line 198] - Unable to detect Airtime Version - No JSON object could be decoded

2012-01-13 22:02:05,139 INFO - [api_client.py : is_server_compatible() : line 224] - Unable to get Airtime version number.

pypo-liquidsoap/ls_script.log:

2012/01/13 22:21:00 >>> LOG START

2012/01/13 22:21:00 [protocols.external:3] Didn't find "ufetch".

2012/01/13 22:21:00 [protocols.external:3] Found "/usr/bin/wget".

2012/01/13 22:21:00 [main:3] Liquidsoap 1.0.0-beta2

2012/01/13 22:21:00 [main:3] Using: pcre=6.0.1 dtools=0.2.2 duppy=0.4.0 duppy.syntax=0.4.0 cry=0.2.0 mm=0.1.0 xmlplaylist=0.1.2 ogg=0.4.2 vorbis=0.6.0 mad=0.4.2 flac=0.1.0 flac.ogg=0.1.0 lame=0.3.0 alsa=0.2.1 samplerate=0.1.1 taglib=0.1.4 camomile=0.7.1 portaudio=@VERSION ladspa=0.1.2

2012/01/13 22:21:00 [dynamic.loader:2] Could not load plugins in directory /usr/local/lib/liquidsoap/1.0.0-beta2/plugins.

2012/01/13 22:21:00 [lang:3] Lastfm/audioscrobbler support was not compiled.

2012/01/13 22:21:00 [frame:3] Using 44100Hz audio, 25Hz video, 44100Hz master.

2012/01/13 22:21:00 [frame:3] Frame size must be a multiple of 1764 ticks = 1764 audio samples = 1 video samples.

2012/01/13 22:21:00 [frame:3] Targetting 'frame.duration': 0.04s = 1764 audio samples = 1764 ticks.

2012/01/13 22:21:00 [frame:3] Frames last 0.04s = 1764 audio samples = 1 video samples = 1764 ticks.

airtime error.log:

[Fri Jan 13 22:22:33 2012] [error] [client 80.247.163.30] PHP Notice: Object of class DB_Error could not be converted to int in /usr/share/airtime/application/models/Preference.php on line 54

pypo debug.log:

2012-01-13 22:23:01,381 DEBUG - [api_client.py : __get_airtime_version() : line 117] - Trying to contact http://airtime.jigr.net/api/version/api_key/SJ1LOYW4YPKMVCK1GJ5Y

2012-01-13 22:23:01,514 DEBUG - [api_client.py : __get_airtime_version() : line 117] - Trying to contact http://airtime.jigr.net/api/version/api_key/SJ1LOYW4YPKMVCK1GJ5Y

/var/log/pypo/ls_script.log:

2012/01/13 21:58:49 [airtime(dot)mp3:2] Cry socket error: could not write data to host: Unix.Unix_error(56, "write", "")!

2012/01/13 21:58:49 [airtime(dot)mp3:3] Closing connection...

2012/01/13 21:58:49 [airtime(dot)mp3:3] Will try to reconnect in 5 seconds.

2012/01/13 21:58:54 [airtime(dot)ogg:2] Cry socket error: could not write data to host: Unix.Unix_error(56, "write", "")!

2012/01/13 21:58:54 [airtime(dot)ogg:3] Closing connection...

2012/01/13 21:58:54 [airtime(dot)ogg:3] Will try to reconnect in 5 seconds.

2012/01/13 21:58:55 [airtime(dot)mp3:3] Connecting mount airtime.mp3 for source@127.0.0.1...

2012/01/13 21:58:55 [airtime(dot)mp3:3] Connection setup was successful.

2012/01/13 21:59:00 [airtime(dot)ogg:3] Connecting mount airtime.ogg for source@127.0.0.1...

2012/01/13 21:59:00 [airtime(dot)ogg:3] Connection setup was successful.

I don't seem to find an answer on the forum. I do have ISPConfig 3 installed, but i don't see a conflict there.

Hope you can help. This is bugging me for some days now.

Thanks in advance.

Ed

Martin Konecny

None of the services can connect to apache via localhost. Is that setup properly?

Ed Boon

Well, all of the other sites, running Joomla or Wordpress in ISPConfig work fine. I can see the login page, but cannot log in. What bugs me is the following during install:

* Inserting stor directory location /srv/airtime/stor/ into music_dirs table

* Failed inserting /srv/airtime/stor/ in cc_music_dirs

* Message DB Error: no such table

I'm not a Postgresql expert. If you could give me some troubleshoot pointers, i'd greatly appreciate it.

Ed

Ed Boon

Never mind this one. I started from scratch again. Have no idea why the tables where not inserted.

Posted a 403 question i'm now having.

Ed

Howdy, Stranger!

Categories

Poll

Top Posters