Discussions
Activity
Sign In
How it works
Airtime Support
Probably A Total N00b Question BUT We're Having Trouble Restoring A Database After a Clean Install
Vote Up
0
Vote Down
Bob Zurunclε
September 2012
Posts: 113
Member
We've been using Airtime for a while and have become fairly familiar with installing and restoring from the command line
We are now running into problems on restoring the database and getting a Permission denied message
The only difference is we are installing Airtime on a FRESH install of Pinguy (Ubuntu 12.04 64 bit)
Here are the steps
We backed up the database
sudo -u postgres pg_dumpall | gzip -c > airtime-backup.2.1.3.full.gz
Grabbed and un-tarr'd the proggie
gunzip airtime-backup.2.1.3.full.gz
Ran the install
sudo ~/airtime-2.1.3/install_full/ubuntu/airtime-full-install -r
The install checks out OK
*** Verifying your system environment, running airtime-check-system ***
AIRTIME_STATUS_URL =
http://localhost:80/api/status/format/json/api_key/%%api_key%%
AIRTIME_SERVER_RESPONDING = OK
KERNEL_VERSION = 3.2.0-25-generic
MACHINE_ARCHITECTURE = x86_64
TOTAL_MEMORY_MBYTES = 2051056
TOTAL_SWAP_MBYTES = 3119600
AIRTIME_VERSION = 2.1.3
OS = Ubuntu 12.04 LTS x86_64
CPU = Intel(R) Atom(TM) CPU D510 @ 1.66GHz
WEB_SERVER = Apache/2.2.22 (Ubuntu)
PLAYOUT_ENGINE_PROCESS_ID = 5468
PLAYOUT_ENGINE_RUNNING_SECONDS = 13
PLAYOUT_ENGINE_MEM_PERC = 0.7%
PLAYOUT_ENGINE_CPU_PERC = 0.0%
LIQUIDSOAP_PROCESS_ID = 5471
LIQUIDSOAP_RUNNING_SECONDS = 13
LIQUIDSOAP_MEM_PERC = 0.8%
LIQUIDSOAP_CPU_PERC = 3.9%
MEDIA_MONITOR_PROCESS_ID = 5412
MEDIA_MONITOR_RUNNING_SECONDS = 13
MEDIA_MONITOR_MEM_PERC = 0.6%
MEDIA_MONITOR_CPU_PERC = 0.4%
RABBITMQ_PROCESS_ID = 1915
RABBITMQ_RUNNING_SECONDS = 899
RABBITMQ_MEM_PERC = 1.3%
RABBITMQ_CPU_PERC = 0.0%
-- Your installation of Airtime looks OK!
******************************* Install Complete *******************************
We clear the database as a precaution as we always have
sudo -u postgres dropdb airtime ## just In case
The restore the database
sudo -u postgres psql -f airtime-backup.2.1.3.full postgres
This is where we get the error "permission denied"
Any suggestions?
5 Comments
sorted by
Votes
Date Added
Vote Up
0
Vote Down
Martin Konecny
September 2012
Posts: 1,860
Member
I think the problem is that you are restoring to the postgres db instead of the airtime db.
Try
sudo -u postgres psql -f airtime-backup.2.1.3.full
airtime
Airtime Pro Hosting:
http://airtime.pro
Vote Up
0
Vote Down
Bob Zurunclε
September 2012
Posts: 113
Member
I did try that too and getting the same "permission denied"
Vote Up
0
Vote Down
Bob Zurunclε
September 2012
Posts: 113
Member
Never mind
When I moved the files over from the backup I needed to change the permission/owner (chown)
Duh!
Thanks!
Post edited by Bob Zurunclε at 2012-09-24 13:19:54
Vote Up
0
Vote Down
Bob Zurunclε
September 2012
Posts: 113
Member
However, there is a problem...
All the playlists are empty
Would that have to do with the mount point being specific and needing to be the EXACT as before?
I've replicated the exact path names/mount point names and still nothing...
All the files have appeared and play fine
Thanks Martin!
Post edited by Bob Zurunclε at 2012-09-24 22:50:26
Vote Up
0
Vote Down
Bob Zurunclε
September 2012
Posts: 113
Member
Again disregard...
I just did a complete flush and reinstall of airtime and the database
The tracks repopulated the play lists
then ran
sudo -u postgres psql airtime -c "UPDATE cc_files set file_exists = 't'"
Thanks!
Add a Comment
Start a New Discussion
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In
Apply for Membership
Categories
All Discussions
8,397
Sourcefabric
↳
Announcements
25
Newscoop
↳
Newscoop Support
2,189
↳
Newscoop Development
722
↳
Newscoop Security
13
↳
Newscoop Documentation
17
↳
Newscoop Themes
69
Airtime
↳
Airtime Support
3,139
↳
Airtime Development
1,286
↳
Airtime Français
146
↳
Airtime Documentation
14
↳
Airtime Hacks
102
↳
Promote your station!
37
↳
Airtime Security
11
Booktype
↳
Booktype Support
277
↳
Booktype Development
55
↳
Booktype Documentation
7
Superdesk
↳
Superdesk Development
264
↳
Web Publisher
21
Poll
No poll attached to this discussion.
Top Posters
Albert FR
1978
Martin Konecny
1860
Andrey Podshivalov
1526
Voisses Tech
1423
John Chewter
899
Daniel James
844
Roger Wilco
784
hoerich
627
Paul Baranowski
389
Cliff Wang
339