TurnKey Linux Virtual Appliance Library

TKLBAM with LAPP 11.1 failing (or it's me failing)

Trying to use tklbam with LAPP 11.1 - with the mahara patch applied.

tklmbam-init went fine, smooth as silk.

However, tklbam-backup provokes this response (I of course authenticate with the proxy first):

Traceback (most recent call last):
  File "/usr/bin/tklbam-backup", line 266, in <module>
    main()
  File "/usr/bin/tklbam-backup", line 195, in main
    conf.profile = get_profile(hb)
  File "/usr/bin/tklbam-backup", line 122, in get_profile
    new_profile = hb.get_new_profile(turnkey_version, profile_timestamp)
  File "/usr/lib/tklbam/hub.py", line 207, in get_new_profile
    response = self._api('GET', 'archive/timestamp/', attrs)
  File "/usr/lib/tklbam/hub.py", line 185, in _api
    return API.request(method, self.API_URL + uri, attrs, headers)
  File "/usr/lib/tklbam/hub.py", line 129, in request
    raise Error(c.response_code, name, description)
hub.Error: (404, 'BackupArchive.NotFound', 'Backup profile archive not found: turnkey-lapp-11.1-lucid-x86')

 

What am I getting wrong?

Liraz Siri's picture

TKLBAM still doesn't support PostgreSQL

Sorry, PostgreSQL support is still under development.

From http://www.turnkeylinux.org/docs/tklbam/faq/general:

Which databases are supported?

"Currently only MySQL. PostgreSQL support is under development. Support for additional databases will be added as needed. Currently TurnKey appliances only include MySQL and PostgreSQL databases."

TKLBAM still doesn't support PostgreSQL

Can you estimate when TKLBAM support PostgreSQL?  I just set one up and am having the same issue.

Is there some other way to backup the system in the mean time?

Thanks!

OH right, the manual

Thanks Liraz. Sorry to use your time up that way. Zealously backing up with new enthusiasm, I guess :)


SQL dump

The strategy I'm using is a cron job to dump to an sql file and then rsync to other machines on and off site.

Can't remember the details, as I'm not as fluent with postgres and am not at home or the office. A web search for postgreSQL and dumb and .sql should be a warm start, in the meantime.


Liraz Siri's picture

You can use TKLBAM hooks as a workaround

TKLBAM has a hooks mechanism which you can use to execute a command or script before the backup that dumps you pgsql database to a file (e.g., /root/database). There's also a post-restore hook you can use to execute a command that slurps in your pgsql dump into the database.

See /etc/tklbam/hooks.

Any useable backup profile for LAPP

Hi,

thanks for the efforts on such a wonderful project!

 

I realized too late that Postgresql based appliances are not supported by TKLBAM and then no profile is downloaded from the hub for the first backup.

My question is: is there any way to download a profile which DOES NOT include Postgresql databases? This way it would be possible to backup the appliance and using pre and post commands I would backup Postgres.  Or even freeze Postgres and do a LVM snapshot.

 

But if I am correct, the backup profile is needed. Any way?

 

Thaks,

Emilio

progress?

Two and a half years later (after the first article about TKLBAM that I found), and PostgreSQL support is still "coming soon"?

and maybe not even for the latest version of PostgreSQL?

Turnkey linux looks kindof interesting, but I'd have to say it loses quite a bit of spice with that kind of PostgreSQL support

Jeremy's picture

I can understand your concern

But to be realistic, TKL is developed by a 2 man team. And while their intentions, plans and dreams are awesome, like most of us they often underestimate the time things will take. Also as you can probably imagine, they also have a huge todo list and constantly shifting (and competeing) priorities.

To complicates matters AFAIK the devs are now looking to create some generic DB backup system (to accommodate current databases plus others into the future). This has pushed back the PostgreSQL support but hopefully will make the addition of new DB engine support to TKLBAM much easier.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)