30 September, 2015

WordPress on the lan - how to use the correct url

Phpmyadmin > wordpress > wp_options


Problem: localhost in stead of ip
In links and stylesheets WordPress used something like:

http://localhost/whatever ...

It should be something like:

http://192.168.0.22/whatever ...

Solution: 
Open the wp_options table, and rename the http address to the correct ip, e.g.

siteurl: http://192.168.0.12/wordpress
home: http://192.168.0.12/wordpress

27 September, 2015

Get read and write permissiongs to shared WordPress (or other) folders

It's so nice to be able to edit your themes in the File Manager


This works like a magick spell:
# sudo groupadd tomandruser

Now that the group exists, add the two users to it:

# sudo usermod -a -G tomandruser tomcat6
# sudo usermod -a -G tomandruser ruser

Now all that's left is to set the permissions on the directory:

# sudo chgrp -R tomandruser /path/to/the/directory
# sudo chmod -R 770 /path/to/the/directory

( See Andrew Lambert's proposal no. 71 in this thread )

On my localhost I decided to share the WordPress themes folder in this way. Here's what I did on my Debian-based system:

  1. Created the goup called webeditor
  2. Added my user to the group.
Added www-data to the same group.
  1. Changed the themes/ folder to the webeditor group.
  2. Changed the permissions of the themes folder to 777.

Now I only need to create a folder and ln -s to the themes folder. Then it's possible to edit themes at log in via the symbolic link:

# ln -s /var/lib/wordpress/wp-content/themes/ ~/wpthemes

But when WordPress or the user create their own stuff, it looks like this:

$ ls -l
totalt 16
drwxr-xr-x 6 www-data www-data  4096 sep 27 09:23 dusk-to-dawn
drwxrws--- 7 www-data webeditor 4096 sep 27 09:33 twentyfifteen
drwxrwx--- 9 www-data webeditor 4096 sep 26 19:30 twentyfourteen
drwxr-xr-x 2 per      per       4096 sep 27 09:52 x


So you can edit the files, but have to change the permissons to folders installed by WordPress.
 

26 September, 2015

WordPress on Debian - where are the files?

You can install WordPress on a Debian system. Follow the instructions here. This install will make a WordPress site available on your localhost, but the files are not found here.

# var/www/html/

Actually they are saved in a number of different directories. First the virtual host is defined in apache:

# /etc/apache2/sites-available/wp.conf

Alias /wp/wp-content /var/lib/wordpress/wp-content
        Alias /wp /usr/share/wordpress
        
            Options FollowSymLinks
            AllowOverride Limit Options FileInfo
            DirectoryIndex index.php
            Require all granted
        
        
            Options FollowSymLinks
            Require all granted
        
 These aliases tell Linux where to find the different WordPress files.

Here are the configuration files:

# /etc/wordpress

Here you find the config-localhost.php file. In this file you set up the database connection:

define('DB_NAME', 'wordpress');
define('DB_USER', 'wordpress');
define('DB_PASSWORD', '*******');
define('DB_HOST', 'localhost');
define('WP_CONTENT_DIR', '/var/lib/wordpress/wp-content');
?>


Here are the actual WordPress files:

# /var/lib/wordpress/

The WordPress themes and plugins etc. are here:

# /usr/share/wordpress/wp-content

WordPress on Debian - enable update

If you get errors when trying to update or installing themes or plugins try to change the owne of the WordPress directory to www-data and change the chmod to 755:

# chown -R www-data:www-data /var/lib/wordpress/
# chmod -R 755 /var/lib/wordpress/

Install Brackets on a Antix Linux OS

Brackets needs libcrypt in order to run. Download libcrypt from this page. Here's what I did:
 
# wget http://ftp.us.debian.org/debian/pool/main/libg/libgcrypt11/libgcrypt11_1.5.0-5+deb7u3_amd64.deb
# dpkg -i libgcrypt11_1.5.0-5+deb7u3_amd64.deb
#  dpkg -i Brackets.1.4.Extract.64-bit.deb

23 September, 2015

Pandoc - a simple way to compile the semester curriculum

Here's the method:

# pandoc --bibliography=books.bib lectures-day00*.md -o curriculum_course_all_lessons.pdf

This method will compile all relevant *md documents to one, and add the complete list of sources in the end, e.g.:

Brazel, Aron. 2010. The WordPress Bible. Wiley Publishing. http://it-ebooks.
info/book/1887/.
Forta, Ben. 2011. MySQL Crash Course. Sams.
Mcfarland, David Sawyer. 2008. JavaScript - the Missing Manual. O’Reilly.
Wordpress.org. 2015. “Codex.” http://codex.wordpress.org.

14 September, 2015

Raspberry Pi / Sony Bravia

Waiting for the Sugru to dry.
And then ... XBMC
on our Sony TV.

Glue the Pi on your TV!

The first generation of Sony Bravia had web options, but to be honest: the greatest thing here is the HDMI slot. You can connect any PC or DSLR or whatever. Behind the TV a Raspberry Pi is almost invisible. In fact it's more advanced than the intestrians of the Bravia. So why not make the RasPi permanent here? Just glue it on with some Sugru ...


The Pi Configuration

  • An Apache web server.
  • A XBMC media center.
  • X.
  • Noobs.



The remote

This post:

http://www.instructables.com/id/Raspberry-Pi-Remote-For-Free/

says, that you can connect the Pi to the Sony Bravia. Then press "Sync Menu" on the remote. And then the remote should work ...

Right now I cannot test. I'm waiting for the Sugru to harden, because I mounted the Pi behind the TV with some Sugru ...

Todo - later on


  • DMZ the Pi on the router (using this guide).
  • Figure out a method to allways have the IP address.
  • Set up a firewall with ufw.
  • Try to secure Apache.
  • And security issues in MySQL.

12 September, 2015

Koala - SASS and Compass the easy way



Koala will give you easy access to your Sass / Compass projects. You don't need to use the commandline at all. The error log is a great help for debugging your code.