Software development, photography, jokes, ....

Sites by me

 
tas-logoTransportation Administration System
snoezelkussen-logo-kleinstSnoezelen Pillows for Dementia
ikzoekeenbegeleider-logoBegeleiders voor gehandicapten
Laat uw hond het jaarlijkse vuurwerk overwinnen
Betuweroute en Kunst
logo 50x50Hey Vos! Je eigen naam@vos.net emailadres?
Kunst in huis? Nicole Karrèr maakt echt bijzonder mooie dingen
nettylogo2Kunst in huis? Netty Franssen maakt ook bijzonder mooie dingen
Professionele opvang bij Gastouderbureau
Kind-Zijn
Salarisadministratie en belastingadvies bij
De Zaak Loont
Zutphense Bomenstichting

Hosting Favorites

 
ANU Internet Services
XelMedia .internet services
register.com
GoDaddy.com

Blogroll

 
Bomenstichting
MacFreak
Google Translate
PHP
MySQL
jQuery
jQuery UI
codecademy
YourHead Stacks API
Favicon Generator. For real.
Check HTTPS problems



Categories

Archives
 Dec 2019 (1)
 Nov 2019 (1)
 Oct 2019 (2)
 Aug 2019 (2)
 Jun 2019 (2)
 May 2019 (2)
 Apr 2019 (5)
 Feb 2019 (6)
 Dec 2018 (2)
 Nov 2018 (1)
 Oct 2018 (1)
 Sep 2018 (5)
 Aug 2018 (1)
 Jul 2018 (6)
 Jun 2018 (4)
 May 2018 (2)
 Apr 2018 (3)
 Mar 2018 (10)
 Feb 2018 (8)
 Jan 2018 (2)
 Dec 2017 (3)
 Nov 2017 (4)
 Oct 2017 (3)
 Sep 2017 (2)
 Aug 2017 (2)
 Jul 2017 (1)
 Jun 2017 (2)
 May 2017 (4)
 Apr 2017 (4)
 Mar 2017 (2)
 Feb 2017 (2)
 Jan 2017 (5)
 Dec 2016 (5)
 Nov 2016 (5)
 Oct 2016 (2)
 Sep 2016 (4)
 Aug 2016 (2)
 Jul 2016 (4)
 Jun 2016 (2)
 May 2016 (3)
 Apr 2016 (6)
 Mar 2016 (3)
 Feb 2016 (1)
 Jan 2016 (3)
 Dec 2015 (3)
 Nov 2015 (4)
 Oct 2015 (4)
 Sep 2015 (3)
 Aug 2015 (3)
 Jul 2015 (1)
 Jun 2015 (1)
 May 2015 (3)
 Apr 2015 (2)
 Feb 2015 (3)
 Jan 2015 (3)
 Dec 2014 (4)
 Nov 2014 (2)
 Oct 2014 (5)
 Sep 2014 (4)
 Aug 2014 (5)
 Jul 2014 (2)
 Jun 2014 (2)
 May 2014 (5)
 Apr 2014 (2)
 Feb 2014 (1)
 Jan 2014 (2)
 Dec 2013 (2)
 Nov 2013 (3)
 Oct 2013 (3)
 Sep 2013 (2)
 Aug 2013 (1)
 Jul 2013 (3)
 Jun 2013 (2)
 May 2013 (3)
 Apr 2013 (3)
 Mar 2013 (6)
 Feb 2013 (3)
 Jan 2013 (4)
 Dec 2012 (5)
 Nov 2012 (3)
 Oct 2012 (3)
 Sep 2012 (6)
 Aug 2012 (4)
 Jun 2012 (5)
 May 2012 (7)
 Apr 2012 (4)
 Mar 2012 (1)
 Feb 2012 (5)
 Jan 2012 (5)
 Dec 2011 (5)
 Nov 2011 (7)
 Oct 2011 (4)
 Sep 2011 (6)
 Aug 2011 (3)
 Jul 2011 (7)
 Jun 2011 (9)
 May 2011 (3)
 Apr 2011 (8)
 Mar 2011 (7)
 Feb 2011 (2)
 Jan 2011 (3)
 Dec 2010 (6)
 Nov 2010 (10)
 Oct 2010 (4)
 Sep 2010 (3)
 Aug 2010 (10)
 Jul 2010 (10)
 Jun 2010 (1)
 May 2010 (1)
 Apr 2010 (2)
 Mar 2010 (2)
 Feb 2010 (5)
 Jan 2010 (1)
 Dec 2009 (6)
 Nov 2009 (6)
 Oct 2009 (4)
 Sep 2009 (2)
 Jul 2009 (1)

Marc's Place


 

Powered by the Blogspot.stack

Setup your local macOS X web server #apache #macos #macosx #webserver #localhost #webdevelopment

 Permalink
I've put together a page where I describe how you can setup a web development environment with two or more Apple Macs.

If you are a web developer working on Apple Macs, you sure do want to use the macOS X built-in web server, Apache, on all your Macs. And you want to be able to access your Sites folder, local web documents folder and your other Mac via HTTP.

I'll describe how to set it up on macOS High Sierra (10.13.5). If you're on a previous version of macOS X, not to worry, the steps to take are practically identical. Read on ...
 Comments

I love the invention of virtualization

 Permalink
Click image to enlarge!
 Comments

Apache vhost sort order on CentOS

 Permalink
I’ve written a page on how to control the order of Apache vhosts [on CentOS]. Just for reference.
 
 Comments

Cool Unix-Shell Prompt

 Permalink
At the shell-prompt in Terminal or some SSH session, copy/paste the following line:

export PS1="\n\u@\h \A \w $ "

and see the following nice shell-prompt:

shellprompt
You will have the following information always present:
  • Who you are
  • On which machine you are
  • The current system time
  • The current working directory cq. folder you are in
  • The $ as the separator
  • And a new line after a command
To have this prompt permanent, add the line mentioned above to the file /etc/profile

 
 Comments

Quickly transfer MySQL databases to a new server

 Permalink
Again I needed to transfer all data from one server to another. I knew I documented the transfer of MySQL databases somewhere (it's deep inside in the Replication-how-to) and decided to post them again here, so they're quicker to find.

One can transfer MySQL databases in various ways:
  1. Using mysqldump and zip + ftp
  2. Zip the database itself + ftp (you might need to repair the tables after unzipping)
  3. Use Navicat's Data Transfer module (not always good for tables with millions of records or blob data)
Personally, I prefer to use option 2, like below, in Terminal or an SSH session:

$ cd /var/mysql/ (or /var/lib/mysql/)
$ sudo zip -r ~/[database].zip [database]

Do this for each database that you want to copy. Then send all zip's per FTP to the new server.
Start an SSH session with the remote server and enter the following commands:

$ cd /var/mysql (or /var/lib/mysql/)
$ sudo unzip ~/[database].zip
$ sudo chown -R _mysql:admin [database]

For the above chown, check first with ls -l if _mysql:admin are the right owners. Then do this for each unzipped database.

Next, start Navicat and now you should see your databases in the connection of the new server. If not, you probably forgot to either do a Refresh Connection or the chown-command.

If you can access the tables and view data, good! If not, right click the table and choose Maintain->Repair Table->Quick or ->Extended and then try again.
 
 Comments

ProFTPD with MySQL backend

 Permalink
I know there are already many pages about ProFTPD and MySQL, but all info I needed was scattered over the Internet.
Therefore I collected all info I needed and put into one page: Setup ProFTPD and MySQL.
 
 Comments

Daily Script on Mac OS X Server did not clean up /tmp

 Permalink
Lately my /tmp folder was piling up with files (krb5cc*) without any signals that these files were regularly deleted. A bit of googling showed that these come from the Open Directory Server, but that's something I cannot control. So I went to investigate why the daily script would not delete them. I googled a bit again and found out where the parameter file for the daily, weekly and monthly cleanup-scripts is located: /etc/defaults/periodic.conf. There, I found these settings for /tmp :

# 110.clean-tmps
daily_clean_tmps_enable="YES"           # Delete stuff daily
daily_clean_tmps_dirs="/tmp"            # Delete under here
daily_clean_tmps_days="3"               # If not accessed for
daily_clean_tmps_ignore=".X*-lock .X11-unix .ICE-unix .font-unix .XIM-unix"
daily_clean_tmps_ignore="$daily_clean_tmps_ignore quota.user quota.group"
                                        # Don't delete these
daily_clean_tmps_verbose="YES"          # Mention files deleted


The one to look for is where it says "3". This indicates that the routine should clean up old files not accessed for 3 days. But it did not - and the files were not mentioned in the ignore-parameters. Even rm -rf krb5cc* returned immediately an error that its argument list was too long. Therefore I started reading what the exact values for this parameter should be.

Well, it turns out that the value needs a qualification, like d(ays) or m(months), etc.. I found that out by reading /etc/periodic/daily/110.clean-tmps and studying how find uses -atime, -ctime and -mtime and how to add or subtract values. Here are a few find-commands, copied from /etc/periodic/daily/110.clean-tmps, which I tried to make sure that what I just read was right:

$ cd /tmp
$ sudo find -dx . -fstype local -type f -atime +1h -mtime +1h -ctime +1h
$ sudo find -dx . -fstype local -type f -atime +1d -mtime +1d -ctime +1d
$ sudo find -dx . -fstype local -type f -atime +2d -mtime +2d -ctime +2d


Further reading suggested to use override-files, so I sudo'd into vi to create the file /etc/periodic.conf with the following contents:

daily_clean_tmps_days="2d"

Yes, 2 days. Three days is too long for a server, in my opinion. The file's attributes look like this:

marcvos @ ~ $ ls -l /etc/periodic.conf
-rw-r--r-- 1 root wheel 27 Oct 25 16:38 /etc/periodic.conf


Next, delete the file daily.out:

$ sudo rm /var/log/daily.out

Reboot the server. Check your /tmp folder and /var/log/daily.out the next days.

With me, I now finally saw all those files getting deleted.
 
 Comments

Using FTP in Lasso

 Permalink
I created a page about the various ways to use the FTP protocol with Lasso, from and to various systems. Find it here. I have been trying to get it work the last few days and now that it does, I wanted to share what you can do. Of course there are probably installations where it all works out-of-the-box, but this time not with me.
 Comments
© 1997- Marc Vos (and others)   -   Privacy Statement   -    Contact Me