coldtobi's blog

coldtobi's blog http://blog.coldtobi.de/1_coldtobis_blog Life is more than binary. coldtobi 2013-05-23T13:13:20Z N2M: parallel build dpkg-buildpackage and pdebuild http://blog.coldtobi.de/1_coldtobis_blog/archive/303_n2m_parallel_build_dpkg-buildpackage_and_pdebuild.html 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) Blog and Website 2012-01-14T13:38:45Z coldtobi Windows CE: Assertion failed in wincore.cpp line 1034 http://blog.coldtobi.de/1_coldtobis_blog/archive/302_windows_ce_assertion_failed_in_wincorecpp_line_1034.html 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: <ul> <li>In your project, open the Class Wizard (in the View menu)</li> <li>Select your App-Class</li> <li>Add the Message Handler "PreTranslateMessage"</li> <li>Double click on the now listed member function</li> <li>Make the member function look this like, adding the bold lines:</li> </ul> <blockquote> BOOL <your-app-name>App::PreTranslateMessage(MSG* pMsg) { #ifdef _WIN32_WCE_EMULATION     if( ! ::IsWindow(pMsg->hwnd))         return TRUE; #endif         return CWinApp::PreTranslateMessage(pMsg); } </blockquote>   Blog and Website 2011-06-19T23:31:58Z coldtobi CakePHP: Baking a Application in Minutes http://blog.coldtobi.de/1_coldtobis_blog/archive/301_cakephp_baking_a_application_in_minutes.html 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 <a href="http://cakephp.org/" target="_blank">CakePHP</a>, 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. (<a href="http://www.phpframeworks.com/" target="_blank">for example</a>) Back to the cake. Well, IMPRESSIVE. This framework saves you lots of work -- most functions you need everyday are already there and the <a href="http://book.cakephp.org/" target="_blank">documentation called "Cookbook"</a> is also quite complete and easy to understand. The API is not very complicated, so learning this framework is definitely faster <a href="http://www.phpandstuff.com/articles/top-10-reasons-why-you-should-use-a-php-framework" target="_blank">than writing your own framework.</a> (For the German readers: read <a href="http://www.phphatesme.com/blog/wtf/10-grunde-gegen-den-einsatz-von-php-frameworks/" target="_blank">this article</a>). Nevertheless, back to the topic again.   To get an application up and running in minutes you can use a method they call <a href="#!/view/1103/Scaffolding" target="_blank">scaffolding</a>. You setup a <a href="http://en.wikipedia.org/wiki/Scaffolding">scaffold</a>* 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 <a href="http://chris-lamb.co.uk/projects/cakephp-instaweb/" target="_blank">here</a>. 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 <blockquote> aptitude install cakephp cakephp-scripts </blockquote> 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.) <blockquote> #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] > # </blockquote> 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 .... <blockquote>   #(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) ); </blockquote>   ... and ask sqlite to initialize it by <blockquote> sqlite /var/www/todo/db.sqlite </tmp/db.txt </blockquote>   4) Disable mod_rewrite setting in  /var/www/todo/config/core.php, by remove the comment in around line 69: <blockquote>  /**  * To configure CakePHP *not* to use mod_rewrite and to  * use CakePHP pretty URLs, remove these .htaccess  * files:  *  * /.htaccess  * /app/.htaccess  * /app/webroot/.htaccess  *  * And uncomment the App.baseUrl below:  */         Configure::write('App.baseUrl', env('SCRIPT_NAME')); </blockquote>   5)  Create the Controller for your todo list: (create the file  /var/www/todo/controllers/todos_controller.php) Containing just those few lines: <blockquote> <?php class TodosController extends AppController {                 var $scaffold; } ?> </blockquote> 6) Create the Model for your todo list (create the file /var/www/todo/models/todo.php)   With this: <blockquote> <?php class Todo extends AppModel {         var $name = 'Todo'; ?> </blockquote> 7) Enjoy Point your browser to  <a href="http://localhost/todo/index.php/todos" target="_blank">http://localhost/todo/index.php/todos</a> for your todo list, a nice scarford <a href="http://localhost/todo/index.php/todos" target="_blank"></a><a href="http://en.wikipedia.org/wiki/Create,_read,_update_and_delete" target="_blank">CRUD application</a>   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: <blockquote>  <?php class Todo extends AppModel {         var $name = 'Todo';         var $validate = array(                 'title' => 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;         } } ?> </blockquote>   Ok, there we are. Pencils down. So, what does your stop watch show?  IMPRESSIVE, right?   <blockquote> 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: <script type="text/javascript">alert("XSS");</script> REPEAT: IT IS NOT SAFE TO USE A SCAFOLDED APPLICATION. CAKE EXPLICITLY TELLS THAT YOU MUST SANIZITE ALL DATA BY YOURSELF!  </blockquote>   Blog and Website 2011-03-20T12:17:49Z coldtobi Enabling InnoDB support in debian (MySQL) http://blog.coldtobi.de/1_coldtobis_blog/archive/300_enabling_innodb_support_in_debian_mysql.html 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) <blockquote>  skip-innodb </blockquote> 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"): <blockquote> 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) </blockquote> 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 <blockquote> #skip-innodb innodb_data_home_dir = innodb_data_file_path = /var/lib/mysql/ibdata/ibdata1:100M:autoextend </blockquote> 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. <blockquote> mkdir  /var/lib/mysql/ibdata/ chown -R mysql:mysql /var/lib/mysql/ibdata </blockquote> 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. <blockquote>  /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) </blockquote> 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 ) <blockquote> thecus:/var/lib/mysql# jobs -p 9724 thecus:/var/lib/mysql# kill <your pid> # 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 </blockquote> Now you can resume "normal" operation by /etc/init.d/mysql start, and it should work: <blockquote> 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) </blockquote>   Blog and Website 2011-03-17T10:17:37Z coldtobi Flattr. http://blog.coldtobi.de/1_coldtobis_blog/archive/299_flattr.html   <img src="https://flattr.com/_img/misc/flattr-logo-thumb.jpg" width="150" height="100" align="right" />  Flattr is a social micropayment plattform. But is is best to let them describe their idea: <blockquote> 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! </blockquote>   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! Blog and Website 2011-02-27T23:14:21Z coldtobi Pollin Net-IO PHP Library http://blog.coldtobi.de/1_coldtobis_blog/archive/298_pollin_net-io_php_library.html 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 <a href="http://www.pollin.de/shop/dt/MTQ5OTgxOTk-/Bausaetze_Module/Bausaetze/Bausatz_AVR_NET_IO.html" target="_blank" title="Pollin AVR Ethernet Board">Ethernet Board with an Atmel AVR microcontroller</a>, my <a href="http://blog.coldtobi.de/1_coldtobis_blog/categories/19_thecus_n2100.html" target="_blank" title="Category Thecus N2100">Thecus N2100</a> as control server and <a href="http://php.org" target="_blank">PHP</a>. 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: <ul> <li>Connecting to the network </li> <li>Setting the digital outputs and reading back the status (with the possiblity to cache the results) </li> <li>Reading the digital inputs (with the possiblity to cache the results) </li> <li>Reading the analog (ADC) inputs . </li> </ul>   Download the code Here's the library:  <a href="http://frost.de/files/net_io.txt" target="_blank">http://frost.de/files/net_io.txt</a> (make sure to change the extension to .php) And here are some testcases, also illustrating the usage:  <a href="http://frost.de/files/net_io_testcases.txt">http://frost.de/files/net_io_testcases.txt</a> (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): <blockquote> $p = new pollin_netio("10.243.48.250"); </blockquote> Setting an Output (example: Port 0 to high, 5V) - note Port 0 is Port 1 as on the hardware schematic. <blockquote> if ( false == $p->setport(0,1)) {         echo "ERROR on setting port 1\r\n";     } else  {         echo " OK setting port 0\r\n";     } } </blockquote>  Reading the input IO (eg. input 1) <blockquote> $port = $p->query(8, false); </blockquote> Reading analog values <blockquote> 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";     } } </blockquote>   Electronics and Atmel AVR Thecus N2100 2011-02-09T19:37:08Z coldtobi Link to safe http://blog.coldtobi.de/1_coldtobis_blog/archive/297_link_to_safe.html 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. Blog and Website 2011-01-23T10:01:07Z coldtobi