Skip to content

Instantly share code, notes, and snippets.

View cjac's full-sized avatar

C.J. Collier cjac

View GitHub Profile
Nov 18 11:27:10 raku systemd[1]: Starting MariaDB 10.3.18 database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has begun starting up.
Nov 18 11:27:10 raku systemd[1]: mariadb.service: Control process exited, code=exited status=127
Nov 18 11:27:10 raku systemd[1]: Failed to start MariaDB 10.3.18 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
$ sudo systemctl status mariadb
● mariadb.service - MariaDB 10.3.18 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Mon 2019-11-18 11:16:53 PST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 32203 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=127)
Nov 18 11:16:53 raku systemd[1]: Starting MariaDB 10.3.18 database server...
Nov 18 11:16:53 raku systemd[1]: mariadb.service: Control process exited, code=exited status=127
$ grep 'mysql_init' /usr/include/mariadb/mysql.h
MYSQL * STDCALL mysql_init(MYSQL *mysql);
MYSQL * (STDCALL *mysql_init)(MYSQL *mysql);
$dbh->do("drop table if exists $test_table_name");
my $create_query = qq{
CREATE TABLE $test_table_name (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
@cjac
cjac / gist:c1ea8ceb16f0e8cdfb4ef2008760b7f7
Created September 11, 2018 23:25
utf8 db round trip tests
with 'use utf8;' pragma:
not ok 3 - lightly mixed utf8 string [läbel] round trips correctly
# Failed test 'lightly mixed utf8 string [läbel] round trips correctly'
# at t/web/dev-7476.t line 139.
# got: 'l�bel'
# expected: 'läbel'
# $VAR1 = {
# 'got' => "l\x{e4}bel",
my $toolhead_node = $dom->find( 'td.toolhead-table-cell span.toolhead' );
my @found;
$toolhead_node->each(
sub {
my ( $toolhead_node ) = ( @_ );
push( @found, $toolhead_node )
if ( $toolhead_node->text eq $field_label );
} );
@cjac
cjac / gist:ccc73b6126d5ef8576cd259af11ea9c0
Last active July 6, 2018 20:30
repro steps for verifying DEV-6656
# Switch site to People Staffing
# Get Account ID of Aaron Aardvark
# Get Account ID of Bob Bobson
# Get Group ID of Guards
# Enable tradeboard application
# tradeboard role restriction ->
# enable tradeboard in application settings (all trades)
# app settings -> tradeboard -> approval required
# team settings -> tradeboard -> approval required
Jun 05 09:00:45 build0 ipsec[14551]: 07[CFG] received stroke: initiate 'shiftboard'
Jun 05 09:00:45 build0 ipsec[14551]: 08[IKE] queueing ISAKMP_VENDOR task
Jun 05 09:00:45 build0 ipsec[14551]: 08[IKE] queueing ISAKMP_CERT_PRE task
Jun 05 09:00:45 build0 ipsec[14551]: 08[IKE] queueing MAIN_MODE task
Jun 05 09:00:45 build0 ipsec[14551]: 08[IKE] queueing ISAKMP_CERT_POST task
Jun 05 09:00:45 build0 ipsec[14551]: 08[IKE] queueing ISAKMP_NATD task
Jun 05 09:00:45 build0 ipsec[14551]: 08[IKE] queueing QUICK_MODE task
Jun 05 09:00:45 build0 ipsec[14551]: 08[IKE] activating new tasks
Jun 05 09:00:45 build0 ipsec[14551]: 08[IKE] activating ISAKMP_VENDOR task
Jun 05 09:00:45 build0 charon[14565]: 08[IKE] queueing MAIN_MODE task
Jun 04 16:38:30 wanjet1 charon[15207]: 11[CFG] received stroke: initiate 'shiftboard'
Jun 04 16:38:30 wanjet1 charon[15207]: 10[IKE] initiating Main Mode IKE_SA shiftboard[5] to 207.224.225.34
Jun 04 16:38:30 wanjet1 charon[15207]: 10[IKE] initiating Main Mode IKE_SA shiftboard[5] to 207.224.225.34
Jun 04 16:38:30 wanjet1 charon[15207]: 10[ENC] generating ID_PROT request 0 [ SA V V V V V ]
Jun 04 16:38:30 wanjet1 charon[15207]: 10[NET] sending packet: from 67.58.172.42[500] to 207.224.225.34[500] (212 bytes)
Jun 04 16:38:30 wanjet1 charon[15207]: 15[NET] received packet: from 207.224.225.34[500] to 67.58.172.42[500] (160 bytes)
Jun 04 16:38:30 wanjet1 charon[15207]: 15[ENC] parsed ID_PROT response 0 [ SA V V V V ]
Jun 04 16:38:30 wanjet1 charon[15207]: 15[IKE] received XAuth vendor ID
Jun 04 16:38:30 wanjet1 charon[15207]: 15[IKE] received NAT-T (RFC 3947) vendor ID
Jun 04 16:38:30 wanjet1 charon[15207]: 15[IKE] received DPD vendor ID
root@build0:~# xl2tpd -D
xl2tpd[27623]: setsockopt recvref[30]: Protocol not available
xl2tpd[27623]: Using l2tp kernel support.
xl2tpd[27623]: xl2tpd version xl2tpd-1.3.8 started on build0 PID:27623
xl2tpd[27623]: Written by Mark Spencer, Copyright (C) 1998, Adtran, Inc.
xl2tpd[27623]: Forked by Scott Balmos and David Stipp, (C) 2001
xl2tpd[27623]: Inherited by Jeff McAdams, (C) 2002
xl2tpd[27623]: Forked again by Xelerance (www.xelerance.com) (C) 2006-2016
xl2tpd[27623]: Listening on IP address 0.0.0.0, port 1701
^Cxl2tpd[27623]: network_thread: select returned error 4 (Interrupted system call)