I would like to debug PHP in Eclipse PDT while it runs under an Apache server with a bit of MySQL thrown in. In order to do the remote debug one needs to configure PHP to use XDebug which is a standard cross-platform debugger that is used by a variety of languages to debug over the wire. It is based on DBGp, a common debugger protocol for languages and debugger UI communication.
I followed the standard instructions to switch on XDebug except that I installed it under
e:\xampp instead of the default
- Launch the XAMPP Control Panel.
- On the Apache row click Config, then PHP (php.ini) to load the PHP configuration file.
- Forward search for [XDebug]
Make sure the following options are uncommented (i.e. remove the semi-colon at the front of the line) and fill in the entries to match those below.
zend_extension = “E:\xampp\php\ext\php_xdebug.dll”
xdebug.remote_enable = 1
xdebug.remote_handler = “dbgp”
xdebug.remote_host = “127.0.0.1″
xdebug.remote_port = “9000″
- Stop Apache
- Start Apache
On starting Apache the following message pops up:
The procedure entry point zend_unmangled_property_name_ex could not be located in the dynamic link library php5ts.dll
After a lot of really boring reading in the usual forums and help web sites I find out that the
php_xdebug.dll is not compiled correctly for the version of PHP I’m using. This is very strange because it was downloaded as a bundle so everything should be compatible with everything else, but it wasn’t.
To confirm this type:
which gives the following output:
Failed loading E:\xampp\php\ext\php_xdebug.dll
Microsoft Windows dictates an internal DLL binary format which coincidentally is released with a new version of Microsoft’s Visual studio. This makes programs compiled with different versions of compiler incompatible with each other - thanks for that. It causes problems in every computer language that is compiled with a Microsoft compiler. PHP is just one of them. Python is another. If you compile Python under Visual Studio 9 you will have to recompile all the support modules with the same compiler. So not only do you have to care about whether it was compiled into 32 or 64 bit code but you also have to care about which compiler was used too.
The name of the XAMPP binary tells you which version of Visual ‘C’ was used to create the application suite. In my case I downloaded
xampp-win32-1.8.2-0-VC9-installer.exe. From the file name we can see that this is a windows 32 bit version compiled using Visual ‘C’ 9.
This only gives us some of the story. For the rest we need to run XAMPP and get it to tell us how it was compiled. In the document root
E:\xampp\htdocs create a file called p.php and fill it with:
<?php phpinfo(); ?>
Next open you browser and go to: http://127.0.0.1/p.php.
There are several lines of importance:
PHP Version 5.4.16
Compiler MSVC9 (Visual C++ 2008)
Zend Extension Build API220100525,TS,VC9
PHP Extension Build API20100525,TS,VC9
phpinfo() confirms that Microsoft’s Visual ‘C’ version 9 (MSVC9) was used as the compiler which was built in Visual C++ 2008. The Visual C++ 2008 tells us that the Apache needs the Visual C++ Redistribution libraries to be installed. You wouldn’t be able to run Apache with out them. If may explain why XAMPP may work on a newer server but give DLL errors on an older one.
x86 is the hardware architecture and indicates that it is a 32 bit build.
Zend Extension Build and PHP Extension Build have their compiler options although in this case the only important part of this is the TS bit. I think that in some builds of PHP the TS may not exist or it might be NTS instead.
Next we have to download a new version of XDebug that will fit into our environment. So navigate to:
In the Releases section look for the version that has the compiler flags we need. We’ll start with the latest version (XDebug 2.2.3 at the time of writing). I’m using PHP version 5.4 compiled using VC9 with TS and for a 32 bit build. So I download PHP 5.4 VC9 TS (32 bit) (php_xdebug-2.2.3-5.4-vc9.dll).
There are 2 ways to install it.
- Stop Apache
- Start Apache
Windows being what it is with locking files means that you have to stop Apache before copying the DLL in to the correct place which will slightly increase the downtime. This might work better as a tested upgrade on a production system where you don’t want to touch the configuration files.
Alternatively you can:
Edit the zend_extension line in the php.ini to point to this version.
zend_extension = “E:\xampp\php\ext\php_xdebug-2.2.3-5.4-vc9.dll”
xdebug.remote_enable = 1
- Stop Apache
- Start Apache
Most people choose this option because it gives you a better infrastructure for testing different versions as well as an easy rollback or upgrade path in case anything goes wrong. It also reminds you which version of XDebug you are using. The DLLs stay in place and you are only changing the configuration files. As a result there is no gap between the Apache restart.
Finally navigate to your
phpinfo() page and there should be a section for XDebug.
I spent almost half a day trying to figure out why the SD card plugged into the side of my MacBook Pro suddenly became read-only.
After wading through an awful lot of Apple forums containing “are you sure you have the SD card read-only lock in the correct position” I discovered several aspects of this problem that will hopefully save other people from pulling their hair out.
- The problem happens more often than not on SDHC type cards.
- Mac has some out-of-specification code to write to SD cards which is not compatible with other card readers.
- There is a fault with the onboard card reading which falsely reports that the physical read-only lock is active.
- It matters how you insert the SD card into the SD reader’s slot.
- All problems can be solved by using an external card reader.
The problem I was suffering from was that of the false positives on the SD card reader’s read-only sensor. The device file for the onboard SD card reader was
/dev/disk1 so I’ll use that in the work-around procedure that follows:
- Open a terminal window and type:
$ ls -l /dev/disk1*
br–r—– 1 mrn operator 14, 0 11 Jun 00:24 /dev/disk1
- Make sure the SD card’s physical switch is pressed down in the unlocked position. There should be a label on the card itself to remind you.
- Insert the card firmly applying the pressure directly along the line of insertion.
- Run the above line again to check the read-only status.
- If the device still reports as read-only, pull the card out and insert your fingernail in between the physical lock switch. The gap should remain when you remove your nail, then repeat the test.
- Increase the width by about a fingernail’s worth each time you run the test and eventually you will reach the sweet spot. The test will report:
$ ls -l /dev/disk1*
brw-rw—- 1 mrn operator 14, 0 11 Jun 00:24 /dev/disk1
It took me about 3 or 4 iterations to find the right point.
- Go to Settings > Account Settings > Apps > Apps you use.
- Find the game, click Edit.
- Change Visibility of App to Only me.
- Also delete the This app can also post on your behalf bit.
From Wikipedia OpenMeeting is:
OpenMeetings is software used for presenting, online training, web conferencing, collaborative whiteboard drawing and document editing, and user desktop sharing. The product is based on OpenLaszlo RIA framework and Red5 media server, which in turn are based on a bunch of open source components. Communication takes place in meeting rooms which are set to different communication, security and video quality modes. The recommended database for backend support is MySQL. The product can be set up as an installed server product, or used as a hosted product.
Today we will be installing OpenMeeting on CentOS 6.3 (64-bit).
Find a nice place to work:
Go to http://openmeetings.apache.org/downloads.html and download and unpack latest binary.
tar -xzvf ../apache-openmeetings-incubating-2.0.0.r1361497-14-07-2012_1108.tar.gz
The default installation of OpenMeeting uses an integrated Apache Derby database to persist data at the back end. They recommend MySQL (or a real database) for production installations. I however, like to easily poke around the database and investigate how the product works. The trouble with an integrated database is that it won’t be available when the application is down and it may not be available to clients outside the application.
OpenMeeting requires UTF8 so we’ll install MySQL and configure the collation.
- Install PHP and MySQL with
There are a few problems of setting the collation with MySQL so. Edit
/etc/my.cnfand add the following lines to the mysqld section:
collation-server = utf8_unicode_ci
init-connect=’SET NAMES utf8′
character-set-server = utf8
- Then restart MySQL with:
yum install php mysql-server mysql
Now that we have MySQL installed, we’ll have to create a MySQL account for OpenMeeting to use.
- Login to MySQL:
- Create the database:
CREATE DATABASE openmeetings;
- Create a MySQL user for the application:
CREATE USER openmeetings;
- Set permissions:
GRANT ALL ON openmeetings.* TO openmeetings@localhost;
- Set password (change **** to your password):
SET PASSWORD FOR openmeetings@localhost=PASSWORD(’****’);
- Log out of MySQL:
Now we will just check that our new user is set up properly. (Where **** is the password)
mysql -uopenmeetings -p**** openmeetings
OpenMeeting isn’t bundled with all the database connectors so we’ll have to download and install the MySQL connector in order to talk to the database.
- Start off in our dev area:
- Go to http://www.mysql.com/downloads/connector/j/ and download the latest ConnectorJ (at the time of writing this was 5.1.24)
- Unpack it:
tar -xvzf mysql-connector-java-5.1.24.tar.gz
Move the connector to the correct place in the OpenMeeting directory structure so it can be found by the application:
mv mysql-connector-java-5.1.24/mysql-connector-java-5.1.24-bin.jar openmeeting/webapps/openmeetings/WEB-INF/lib/
We are not using the default database type so we must change the configuration files so that the OpenMeeting installation process uses the MySQL configuration file instead of the integrated Derby configuration file.
Go to the connectors folder:
Use the MySQL configuration template:
cp mysql_persistence.xml persistence.xml
persistence.xmland change the MySQL credentials. At the bottom of the file you will see
…. , MaxActive=100
Change the Username and Password to what you set earlier. If you want to change the database name
Now we are going to set up Enabling Image Upload and import to whiteboard.
To install ImageMagick we’ll use the package manager:
yum install ImageMagick
Installing ImageMagick will install GhostScript as a dependency so we get part 1 of Enabling import of PDFs into whiteboard for free. Part 2 requires installing SWFTools which we will do now:
Start in our development directory:
Go to http://www.swftools.org/download.html and get the latest version:
tar -xvzf swftools-0.9.2.tar.gz
If this is a minimal version of CentOS (or you type
gccand get bad command) then you’ll need to install the C compiler and tools:
yum install gcc* automake zlib-devel libjpeg-devel giflib-devel freetype-devel make
Prepare to build the software:
Run the pre-build configuration script:
There is a bug in the
make install step so we’ll just fix that before running it.
Search for the install: directive and change:
rm -f $(pkgdatadir)/swfs/default_viewer.swf -o -L $(pkgdatadir)/swfs/default_viewer.swf $(LN_S) $(pkgdatadir)/swfs/simple_viewer.swf $(pkgdatadir)/swfs/default_viewer.swf rm -f $(pkgdatadir)/swfs/default_loader.swf -o -L $(pkgdatadir)/swfs/default_loader.swf $(LN_S) $(pkgdatadir)/swfs/tessel_loader.swf $(pkgdatadir)/swfs/default_loader.swf
<TAB>rm -f $(pkgdatadir)/swfs/default_viewer.swf <TAB>$(LN_S) $(pkgdatadir)/swfs/simple_viewer.swf $(pkgdatadir)/swfs/default_viewer.swf <TAB>rm -f $(pkgdatadir)/swfs/default_loader.swf <TAB>$(LN_S) $(pkgdatadir)/swfs/tessel_loader.swf $(pkgdatadir)/swfs/default_loader.swf
Make sure that the first and only character at the start of the replacement lines is a TAB and not a space.
Now we can run:
Next we’ll install the dependencies for Enabling import of .doc, .docx, .ppt, .pptx, … all Office Documents into whitebaord. This also installs Oracle’s Java which is why we didn’t install it earlier.
Install Libre Office:
yum install libreoffice-writer
Enabling Recording and import of .avi, .flv, .mov and .mp4 into whiteboard requires FFMpeg which is not available via standard yum so we’ll add another repository that does contain it. Thanks to needlessly does a “yum update” which would probably update everything seeing as CentOS keep stable older version instead of the bleeding edge.
name=DAG RPM Repository
Import keys so we can talk to the repository securely:
rpm −−import http://apt.sw.be/RPM-GPG-KEY.dag.txt
yum install ffmpeg
Enabling Recording and import of .avi, .flv, .mov and .mp4 into whiteboard also requires SOX but that is available on the standard yum so just install that.
yum install sox
I have read through the installation instructions for OpenMeeting and they are as clear as mud. Half the documents seem to say that JODConverter is needed and the other half say that it isn’t. Even the project page for JODConverter says that the project isn’t even maintained. It has some connection to OpenOffice/LibreOffice, so I’m installing it anyway just in case.
Change back to our scratch folder:
- Go to http://code.google.com/p/jodconverter/
And download the latest version:
Then unzip it
Well that’s it for the dependencies. Hopefully OpenMeeting will find all the things it needs during it installation.
After following the original instructions for installing OpenMeeting, the Oracle Java had been replaced by the GNU version of the Java runtime. When I started the OpenMeeting container it use that version instead of the Oracle implementation and didn’t work.
If you install the dependencies in the order that I described above then Oracle’s Java should come out on top. We need to check to make sure though:
Get which version of Java are you running:
You should get:
java version “1.7.0_13″
Java™ SE Runtime Environment (build 1.7.0_13-b20)
Java HotSpot™ 64-Bit Server VM (build 23.7-b01, mixed mode)
- If you don’t then you’ll have to uninstall the GNU version:
yum remove gij
rpm -e jre
And reinstall Oracle’s Java over the top:
- Navigate to: http://www.java.com/en/download/manual.jsp
- And download the appropriate version I selected “Linux x64 RPM".
- Install via the Redhat Package Manager, you might see a couple of errors like “Error: Could not open input file” but you can ignore these.
rpm -i jre-7u13-linux-x64.rpm
OpenMeeting uses a couple of ports to communicate with so make sure your firewall allows traffic on them. For development purposes the following will remove all firewall rules until you reboot.
To start OpenMeeting:
- Change directory:
It should print a lot of information on the screen. There will be pauses and gaps but when it starts repeating no Appointments in range you are ready for the next step.
You can check [crudely] that the database has been created in MySQL by ensuring that there are plenty of files in:
The final part of the installation is run from the web interface so navigate to:
localhost is the machine you have installed OpenMeeting on.
Click the link Continue with STEP 1. This will take you to the initial configuration screen where you can set up the application:
In the Userdata section fill in the admin user
In the Configuration section I didn’t touch anything but the names seem pretty self explanatory if you know how to set up your mail system (which is beyond the scope of this document).
In the Converters section we need to add the paths to the support utilities as they won’t be available to the servlet container.
All the Converter support applications should be in your path except jodconverter-core. I still don’t understand if or how JODConverter is needed, so add a reference to the JOD path anyway.
I leave all the other stuff to their defaults.
Finally click INSTALL. The
red5.sh screen will spend a couple of minutes spewing out data, so let it get on with it. When it has finished your web browser will sent you to the “Installation Complete!” page.
Click Enter the Application and login with Username as admin and Password as admin.
The rest is up to you! Good luck.
I’m running Vista at the moment and it is terrible. I think we are all tired of the appalling file copying mechanism. I came across a new bug in Vista today and thought I’d blog how I got out of it.
Task manager was loaded in and minimized.
- Right-clicked on the Task manager icon in the systray and the menu appeared. The menu items were click-able but the clicks wouldn’t register. The menu wouldn’t disappear after that, no matter what you did.
- The minimized icon in the systray was spiking, It appeared to be flashing as it rapidly switched from high CPU to low CPU.
I couldn’t start any explorer sessions using the following methods:
- The WindowsKey-E wouldn’t work.
- Clicking New Task… inside the Task manager and running
We must kill Task manager from the command line.
- First we need to start a Powershell session, because a normal command window doesn’t have the right tools in its path. Start->Run
- Next list the processes currently running on the machine.
PS C:\Users\mrn> Get-Process
Handles NPM(K) PM(K) WS(K) VM(M) CPU(s) Id ProcessName
——- —— —– —– —– —— – ———–
118 9 4552 11972 98 0.95 4132 taskmgr
- Make a note of the the Id of the Task manager process (taskmgr).
- Powershell makers have created a “kill” alias to the Stop-Process command to make it look a bit more like wonderful unix.
- You may find that the systray icon is still present. If you hoover over the icon it will disappear.