s/Examples/Example
- Queries
- All Stories
- Search
- Advanced Search
- Transactions
- Transaction Logs
Feed All Stories
All Stories
All Stories
Nov 5 2017
Nov 5 2017
Use node.list
Proofread module description
Allow InnoDB engine to write in their directories
$ /usr/local/etc/rc.d/mysql-server start Installing MariaDB/MySQL system tables in '/var/db/mysql' ... 2017-11-05 13:57:44 34429034496 [Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used; This may cause repli ction to break when this server acts as a master and has its hostname changed! Please use '--log-basename=ysul.nasqueron.org' or '--log-bin=mysqld-bin' to avoi d this problem. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Cannot open datafile '/var/db/mysql/mysql-innodb-data/ibdata1' 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, an d it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attemp t. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious d ata! 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Database creation was aborted with error Cannot open a file. You may need to delete the ibdata1 file before try ing to start up again. 2017-11-05 13:57:45 34429034496 [ERROR] Plugin 'InnoDB' init function returned error. 2017-11-05 13:57:45 34429034496 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-11-05 13:57:45 34429034496 [ERROR] /usr/local/libexec/mysqld: unknown variable 'bin_log_format=MIXED' 2017-11-05 13:57:45 34429034496 [ERROR] Aborting
Proofread and improve configuration file: stop words, performance schema
$ salt-call --local state.apply roles/dbserver-mysql local: ---------- ID: mysql_server_software Function: pkg.installed Result: True Comment: All specified packages are already installed Started: 01:45:51.880169 Duration: 246.099 ms Changes: ---------- ID: arcology/mysql-innodb-data Function: zfs.filesystem_present Result: True Comment: filesystem arcology/mysql-innodb-data was updated Started: 01:45:52.131408 Duration: 563.66 ms Changes: ---------- arcology/mysql-innodb-data: ---------- mountpoint: /var/db/mysql/mysql-innodb-data recordsize: 16k ---------- ID: arcology/mysql-innodb-logs Function: zfs.filesystem_present Result: True Comment: filesystem arcology/mysql-innodb-logs was updated Started: 01:45:52.695790 Duration: 557.842 ms Changes: ---------- arcology/mysql-innodb-logs: ---------- mountpoint: /var/db/mysql/mysql-innodb-logs recordsize: 128k ---------- ID: arcology/mysql-root Function: zfs.filesystem_present Result: True Comment: filesystem arcology/mysql-root was updated Started: 01:45:53.254366 Duration: 574.172 ms Changes: ---------- arcology/mysql-root: ---------- mountpoint: /var/db/mysql/mysql-root recordsize: 8k ---------- ID: /usr/local/etc/my.cnf Function: file.managed Result: True Comment: File /usr/local/etc/my.cnf updated Started: 01:45:53.838402 Duration: 95.623 ms Duration: 95.623 ms Changes: ---------- diff: New file mode: 0644 ---------- ID: /var/run/mysqld Function: file.directory Result: True Comment: Directory /var/run/mysqld updated Started: 01:45:53.934487 Duration: 7.571 ms Changes: ---------- /var/run/mysqld: New Dir ---------- ID: /var/db/mysql Function: file.directory Result: True Comment: Directory /var/db/mysql updated Started: 01:45:53.942532 Duration: 5.229 ms Changes: ---------- group: mysql user: mysql
Nov 4 2017
Nov 4 2017
I reported upstream an issue for recordsize, falsely reporting to be updated in test mode: https://github.com/saltstack/salt/issues/44404
Currently, we have all the 14 plugins packages, as we well use weechat-plugins (installed by weechat):
Fix commit range to select only MySQL
dereckson added a revision to T1306: Create a MySQL configuration optimized for ZFS on Ysul: D1122: Provision MySQL.
Don't use tabs for alignment. Create /var/run/mysqld.
dereckson added a subtask for T1268: Reprovision Ysul: T1306: Create a MySQL configuration optimized for ZFS on Ysul.
dereckson added a parent task for T1306: Create a MySQL configuration optimized for ZFS on Ysul: T1268: Reprovision Ysul.
dereckson committed rTOOLS45e3721d5fb5: Switch gadgets/motd-variations to pure PHP (authored by dereckson).
Switch gadgets/motd-variations to pure PHP
dereckson added a revision to T1294: Dockerize tools.nasqueron.org: D1173: Switch gadgets/motd-variations to pure PHP.
It's currently running, I'll check dependencies and release later.
dereckson moved T1294: Dockerize tools.nasqueron.org from Working on to Backlog on the Operations sprints (The Dreadnought will produce new officers) board.
RUN apt-get install freebsd-buildutils libfl-dev fortunes && \ ln -s /usr/bin/freebsd-lex /usr/bin/lex && \ cd /opt && wget http://dereckson.devio.us/software/valspeak/valspeak-1.0.tar.gz && \ tar xzvf valspeak-1.0.tar.gz && cd valspeak-1.0 && make && ln -s /opt/valspeak-1.0/valspeak /usr/bin/valspeak && \ cd /opt && git clone https://devcentral.nasqueron.org/source/jive.git && cd jive && \ make && ln -s /opt/jive/jive /usr/bin/jive
dereckson closed T1305: Release jive, a subtask of T1294: Dockerize tools.nasqueron.org, as Resolved.
Released at rJIVE.
Initial revision
dereckson moved T1304: Split of scripting packages of weechat from Backlog to Server config on the Eglide board.
dereckson added a revision to T1294: Dockerize tools.nasqueron.org: D1172: Treat homepage like a regular page.
Treat homepage like a regular page
Previous order
Provide default configuration
dereckson added a revision to T1294: Dockerize tools.nasqueron.org: D1171: Provide default configuration.
dereckson renamed T1302: Can't compile bundle.js for gadgets/generator - babel/polyfill not found from Can't compile bundle.js for gadgets/generator to Can't compile bundle.js for gadgets/generator - babel/polyfill not found.
dereckson committed rTOOLS1ccf26f90280: Handle correctly QUERY_STRING when it's different from REQUEST_URI (authored by dereckson).
Handle correctly QUERY_STRING when it's different from REQUEST_URI
dereckson committed rTOOLS8e2a2180e0ba: Send headers before any body output (authored by dereckson).
Send headers before any body output
Remove \n
I can't repro anymore this issue, when I investigated to a header/body write order issue, fixed in D1169.
dereckson moved T1294: Dockerize tools.nasqueron.org from Backlog to Live on tools. on the Nasqueron Tools board.
dereckson committed rTOOLSf33dd1fffa58: Prefer to read url from HTTP_HOST than SERVER_NAME (authored by dereckson).
Prefer to read url from HTTP_HOST than SERVER_NAME
rm space
Remove extraneous \n
Fix whitespaces issues
Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator