coldtobi's blog

N2M: parallel build dpkg-buildpackage and pdebuild

Sat, 14 Jan 2012 13:38:45 +0100

Note-To-Myself: Build on two CPUs: pdebuild --debuildopts "-j2" dpkg-buildpackage -j2 When using dpkg-buildpackge (or debuild) you alos can export this env: export DEB_BUILD_OPTIONS=parallel=2 to set the numbers of parallel builds. (eg. into .bashrc)

Windows CE: Assertion failed in wincore.cpp line 1034

Sun, 19 Jun 2011 23:31:58 +0200

For home automation, I grabbed my old PDA and started coding for it, using the Microsoft embedded Visual C++ Studio 3.0 (was free at that time ;-)) As soon as you start debugging, you immediatly get an assert: "Assertion failed in file wincore.cpp, line 1034". This only happens on the "emulated" PDA, but even with the wizard generated files. However, I solved this already on another project, but I needed to google it up again, so its time to document this: In your project, open the Class Wizard (in the View menu) Select your App-Class Add the Message Handler "PreTranslateMessage" Double click on the now listed member function Make the member function look this like, adding the bold lines: BOOL App::PreTranslateMessage(MSG* pMsg) { #ifdef _WIN32_WCE_EMULATION if( ! ::IsWindow(pMsg->hwnd)) return TRUE; #endif return CWinApp::PreTranslateMessage(pMsg); }

CakePHP: Baking a Application in Minutes

Sun, 20 Mar 2011 12:17:49 +0100

On my last PHP project I spent too much time on basic tasks like form validation, generation and all the stuff behind. As this "problems" are quite common this is basically a reinvention of the wheel. So I started looking for a good, easy to understand PHP Framework to speed things up. What I found is CakePHP , a MVC based framework. Ok, there are several frameworks available, so why to choose CakePHP? I think this is up to personal taste which framework appeals you most. Of course, there are comparisons in the blogosphere, so this can be a starting point for the decision. ( for example ) Back to the cake. Well, IMPRESSIVE. This framework saves you lots of work -- most functions you need everyday are already there and the documentation called "Cookbook" is also quite complete and easy to understand. The API is not very complicated, so learning this framework is definitely faster than writing your own framework. (For the German readers: read this article ). Nevertheless, back to the topic again. To get an application up and running in minutes you can use a method they call scaffolding . You setup a scaffold * and your are ready. (* Your scafold consists of a database and two files.... Of course, I assume you have your webserver and database server ready, and for the sake of easiness debian running to install all required packages. As an alternative to a webserver, you might want to check the package cakephp-instaweb and the docs here . Also for the sake of easiness, this tutorial shows will not use mod_rewrite, to avoid the hassle involving proper mod_rewrite configuration) Don't believe it? Try it yourself. OK Lets do a TODO-List? Start your stopwatch.... 1) Install cakephp aptitude install cakephp cakephp-scripts 2) "bake" your application in /var/www as the webserver user (just answer cake's questions as below. Most are default, so just press "enter". I marked all where you indeed have to enter something red. ) #su Password: #su www-data #cake bake todo Welcome to CakePHP v1.3.7 Console --------------------------------------------------------------- App : www Path: /var/www --------------------------------------------------------------- Bake Project Skel Directory: /usr/share/php/cake/console/templates/skel Will be copied to: /var/www/todo --------------------------------------------------------------- Look okay? (y/n/q) [y] > Do you want verbose output? (y/n) [n] > --------------------------------------------------------------- Created: todo in /var/www/todo --------------------------------------------------------------- Creating file /var/www/todo/views/pages/home.ctp Wrote `/var/www/todo/views/pages/home.ctp` Welcome page created Random hash key created for 'Security.salt' Random seed created for 'Security.cipherSeed' CAKE_CORE_INCLUDE_PATH set to /usr/share/php in webroot/index.php CAKE_CORE_INCLUDE_PATH set to /usr/share/php in webroot/test.php Remember to check these value after moving to production server Your database configuration was not found. Take a moment to create one. --------------------------------------------------------------- Database Configuration: --------------------------------------------------------------- Name: [default] > Driver: (db2/firebird/mssql/mysql/mysqli/odbc/oracle/postgres/sqlite/sybase) [mysql] > sqlite Persistent Connection? (y/n) [n] > Database Host: [localhost] > Port? [n] > User: [root] > Password: > The password you supplied was empty. Use an empty password? (y/n) [n] > y Database Name: [cake] > /var/www/todo/db.sqlite Table Prefix? [n] > Table encoding? [n] > --------------------------------------------------------------- The following database configuration will be created: --------------------------------------------------------------- Name: default Driver: sqlite Persistent: false Host: /var/www/todo/db.sqlite User: root Pass: Database: todo Look okay? (y/n) [y] > Do you wish to add another database configuration? [n] > # 3) populate your database Our todo should have a datestamp when modified, a prioriy, a progress indicator, a checkbox if its done, some title and a description .... # (copy the following to a file name, for example to /tmp/db.txt) CREATE TABLE todos ( id INTEGER AUTO_INCREMENT, modified datetime , title varchar(127) , description text , done tinyint(1) DEFAULT 0, priority int(11) , progress integer , PRIMARY KEY (id) ); ... and ask sqlite to initialize it by sqlite /var/www/todo/db.sqlite 6) Create the Model for your todo list ( create the file /var/www/todo/models/todo.php ) With this: 7) Enjoy Point your browser to http://localhost/todo/index.php/todos for your todo list, a nice scarford CRUD application A) Bonus points: For bonus points and to demonstrate the power of CakePHP, lets add validation and some basic sorts to the ToDo List. I want to sort it regarding priority and put the "dones" at the end of the list: Just Change /var/www/todo/models/todo.php to the following: array( 'rule' => 'notEmpty', 'message' => "Bitte ausfüllen"), 'priority' => array( 'rule' => 'notEmpty', 'message' => "Bitte ausfüllen"), 'description' => array( 'rule' => 'notEmpty', 'message' => "Bitte ausfüllen"), ); function beforeFind($query) { $query['order'][] = 'done'; $query['order'][] = 'priority DESC'; return $query; } } ?> Ok, there we are. Pencils down. So, what does your stop watch show? IMPRESSIVE, right? A Word of WARNING: Note that this is fine for private purposes, but never put this online. For example, the scafolding code will not care about XSS! For example, enter a todo with this text: REPEAT: IT IS NOT SAFE TO USE A SCAFOLDED APPLICATION. CAKE EXPLICITLY TELLS THAT YOU MUST SANIZITE ALL DATA BY YOURSELF!

Enabling InnoDB support in debian (MySQL)

Thu, 17 Mar 2011 10:17:37 +0100

InnoDB as storage engine has some advantages: Just one example: it is the backend to use when foreign keys are required. For a complete picute, read the documenation: http://dev.mysql.com/doc/refman/5.1/en/innodb-storage-engine.html However, on Debian InnoDB is disabled by default: (take a look at /etc/mysql/my.cnf) skip-innodb However, it's not just uncommeting to enable it: Your mysqldaemon will fail. This article will explain how you can enable it with Debian Of course, this assumes that you already setup mysql on your Debian server. 1.) To check which storage engines are available, so to determine if you have it already enabled, you can execute the following SQL statement (for example, from a shell using the command "mysql -u root -p"): thecus:/home/tobi# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. mysql> SHOW ENGINES; +------------+---------+--------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +------------+---------+--------------------------------------------------------------+--------------+------+------------+ | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappear | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | +------------+---------+--------------------------------------------------------------+--------------+------+------------+ 7 rows in set (0.00 sec) In this example, InnoDB is missing ;-) But how to enable it? Here are the three steps required: 1) Edit /etc/mysql/my.cnf and comment out the skip-inno-db line. Add the following lines #skip-innodb innodb_data_home_dir = innodb_data_file_path = /var/lib/mysql/ibdata/ibdata1:100M:autoextend This will create a initally 100MByte big database file at the given location -- which does not exist yet: 2) Create the database location and set ownership -- of course you need to do that as root. mkdir /var/lib/mysql/ibdata/ chown -R mysql:mysql /var/lib/mysql/ibdata 3) Let mysql initialize the database files. On my (slow) database server I figured out that a /etc/init.d/mysql restart did not wait long enough for mysql until it gets ready. So I suggest to manually start the first time. Note the "&" at the end -- I start mysql in the background. The reason for starting mysqld in the background is, that I want to conveniently stop the daemon after it initalized the database -- if run in the foreground, Ctrl+C and Ctrl+Z seems to be trapped. /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --port=3306 --socket=/var/run/mysqld/mysqld.sock & [1] 9724 thecus:/var/lib/mysql# InnoDB: The first specified data file /var/lib/mysql/ibdata/ibdata1 did not exist: InnoDB: a new database to be created! 110317 10:58:52 InnoDB: Setting file /var/lib/mysql/ibdata/ibdata1 size to 100 MB InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 110317 10:58:57 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 110317 10:58:58 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 110317 10:59:00 InnoDB: Started; log sequence number 0 0 110317 10:59:00 [Note] Event Scheduler: Loaded 0 events 110317 10:59:00 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.49-3' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian) After that, the files are created -- you can check it with ls /var/lib/mysql/ibdata/ To stop mysql after it did create the database file, get its pid with jobs -p and ask it to terminate. (Note: Make sure to use your pid.... below ) thecus:/var/lib/mysql# jobs -p 9724 thecus:/var/lib/mysql# kill # in my example it would be 9724 thecus:/var/lib/mysql# 110317 11:03:50 [Note] /usr/sbin/mysqld: Normal shutdown 110317 11:03:50 [Note] Event Scheduler: Purging the queue. 0 events 110317 11:03:50 InnoDB: Starting shutdown... 110317 11:03:51 InnoDB: Shutdown completed; log sequence number 0 44233 110317 11:03:51 [Note] /usr/sbin/mysqld: Shutdown complete Now you can resume "normal" operation by /etc/init.d/mysql start, and it should work: thecus:/var/lib/mysql# /etc/init.d/mysql start Starting MySQL database server: mysqld . .. Checking for corrupt, not cleanly closed and upgrade needing tables.. thecus:/var/lib/mysql# mysql -u root -p Enter password: mysql> SHOW ENGINES; +------------+---------+--------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +------------+---------+--------------------------------------------------------------+--------------+------+------------+ | InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappea) | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | +------------+---------+--------------------------------------------------------------+--------------+------+------------+ 8 rows in set (0.00 sec)

Flattr.

Sun, 27 Feb 2011 23:14:21 +0100

Flattr is a social micropayment plattform. But is is best to let them describe their idea: Flattr was founded to help people share money, not just content. Before Flattr, the only reasonable way to donate has been to use Paypal or other systems to send money to people. The threshold for this is quite high. People would just ignore the option to send donations if it wasn't for a really important cause. Sending just a small sum has always been a pain in the ass. Who would ever even login to a payment system just to donate €0.01? And €10 was just too high for just one blog entry we liked... Flattr solves this issue. When you're registered to flattr, you pay a small monthly fee. You set the amount yourself. At the end of the month, that fee is divided between all the things you flattered. You're always logged in to the account. That means that giving someone some flattr-love is just a button away. And you should! Clicking one more button doesn't add to your fee, it just divides the fee between more people! Flattr tries to encourage people to share. Not only pieces of content, but also some money to support the people who created them. With love! Yes, this is flattr about. Showing someone that you appreciate the content he/she created. And as I like the idea, I subscribed to it today and enabled the blog to show this little tiny flattr buttons. Button showing ERROR? Maybe this is the reason why you are reading this post: You were on another post, where a link was placed next to a button showing "ERROR"... Well, for lifetype it is a manual process to submit all posts to flattr, so I did only for some hand-selected articles. For the others "ERROR" will show up, but you until I add this post, you can click on the button of this article instead. BTW: Thank you very much for your appreciation!

Pollin Net-IO PHP Library

Wed, 09 Feb 2011 19:37:08 +0100

Currently I work on a small private home-automation project. The purpose to "control" the heating system at home (heat-pump system) via the Internet. Okay, "control" is a too big word for the heat-pump as it has only 3 controlable modes, at least without reverse-engineering effort: "normal", "off" and "night reduction" by an external analog input. The goal is to shift energy consumption to the lower priced off-peak times. For this project, I'm using a Ethernet Board with an Atmel AVR microcontroller , my Thecus N2100 as control server and PHP . So it makes sense to build a small PHP library, and maybe someone else has also use of this library. The library is compatible with the original firmware and supportsthe following main functions: Connecting to the network Setting the digital outputs and reading back the status (with the possiblity to cache the results) Reading the digital inputs (with the possiblity to cache the results) Reading the analog (ADC) inputs . Download the code Here's the library: http://frost.de/files/net_io.txt (make sure to change the extension to .php) And here are some testcases, also illustrating the usage: http://frost.de/files/net_io_testcases.txt (make sure to change the extension to .php) Usage snippets Instanciating (NB: 10.243.48.250 is the IP I use on my network. You might need to change this. Factory-Default is 192.168.0.90): $p = new pollin_netio("10.243.48.250"); Setting an Output (example: Port 0 to high, 5V) - note Port 0 is Port 1 as on the hardware schematic. if ( false == $p->setport(0,1)) { echo "ERROR on setting port 1\r\n"; } else { echo " OK setting port 0\r\n"; } } Reading the input IO (eg. input 1) $port = $p->query(8, false); Reading analog values for ( $i=0; $i<4; $i++) { $result = $p->queryad($i,0); if ( false == $result) { echo "ERROR reading port $i\r\n"; } else { echo "OK reading port $i (value $result)\r\n"; } }

Link to safe

Sun, 23 Jan 2011 10:01:07 +0100

Custom Firmware for a seagat FreeAgent Theater+ http://forums.seagate.com/t5/FreeAgent-Theater/Mod-Firmware-For-FreeAgent-Theater-Plus-Testers-Needed/m-p/40993/highlight/true#M667 Could be the next hacking project.