Skip to content

Ansible, "copy" module and "become"

For testing I did spin up a couple of new virtual (Ubuntu 20.04 LTS) instances, installed PostgreSQL, and wanted to copy over a .sql file to install in the database:

- name: copy files to PostgreSQL data directory
  copy:
    src: "files/{{ item }}"
    dest: "{{ item }}"
    mode: 0700
  become: yes
  become_user: postgres
  loop:
    - file1.sql
    - file2.sql

And ran into a meaningless error message:

TASK [copy files to PostgreSQL data directory] ***********
fatal: [xxx.xxx.xxx.xxx]: FAILED! => {"msg": "Failed to set permissions on the temporary files Ansible needs to create when becoming an unprivileged user (rc: 1, err: chown: changing ownership of '/var/tmp/ansible-tmp-1618521951.848439-176484068031965/': Operation not permitted\nchown: changing ownership of '/var/tmp/ansible-tmp-1618521951.848439-176484068031965/source': Operation not permitted\n}). For information on working around this, see https://docs.ansible.com/ansible/become.html#becoming-an-unprivileged-user"}

 

 

Continue reading "Ansible, "copy" module and "become""
  • Twitter
  • Bookmark Ansible, "copy" module and "become" at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Ansible, "copy" module and "become"
  • Bloglines Ansible, "copy" module and "become"
  • Technorati Ansible, "copy" module and "become"
  • Fark this: Ansible, "copy" module and "become"
  • Bookmark Ansible, "copy" module and "become" at YahooMyWeb
  • Bookmark Ansible, "copy" module and "become" at Furl.net
  • Bookmark Ansible, "copy" module and "become" at reddit.com
  • Bookmark Ansible, "copy" module and "become" at blinklist.com
  • Bookmark Ansible, "copy" module and "become" at Spurl.net
  • Bookmark Ansible, "copy" module and "become" at Simpy.com
  • Bookmark Ansible, "copy" module and "become" at blogmarks
  • Bookmark Ansible, "copy" module and "become" with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...'

The openHAB rule system is not very helpful by pointing out when it's missing something, or when there is an error to actually point to the problem.

Was debugging an error message for a while and couldn't figure out what is wrong:

Configuration model '....rules' has errors, therefore ignoring it: [152,5]: no viable alternative at input '...'

The line number specified was somewhere else in the file, and had nothing to do with the rule in question. After removing almost everything from the rule, except a logInfo() message, the error still happened - and then it occured to me: I forgot to specify "Item".

My faulty code was:

rule "Rule Name"
when
    Sensor_name received update
then

where it should have been:

rule "Rule Name"
when
    Item Sensor_name received update
then

Error message totally not helpful ...

  • Twitter
  • Bookmark openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...' at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...'
  • Bloglines openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...'
  • Technorati openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...'
  • Fark this: openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...'
  • Bookmark openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...' at YahooMyWeb
  • Bookmark openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...' at Furl.net
  • Bookmark openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...' at reddit.com
  • Bookmark openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...' at blinklist.com
  • Bookmark openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...' at Spurl.net
  • Bookmark openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...' at Simpy.com
  • Bookmark openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...' at blogmarks
  • Bookmark openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...' with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Apache Karaf client in openHAB, and the "Session has been closed" error

Don't you love it when things suddenly stop working?

In my openHAB installation I have a check which verifies that the weather data is up to date. Otherwise it restarts the openhab2 service. And this check stopped working ... Leaving the kitchen display not updated for a longer time. The same display where I expect the entire installation to "just work", and don't create so many different problems. Seems to be a hard problem to have an openHAB installation without any trouble ...

 

Continue reading "Apache Karaf client in openHAB, and the "Session has been closed" error"
  • Twitter
  • Bookmark Apache Karaf client in openHAB, and the "Session has been closed" error at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Apache Karaf client in openHAB, and the "Session has been closed" error
  • Bloglines Apache Karaf client in openHAB, and the "Session has been closed" error
  • Technorati Apache Karaf client in openHAB, and the "Session has been closed" error
  • Fark this: Apache Karaf client in openHAB, and the "Session has been closed" error
  • Bookmark Apache Karaf client in openHAB, and the "Session has been closed" error at YahooMyWeb
  • Bookmark Apache Karaf client in openHAB, and the "Session has been closed" error at Furl.net
  • Bookmark Apache Karaf client in openHAB, and the "Session has been closed" error at reddit.com
  • Bookmark Apache Karaf client in openHAB, and the "Session has been closed" error at blinklist.com
  • Bookmark Apache Karaf client in openHAB, and the "Session has been closed" error at Spurl.net
  • Bookmark Apache Karaf client in openHAB, and the "Session has been closed" error at Simpy.com
  • Bookmark Apache Karaf client in openHAB, and the "Session has been closed" error at blogmarks
  • Bookmark Apache Karaf client in openHAB, and the "Session has been closed" error with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

MySQL: what shall be repaired?

A website shows the following error message:

SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_1898_0.MYI'; try to repair it

So, MySQL: which table is to repair? The error message is not a table, it's just the temp file.

Stupid and useless error message ...

  • Twitter
  • Bookmark MySQL: what shall be repaired? at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg MySQL: what shall be repaired?
  • Bloglines MySQL: what shall be repaired?
  • Technorati MySQL: what shall be repaired?
  • Fark this: MySQL: what shall be repaired?
  • Bookmark MySQL: what shall be repaired? at YahooMyWeb
  • Bookmark MySQL: what shall be repaired? at Furl.net
  • Bookmark MySQL: what shall be repaired? at reddit.com
  • Bookmark MySQL: what shall be repaired? at blinklist.com
  • Bookmark MySQL: what shall be repaired? at Spurl.net
  • Bookmark MySQL: what shall be repaired? at Simpy.com
  • Bookmark MySQL: what shall be repaired? at blogmarks
  • Bookmark MySQL: what shall be repaired? with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28)

If you run MySQL and this error occurs:

 SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYh0VgDS' (Errcode: 28)

then check if your server isn't using the famous "overflow" filesystem for /tmp, limited to 1 MB space.

The MySQL error message is - as usual - misleading and non-descriptive.

There are many other possible causes for this error code, so this one here might just be a hint.

  • Twitter
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28)
  • Bloglines MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28)
  • Technorati MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28)
  • Fark this: MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28)
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at YahooMyWeb
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at Furl.net
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at reddit.com
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at blinklist.com
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at Spurl.net
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at Simpy.com
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at blogmarks
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca