Category Archives: osx

New path for MySQL query log on OSX

Sometimes during development I need to see what SQL queries are executed and listing them in Console.app is maybe the most convenient solution on OSX. To see queries in Console I just created /etc/mysql/my.cnf with: [mysqld] general_log = 1 # general_log_file … Continue reading

Posted in log, osx, Uncategorized | Tagged , , , , | Leave a comment

Getting ‘doesn’t have a default value’ from MySQL (MariaDB)?

Solution for me from ideas at https://stackoverflow.com/questions/15438840/mysql-error-1364-field-doesnt-have-a-default-values and https://www.farbeyondcode.com/Solution-for-MariaDB-Field–xxx–doesn-t-have-a-default-value-5-2720.html was to remove ‘STRICT_TRANS_TABLES’ from my.cnf. So I ended up with the following in /usr/local/mysql/my.cnf: [mysqlnd] sql_mode=NO_ENGINE_SUBSTITUTION

Posted in osx, sql | Tagged , | Leave a comment

OSX FTP

To run the ftpd: sudo -s launchctl load -w /System/Library/LaunchDaemons/ftp.plist To stop the ftpd: sudo -s launchctl unload -w /System/Library/LaunchDaemons/ftp.plist Login credentials are the same as for user login.

Posted in bash, osx | Tagged , | Leave a comment

Switched from Console.app to multitail

With Console.app I had the problem that when I switched to output /var/log/apache2/error_log I didn’t see /var/log/system.log and yesterday I read http://kkovacs.eu/cool-but-obscure-unix-tools and found multitail so I played with it. I’m currently running the following setup on OSX Mountain Lion … Continue reading

Posted in cli, linux, log, monitoring, net, osx | Leave a comment

My Mac OSX workspace february 2014

From left to right:Console.app or Filezilla.appFirefox.app with Firebug vertical splitVIM in GNU screen in iTerm2.app terminal

Posted in firefox, osx, workspace | Leave a comment

WakeOnLan z Macu

Po upgrade na nový OSX som bol nútený znova spojazdniť zaslanie Magic Packetu môjmu backup notebooku.  Po úspešnom nainštalovaní macports podľa návodu na oficiálnej stránke som inštaloval utilitu wakeonlan: $sudo port install wakeonlan Ako ďalší krok nasledovalo zisťit MAC adresu backup … Continue reading

Posted in linux, osx, wakeonlan, wol | Leave a comment