Profile

Cover photo
Piet Schee
367,855 views
AboutPostsPhotosVideosReviews

Stream

Piet Schee

Shared publicly  - 
 
just switched from unity to plasma 5 and like it :-)
1
Add a comment...

Piet Schee

Shared publicly  - 
 
Does anyone use a desktop Linux with UEFI partition on mdadm Raid 1? 

Does UEFI / Grub support this in the meantime or do i still need to add an extra UEFI (non MDADM) partition which i need to sync manually to the other disk?
1
Add a comment...

Piet Schee

Discussion  - 
 
i just installed maxscale in front of a 3 node galera cluster.

evrythings seems to work fine but i get some errors: "Galera Service: Refresh rate limit exceeded for load of users' table."

does anyone know what thsi means and how to fix this?
1
Piet Schee's profile photo
Add a comment...

Piet Schee

commented on a video on YouTube.
Shared publicly  - 
 
Seriously?! 3 bearded hipster's tryin to teach other hipster's how to look?! That's just ridiculous!
1
Add a comment...

Piet Schee

Discussion  - 
 
Hi,

i just tried to update to MariaDB Galera 10.0.13 via apt repo in Ubuntu 14.04 but the first Node just crashed when trying to reconnect. I get the following warnings and errors:

140905 10:19:06 [ERROR] WSREP: Failed to read output of: '/sbin/ifconfig | grep -E '^[[:space:]]+inet addr:' | grep -m1 -v 'inet addr:127' | sed 's/:/ /' | awk '{ print $3 }''
140905 10:19:06 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
140905 10:19:06 [Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
140905 10:19:06 [Warning] WSREP: (4ddc5f28-34d5-11e4-be6d-bb3d277093df, 'tcp://0.0.0.0:4567') address 'tcp://10.0.0.31:4567' points to own listening address, blacklisting
140905 10:19:07 [Warning] WSREP: Gap in state sequence. Need state transfer.
140905 10:19:09 [ERROR] WSREP: State request preparation failed, aborting: unknown exception
WSREP_SST: [ERROR] Parent mysqld process (PID:8346) terminated unexpectedly. (20140905 10:19:10.792)

The first error is because of my german output of ifconfig.
Could be fixed via:

"/sbin/ifconfig | grep -i -E '^[[:space:]]+inet ad'| grep -i -m1 -v 'inet ad.*:127' | sed 's/:/ /'"

But i think this could be problem for other languages too?

Update:
it works now. had to do complete resync (deleting all dbs in var/lib/mysql but mysql and restart mysql) for node 1.

node 2 and 3 ran the update without problems but i had to set
wsrep_node_address in galera.cnf before the update.
1
Add a comment...

Piet Schee

Discussion  - 
 
does anybody have infos about qemus libgfapi integration and which disk cache modes are supported?

currently i only get qemu work without i/o errors when using cache=none.
1
Piet Schee's profile photoLindsay Mathieson's profile photo
3 comments
 
Cool,

sorry,wasn't till I posted that I noticed the dates :)
Add a comment...

Piet Schee

Discussion  - 
 
While updateng Maria DB Galera Cluster to 5.5.37 i got a lot of errors in mysql error.log like:

140514 18:18:31 [ERROR] Slave SQL: Error 'Duplicate column name 'Create_tablespace_priv'' on query. Default database: 'mysql'. Query: 'ALTER TABLE user ADD Create_tablespace_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Trigger_priv', Error_code: 1060

nevertheless evrything works fine after updating all nodes...
do i need to fix something?
1
Add a comment...

Communities

8 communities

Piet Schee

Discussion  - 
 
i just moved from haproxy to maxscale in front of a 3 node mariadb 10.0.17 galera cluster.

now it seems the mysql shell client is broken, when connecting to maxscale:

mysql -uroot -ppassword -h mysql.local.net mydatabase -e "show tables;"
ERROR 1045 (28000): Access denied for user 'root'@'192.168.111.31'(using password: YES) to database 'mydatabase'

when i connect to one of the mariadb servers directly it works:

mysql -uroot -ppassword -h mysql1.local.net mydatabase -e "show tables;"
+------------------------+
| Tables_in_mydatabase     |
+------------------------+
| table1                   |
| table2                   |
+------------------------+

whats the problem here?
1
Piet Schee's profile photo
Add a comment...

Piet Schee

Shared publicly  - 
 
New proxy in front of our Galera cluster!
Bye bye HAProxy...
Hello Maxscale! :-)

+MariaDB Hope you'll fix this deb package someday... Putting configuration and logs in /usr/local/skysql is kind of a mess...
1
Add a comment...

Piet Schee

Discussion  - 
 
Im trying to iterate throug a nested array in puppet 3.4 using the future parser, but dont get it work.

At the moment i try via:

    $my_sites = {
    domain1 => {
        user => "user1",
        domain => "local.net",
        user_id => 1,
        group_id => 1
    },
    domain2 => {
        user => "user2",
        domain => ".bla.net",
        user_id => 2,
        group_id => 2
    },
    domain3 => {
        user => "user3",
        domain => ".user.net",
        user_id => 3,
        group_id => 3
    }
    }

    each($my_sites) |$my_site,$value| {

    notify{ " test $my_site $value[user] ": }
    
    }   

But this does not work.

Whats the best way to iterate through a nested array in puppet manifest?

Thanks in advance...
1
Piet Schee's profile photo
 
i think i got it :-)

notify{ " test ${my_sites[$my_site][user]} ": }
Add a comment...

Piet Schee

Discussion  - 
 
If i try to "gluster volume rename gv6 newname" i get the following error: "unrecognized word: rename (position 1)".

Imho i've did it like described in the man page. Whats the problem?

GlusterFS 3.5.2 - Ubuntu 14.04
1
Dave McAllister's profile photoPiet Schee's profile photo
2 comments
 
Thanks... Will do this tomorrow...
Add a comment...

Piet Schee

Discussion  - 
 
i'm new to puppet an just trying to use "if" statement in my "helloworld" class.

os is ubuntu 14.04. puppet is 3.4.3.

my clss works without the if statement.

when using it like this:

class helloworld {
    file {
    '/tmp/HelloFromPuppetMaster':
            path    => "/tmp/HelloFromPuppetMaster",
            ensure  => file,
            mode    => 600,
            owner   => root,
            group   => root,
        if $is_virtual == 'true' {
        content => "puppet works on virtual :-)\n";
        }
        else {
            content => "puppet works on bare metal :-)\n";
        }
    }
}

i get the following error:

 puppet agent --test
Info: Retrieving plugin
Error: Could not retrieve catalog from remote server: Error 400 on SERVER: Syntax error at '('; expected ')' at /etc/puppet/modules/helloworld/manifests/init.pp:10 on node checkbox.intdmz.h1.mdd
Warning: Not using cache on failed catalog
Error: Could not retrieve catalog; skipping run


i just followed: http://docs.puppetlabs.com/puppet/latest/reference/lang_conditional.html

"$is_virtual" is set in my node.pp.

any hints?
1
Mike Donlon's profile photoMichael Speth's profile photoChris Snell's profile photoSteve Clark's profile photo
6 comments
 
Your solution is fine, you could use a selector, but I'll refer you to the style guide too https://docs.puppetlabs.com/guides/style_guide.html#conditionals
Add a comment...
Communities
8 communities
Apps with Google+ Sign-in
  • THE KING OF FIGHTERS'98
  • 餓狼MOW
Links
YouTube
bester grieche dresdens! :-)
Public - 2 months ago
reviewed 2 months ago
Super leckres hausbräu!
Public - 5 months ago
reviewed 5 months ago
Kleine portionen, Teuer und dazu Schlecht Küche!
Public - a year ago
reviewed a year ago
68 reviews
Map
Map
Map
Disgusting!
Public - 9 months ago
reviewed 9 months ago