Category Archives: IT Related Stuff

Moving a live WordPress site to a local LAMP Server

Linux, Apache, MySql, WordPress, Web Development, Algarve, Portugal
LAMP on Ubuntu 18.04

Audience: Ubuntu Desktop and Server users. Tested on 18.04

Steps to follow to setup a local development WordPress installation.

1) Copy your entire live WordPress directory to your local LAMP server.

Do this by means of FTP using and FTP Client such as Filezilla.

This should include your wp-admin, wp-includes , wp-admin and all the files in the root directory in which these reside. This is where the wp-config.php, wp-login.php, .htaccess files etc reside.

2) On your LAMP server these should be placed in the directory. It is advisable to create a folder under the html directory where these files will go if you are hosting more than one test site. e.g var/www/html/testsite

3) Backup the MySql database related to your WordPress live site. It is easiest to do this using PHPMyAdmin provided by your control panel of your hosting site. This is the only way have done it so far. Accept defaults and export the database. You will be given the option to save the file as a *.sql file.

Ubuntu 18.04, WordPress, Stack Exchange, Ask Ubuntu, Algarve, Portugal

4) On your LAMP server create a MySql database and database user. You can use PHPMyAdmin. However I have had problems, with PHPMyAdmin throwing up errors and not importing the database correctly or granting user privileges correctly. I have had to do it via command line like this. I strongly advise this method, as command line rules. 🙂

By command line.

Log into mysql as root

Create database

mysql> create database db_name;

Import the database:

mysql> use db_name;

mysql> source backup-file.sql;

Create a user and grant privileges

GRANT ALL PRIVILEGES ON mydb.sql TO myuser@localhost IDENTIFIED BY "mypassword";

5) Edit your WordPress wp-config.php ensuring that the database name, username and user password match the ones created.

6) Update your tables to ensure your links work but running the following 3 command line MySql queries on the following tables. You can do this by logging into mysql as root via command line.

UPDATE wp_options SET option_value = replace(option_value, 'http://www.example.com', 'http://localhost/test-site') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.example.com', 'http://localhost/test-site');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.example.com','http://localhost/test-site');

These queries will replace references to your live site’s URL from database with the localhost URL.

7) Lastly, an mostly importantly this pertains to the Ubuntu operating system environment. Apache here is installed differently from a native install for security reasons. In order to get your development WordPress running, you must do the following otherwise none of the symlinks ( symbolic links) to other pages on your site will work.

Note: nano is a text editor that’s pre-installed on Ubuntu

  1. In /etc/apache2/apache2.conf, edit AllowOverride None for /var/www/ to AllowOverride All
  2. To edit use

sudo nano /etc/apache2/apache2.conf

Press CTRL + W and search for “<Directory /var/www/>”

Change here AllowOverride None to AllowOverride All

Save file and exit. (Press CTRL + X, press Y and then press ENTER)

  1. Type in the following command to enable mod_rewrite for .htaccess

sudo a2enmod rewrite

  1. Restart your apache server:

sudo service apache2 restart

Finally make sure you have a .htaccess file in the root directory where WordPress is installed.

It should contain code similar to this:

# BEGIN WordPress

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteBase /your_directory/

RewriteRule ^index\.php$ – [L]

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule . /your_directory index.php [L]

</IfModule>

# END WordPress

That’s about it for now! Coming soon, a Control Panel App for a local LAMP install.

Sources:

Credits to: https://wordpress.stackexchange.com/users/84055/avinash (April,2020)

Credits to: https://www.wpbeginner.com, Editorial Staff at WPBeginner led by Syed Balkhi. (April,2020)

LAMP on Ubuntu 18.04

I took the leap and migrated to linux, ditching MS Windows 7 as my main operating system.

On the whole I am very pleased with Ubuntu 18.04.

I was running XAMPP on Windows 7 as test environment for hosting WordPress and PHP based applications.

So I needed to install a similar test environment on Ubuntu 18.04 desktop. In the Linux world this is LAMP. The components of LAMP are Linux, Apache Web Server, MySQL Server and PHP

Here is how to install LAMP on Ubuntu 18.04

Using command line via Terminal (press Control+Alt+T ) Terminal  Ubuntu 18.04

Install Mysql.

  • Ensure you have an internet connection then open Terminal.
  • Type sudo apt install mysql-server

Press Enter on the keyboard. This will install the Mysql Metapackage from the Debian repositories.

Test your Mysql server installation by typing mysql in the terminal window. You used be able to login with your Ubuntu user login password.

Install Apache 2

To install Apache you must install the Metapackage apache2 from the Debian repositories. This can by

  • Ensure you have an internet connection then open Terminal.
  • Type sudo apt install apache2

Install PHP

  • Ensure you have an internet connection then open Terminal.
  • sudo apt install php-pear php-fpm php-dev php-zip php-curl php-xmlrpc php-gd php-mysql php-mbstring
  • Your server should restart Apache automatically after the installation of both MySQL and PHP. If it doesn’t, execute this command.

Check Apache

You should see the following page with a message saying that it work

Apache Web Server running

Check PHP

  • You can check your PHP by executing any PHP file from within /var/www/.
  • Alternatively you can execute the following command, which will make PHP run the code without the need for creating a file . $ php -r ‘echo “Your PHP installation is working\n”;’

Pat yourself on the back and take a break. Congratulations! You have just successfully installed a LAMP server on Apache.

As a reward install and play Chromium BSU.

  • Ensure you have an internet connection then open Terminal.
  • Type sudo apt install chromium-bsu

This should download and install this excellent arcade game which you can play for 5 minutes to have a break :). I tried downloading it from the Ubuntu Snap store but it didn’t install correctly from there. Chromium B.S.U Debian, Ubuntu 18.04

Preparing LAMP to run as a local WordPress and Web Hosting Test Environment.

Ubuntu installs Apache in modules and splits the configuration files which is different from the standard install.

The Mysql server installs with the Ubuntu user as root for authentication. WordPress and other applications use native mysql authentication.

Here is how to enable native root user authentication and change the mysql root user password.

  • Stop mysql:
  • $ sudo service mysql stop
  • (Be sure to stop the current server before performing the steps. Only one server can run at a time.)
  • $ sudo mkdir /var/run/mysqld; sudo chown mysql /var/run/mysqld
  • $ sudo mysqld_safe –skip-grant-tables&
You should see sonething like this if it runs successfully

[1] 1901

*@*-desktop:~$ 2020-04-29T20:36:42.126862Z mysqld_safe Logging to syslog.

2020-04-29T20:36:42.132327Z mysqld_safe Logging to ‘/var/log/mysql/error.log’.

  • 2020-04-29T20:36:42.197722Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  • Next run $ sudo mysql --user=root mysql
  • This will log you in as the native mysql root user.

“Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.29-0ubuntu0.18.04.1 (Ubuntu)..”

and you should have the mysql prompt mysql>

  • to change the root pasword run

mysql> update user set authentication_string=PASSWORD('new_password') where user='root';

You should see

Query OK, 1 row affected, 1 warning (0.03 sec)

Rows matched: 1 Changed: 1 Warnings: 1”

  • To change the authentication plugin run

mysql> UPDATE user SET plugin=’mysql_native_password’;

You should see someething like

Query OK, 4 rows affected (0.00 sec)

Rows matched: 4 Changed: 4 Warnings: 0

  • Finally

mysql> FLUSH PRIVILEGES;

  • mysql> quit
  • stop and start the mysql server and test root login:

Stop mysql:

$ sudo service mysql stop

Start mysql (normal):

$ sudo service mysql start

Log in as root on localhost:

$ mysql -h localhost -u root -p 

That’s it for now! 

Sources:
Ask Ubuntu - software installation - mysql doesn't ask for root password when installing - Ask Ubuntu

Initial Server Setup with Ubuntu 18.04 | DigitalOcean

https://howtoubuntu.org/ ,How to Install LAMP on Ubuntu, April,2020

Ubuntu 18.04

Life after MS Windows 7

Microsoft Windows 7 ended support in January 2020. What this means to MS Windows users like myself is that your computer will be increasing at risk as it is no longer patched for security vulnerabilities by Microsoft. Ubuntu 18.04

Burying your head in the sand is not an option. However if you are using an island configuration which never has to connect to other computers or the internet you can carry on as you are.

The other two options are to upgrade to Windows 10 or move to another operating system such as Linux.

I have been looking into Ubuntu Linux from Canonical. Their latest desktop version is 18.04 which you can download here.

If you have older machines with 32 bit operating systems you will have to use another distribution of Linux , as Canonical, the owners of Ubuntu only support 64 bit cpus (central processing units) . Linux itself dropped support for 32 bit cpus in 2012.

I haven’t tested any of these as yet but here are a couple of 32 bit distributions.

Ubuntu Linux 18.04 LTS (aka Bionic Beaver :))

This is what I have been testing. You can download the .iso file from (link)here and create a bootable USB or DVD with it. You will also need the Rufus program to burn the .iso. Full instructions can be found here:

Why Ubuntu Linux 18.04 LTS?

  • The LTS (Long Term Support) for starters. This means the operating system is supported for 5 years by Canonical so you will receive security patches. 18.04 LTS will be supported for 5 years until April 2023.
  • The Snap App installer ensures you download software that has been tested and checked for malware by the developers.
  • The GNOME 3 desktop is delightful to use.

The results

I am quite impressed. It picked up and installed the drivers for my network card and wireless worked straight away so I was able to connect to the internet and print to my HP 2600 printer without having to anything.

The only major drawback was there was no storage i.e persistence.. Any programs installed and changes made were lost once you turned the computer off.

Installing Linux with Persistence on a USB stick

The Rufus v3.8 has the ability to create a bootable usb version of linux on a USB drive. See image below. However this does not work for Ubuntu 18.04.4 There is some bug that has not been fixed apparently. (Mosty, 2020).

Rufus iso bootable usb

I found this article on Foss Linux (Adel, 2019) and had a go using the Gparted application on the bootable Ubuntu USB created from the .iso image. You need another spare USB drive on which to install Ubuntu with persistence if you are booting Ubuntu from a USB drive rather than a DVD.

After using the Gparted app. to delete all partitions on the target USB, I began the installation.

(imagGpartede)

I selected Normal installation and Something else as recommend by the article.

Ubuntu normal (2 Ubuntu something elseimages)

Select the drive to partition. Also make sure the correct drive is selected in “Device for boot Menu” at the bottom.select correct drive, Ubuntu

I partitioned the drive with a FAT32, where the installation goes. You can give the mount point any name. This is a Primary partition. This should be a minimum size of 5.3 Gigabytes.Ubuntu FAT32

I next created a logical drive with a ext4 journaling partition (“ / ” mount point) and a swap file partition.

The swap file partition should be a minimum of 4.096 Gigabytes.logical linux swap partition

The ext4 journaling partition is what gives the installation the capability of persistence. I found you can’t see the FAT32 partition by default. successful Ubuntu installation with this configurtion

The Gparted application doesn’t seem to get installed by default when you install Ubuntu.

You can setup Live Patch to keep you secure once you boot up,

Ubuntu Live Patch

and install Apps with the Ubuntu Snap-in Application Manager.

Ubuntu Snap apps

All in all I am happy with Ubuntu 18.04 and am getting to grips with finding my way around this new operating system 🙂

Note: THe FAT32 on which the Ubuntu OS is installed is not visible with File Manager even as Administrator fat32 partition hidden on Ubuntu

Sources:

H. Edel 2019, https://www.fosslinux.com/10212/how-to-install-a-complete-ubuntu-on-a-usb-flash-drive.htm

Foss, 2020 https://itsfoss.com/lightweight-linux-beginners/

Ubuntu Desktop , 2020 https://ubuntu.com/download/desktop

The hazard of using Web Browser Extensions

Extensions for Web Browsers FireFox

We all probably use Extensions in our web browsers without hesitation as they make our life easier.

Popular web extensions include Ad Blockers which block adverts, Video Downloaders which help us download Youtube videos and more .

There is a price to be paid for this convenience as you are literally handing over your life to some other parties. This is especially the case with using free apps out there as not every has good intentions. It is best to start from a point of mistrust until the position of an application such as an Extension or Plugin can be proved otherwise.

Let‘s look at the popular video downloader extension, Video DownloadHelper for the FireFox and Chrome web browsers.

hazard of using browser extensions

Video Downloadhelper

 

Besides the web browser extension, Video DownloadHelper now insists on installing an Companion Application onto your device (where device is desktop or laptop. I have never installed it on a smartphone). All this so that you can download Youtube and other video clips with a couple of mouse button clicks.

However, if you take a look at the permissions this Extension and Companion Application require to run you nay as well hand over your computing device to someone with all your passwords and data including government business and banking details. 

permissions that sign your life away

Permissions!

 

Have a look below and the permissions list and you will see that this extension with it’s Companion app can record and send your every action performed on your device to other parties.

I advice checking the permissions that Extensions and plugins require very carefully before you install them. This includes Advert blockers like AdBlock Plus.

You can get around the problem of downloading videos without signing your life away, I recommend using VLC Player which is a genuine open source project created by the good :). 

VLC Player

VLC Player

 

Here is a link to how to download videos using VLC Player.

Have fun browsing but remember to stay safe. Make a text file of sites and login info you needneed and then periodically clear your cookies and historic data stored in your browser.

BitCoin Wallet for Android and the Jota Text Editor

 

A couple of applications for the android smartphone.

BitCoin Wallet android_BitCoin_Wallet

The first application is a BitCoin wallet. This application is quite lightweight and works well on my Sony Ericsson Xperia smartphone. The system requirements don’t seem to be quite low. This is because the software does not download the full BitCoin blockchain. This makes it quicker at processing the transaction in a reasonable amount of time with limited processing power. It took under two minutes to send Bitcoins from the wallet on my PC to my wallet on my smartphone.

The software can be downloaded directly from the developer’s site as well as Google’s Play Store.

Not being a fan of Google, I prefer to download software that is available directly from the developer. Here’s the link to developer’s site:

https://github.com/schildbach/bitcoin-wallet/releases

After installing the BitCoin wallet please remember to encrypt it and PLEASE make sure you REMEMBER the password that you choose for this. As if you forget it, there is no way that you will be able to access your wallet. It is also advisable to make a copy of this encrypted file and store it elsewhere for example, your computer’s hard drive or a usb stick.

You can also see what developments are being made to the software and make your own requests too on the forum. At the moment NFC (tap to transfer type transaction) functionality has been implemented and is being tested.

https://bitcointalk.org/index.php?topic=29490.0

jota_text_editorJota Text Editor.

My Xperia came without a decent text editor. It had one of sorts but I could never summon it at will and did want to use a google app. Anf give the corporations and GCHQ yet more material to work with. After having a look around I found Jota Text Editor which is a brilliant little text editor it’s pronounced as i-o-t-a by the way.

You can download it from here.

https://sites.google.com/site/aquamarinepandora/home/jota-text-editor

That about wraps it up for now.

Don’t Delay! Secure your online BitCoin Wallet today!

With the current value of BitCoin soaring against the fiat currencies  it’s inevitable that it will attract keen interest from cyber criminals.  Don’t be lulled into a false sense of security by having your wallet stored at an online  exchange.
Whilst many exchanges provide good file security and network on their networks,  they are not responsible for the contents of your wallet being stolen should your password be compromised through a phishing attack or if you login password gets captured by a trojan on your computer/mobile phone.
The best way to secure your wallet is by having  two factor authentication set on it. 
 
Whilst the largest bitcoin exchange Mtgox provides support for this security model the  documentation provided by Mtgox is a appalling and two factor authentication would not be able to be implemented by non technical computer person.

 
If you have an online Mtgox wallet that you access by means of a home computer download and install the the the Google Authentication App. I’m not a big fan of becoming even more dependent on  Google but this is what is  supported by MtGox and will have to do for now unless you decide to buy a YubiKey which is a hardware implementation (via a USB key).

 

  1. Download the  html5 google authenticator app here and  extract the files in into a folder of your choice. Then open the index.html in your browser.

You should have a screen looking something like this, with only the default google alice account.  Click the ‘+’ to create an Mtgox account and enter the PRIVATE Key here that you create at the MtGox site. Login to MtGox now to create this PRIVATE KEY.

2. Creating your Private Key. Log into your MtGox account and go to the Security Centre.

Click on the ‘Add New’ New Software Authentication System. This will bring up the screen shown below.

Print and Save this in a safe place! Take a screen shot of it as you will need to know and keep hold of your Secure Private Key for future reference. Do not Lose it!

3. Now enter this PRIVATE Key into the  place requesting it in the Google Authenticator. You should then have your OTP (one time password aka passcode) appear fro the MtGox account in Google Authenticator and the changes ever 30s.

4.Copy the OTP (also called the Code on the mtGox site)  from the Google Authenticator and  enter it into the 4th field at the bottom called ‘Code’. Then click on the ‘Save’ button.

5. Applying the Security.

Go back to the mtGox security centre. When you created the Private Key using the New Software Authentication System, the first entry created was the Auth Name. This was done automatically. In the screen above it it OTP#5059.

You can apply your OTP to the LOgin, Withdrawal and Security Centre.

Apply it to both the Withdrawals and Security Centre as shown in the screen shot below.  Why link this Google Authentication to the Security Centre. This is so that if someone does gain access to you email account the won’t be able to reset/remove  the security on your Withdrawals and thus steal your BitCoins and other Funds.

  You should now be able to sleep more securely knowing that your valuable BitCoins cannot be stolen should your email account used to autheticate you at MTGox ever get compromised.

Special thanks to BitCoinBull at BitCoinTalk.org for the original posting in the form and to G.Braad (me@gbraad.nl.) for compiling the Google authenticator for HTML5.

 

What I love and hate about my Nokia N95 phone.

Well, perhaps Love/ Hate are  too strong a word. Especially since I am no techno geek or techno whizz and slow to make the  change from a proven and working system. Indeed my N95 came out in 1997 and we have only been together for 3 months. So I am not really up there with the latest technology. In fact the only reason I got it is that I felt it would be handy to be able to access the web via wifi.

So let’s start with the short comings of my Nokia N95.

  • For one you can use it like a normal phone because the ear piece does not work 95% of the time. It’s a bug in the software that never seems to have been ironed out. You have to speak to your call either via loudspeaker or headphones. Shocking! A lot of people must have returned these phones for this reason.
  • Volume control does not work – a design fault where the button breaks of it’s mountings. You can hover adjust the volume and leave it at a preset level using the external volume control cable. No ideal but a work around.
  • Nokia has provided sync support only for MS Outlook and IBM Lotus Notes. This means that you cannot sync your calendar with open source email applications like Mozilla’s Thunderbird which is a pain. And please no one mention Google Calendar. We have already given Google too much power with near search engine monopoly, our addiction to Youtube videos that I don’t really want to hand them my Calendar.
  • Not many applications out there, but I don’t find this to be a limitation as it does web, email, calendar and a couple of instant messenger programs.
  • Some say it’s a bit bulky but I don’t find this a problem.

The things I like about the N95

  • Pretty stable Symbian S60 operating system
  • Decent SatNav and Nokia Maps
  • Great sound system! Puts Apple iPhones to shame. You don’t need external speakers with this on to get the party going )
  • 4 Gb memory for storageis sufficent and the apps cope okay with the 48 Mb internal RAM.
  • Takes great pics with the 5 Mega pixel camera
  • Plays Youtube videos well – Real Player
  • Crystal clear and bright display
  • Supports OggPlayer (free app. but they accept donations) which is great for Audio books – has independent volume control and fast forward/rewind which default Nokia Music Player lacked.
  • Buttons – I like buttons. Nokia’s 3 lettered buttons suit me down to a tee.

Well, that’s be and my N95 in a nutshell. I am not looking to get another phone anytime soon )

Re-installing Monitoring on SBS 2003 SP2

Re-installing Monitoring on Small Business Server 2003 Sp2

I had to re-install WSUS 3.) Sp2 and Monitoring on my SBS 2003 server after it broke when I tried to upgrade WSUS fro version 3.0 Sp1 to 2.0 Sp2.

These are the steps I followed:

Steps to Re-install SBS Monitoring

1. Control Panel -> Add Remove Programs -> Windows Small Business Server 2003 -> Change Remove ->
Set Server Tools to Maintenance. Set Monitoring to Remove and continue the setup process.

2. Control Panel -> Add Remove Program -> Microsoft SQL Server Desktop Engine (SBSMonitoring) -> Remove.

3. Delete IIS Virtual Directory

Open IIS, expand servername, Web Sites, Default Web Site
Deleted Monitoring. Backed up files in the virtual directory first.

4. Renamed the C:\program files\Microsoft SQL Server\MSSQL$SBSMONITORING Folder.

5. Deleted the registry keys relating to Monitoring

A. Deleted HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SmallBusinessServer\Monitoring
B. Deleted HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\SBSMONITORING

6. Reboot the server.

7. Control Panel -> Add Remove Program -> Windows Small Business Server 2003.
Set Server Tools to Maintenance. Set Monitoring to Install and continue the setup process. I had an error message that

the system was unable to install MS SQL SP4. An error showed up on the install option.

8. 6. Rebooted the server.

9. 7. MSSQL$SBSMONITORING and SQLAgent$SBSMONITORING services started up on reboot.

10. 8. In Server Management Console -> Monitoring and Reporting: run the “Set Up Monitoring Reports and Alerts wizard”

Monitoring is now running but I have two errors relating to it in my system log file.

These are:

Event ID 120

The report server cannot decrypt the symmetric key. Most likely, the service account or password has changed. To continue, run rsconfig.exe to update the report server account information.\r\n
Event ID 140

The application domain WindowsService_5 failed to initialize. Error: Microsoft.ReportingServices.Diagnostics.Utilities.KeyStateNotValidException: The report server cannot access the private key for the service account. This key is used to decrypt the symmetric key that protects content in the report server database. This condition might occur after the password is reset for the report server service account. You must either restore a backup key or delete all encrypted content. —> System.Runtime.InteropServices.COMException (0x8009000B): Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at RSManagedCrypto.RSCrypto.ExportPublicKey() at Microsoft.ReportingServices.Diagnostics.DataProtection.PreparePublicKey(Boolean repair) at Microsoft.ReportingServices.Library.ConnectionManager.<GetEncryptionKey>b__2() — End of inner exception stack trace — at Microsoft.ReportingServices.Library.ConnectionManager.<GetEncryptionKey>b__2() at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.<>c__DisplayClass1.<Run>b__0(Object state) at System.Security.SecurityContext.Run(SecurityContext securityContext, ContextCallback callback, Object state) at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.Run(ContextBody callback) at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey() at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage() at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread(Object firstStart).

I tried using the RSKeyMgmt tool but it just could not find the instance of MS SQL server on my machine. i.e <severname>\SBSMonitoring If any one has some bright ideas, I’d be happy to hear from them.

WSUS 3.0 SP2 installed without any problems after this.




Remote desktop in XP not maximizing.

I have had this happen to me quite a few times when using a Remote Desktop connection. The RDP connection screen would go funny and then refuse to maximise again. So I decided to do a write up to save me time in the future.

The solution is really quite simple. Go to Start –> Programs –> Accessories. Launch Remote Desktop by clicking on the icon.  Then click on the Options button. You should then get the following screen come up.

http://www.bright-work.co.uk

Remote Desktop Settings

Select the Display tab and set the Remote Desktop Size to Full Screen (by moving the slider fully to the right).

If you want to have several remote desktop connections of varying sizes you can create shortcuts to the as follows:

Shortcut name:%SystemRoot%\system32\mstsc.exe /w:1600 /h:1200

Happy RDP-ing!

E-Commerce Exhibition 2010

This year’s e-commerce exhibition was run at the London Olympia on the 19th and 20th October. By all accounts of those who had attended the previous years it was busier and better than the previous year.

Bright-work-stands

Stands


Girls from the UKFast Host Stand

UKFast Girls-bright-work.co.uk

UKFast had one of the biggest stands there.

Besides the lovely girls on their stand and promoting their carbon neutral ethos, UKFast had these tips to share:

  • Since August 2010 Google has changed it search engine model and organic searches now can return upto 7 results per page for the same website rather than the one as previously. A point worthy of some thought.
  • Google’s addition of Twitter updates (which was implemented by Google autumn 2009) now means search results include relevant Twitter updates.

There were a lot of Online Payment Centre Solutions:

These were offering alternative solutions to the likes of WorldPay and RBS WorldPay.

  • RBS WorldPay

Big UK players but didn’t have anything special for existing customers.

clickandbuy http://www.bright-work.co.uk

  • In this picture above, the lovely Anapolia at the clickandbuy stand. They are a German company and say that they are the 2 largest online transaction processing company after WorldPay. Anapolia said they are different in that they can accept debit cards which are prevalent in German and through the rest of Europe.

  • EVP International – a smaller Lithuanian company offering transaction processing with a special focus on central and eastern Europe.

the US/UK market. They use a bank account to clear payments on behalf of customers.

  • CreditCall Another world wide credit card clearance company.

Google

Attended a 30 minute Google – Intoduction to Google Products Seminar.

google http://www.bright-work.co.uk

A well presented session. Gained some SEO tips regarding what Google look for when ranking your website, namely Page Relevance and Links to your site.

However Google admitted without confessing that they tweek the system as they think it right that billion dollar companies like Amazon for example should appear at the top of the organic search list for the search term – amazon.

Adwords

Google said to be very aware of seasonal trends when running your Adword campaign as this will determine what users are searching for at the time. A good example given was Stena Ferries capitalisation of the air travel disruption by the Icelandic volcanic ash cloud this year by running a tailored Adword campaign.

  • Adwords should be compelling

  • Ranking of Adwords is awarded for Relavance, Click Through Rate and the the Landing Page Quality.

My personal take – Adwords simply burns a hole in one’s pocket but there you go. Google says it’s all about market forces and how much it’s worth to you.

Display Ads – if you didn’t know, Google own Youtube

Youtube has a seriously huge audience (Google claims it’s the second largest search engine – a reflection of the society we live in today, I guess) and a company would do well to invest in producing and hosting entertaining videos. Google encourages E-commerce entrepreneurs to develop a Brand Channel.

According to Google internet use via mobile will overtake pcs by 2013.

SEO Guys – DotAgency

dotCompany http://www.bright-work.co.uk

I spoke with these guys extensively. The cool dude on the right is my friend Anthony. He uses DotAgency the for his emailing campaigns (Investment Banking Sector) and finds them cost effective at about 100 pounds a month for 25,000 managed emails. They are also doing SEO work. Speaking with them on Monday.

Rest of the Conference.

There were some interesting people doing very interesting stuff.

French companies had a strong presence.  french companies http://www.bright-work.co.ukThese two lovely girls offered said they could get us bulk purchase of digital signatures at a very competitive price.

GlobalSign:

I spoke with Steve Bolton who said they can offer use competitively priced digital signatures for two web hosting servers.

i-kos http://www.bright-work.co.uk

i-kos

Richard Jones on the left from i-kos . He is very passionate about developing e-commerce systems for companies on the Drupal platform.

There was only one company that I saw selling middle ware solutions. This was Martin Gordon-Kerr at Orion Consulting. The said they can implement a full document management solution for companies. Have Hitachi and Oki Printers on their books.

Ran into an old colleague, James McCormick – with whom I used to work with at Pitney Bowes MapInfo. He is now at Gomez. These guys do web performance stuff and more which I will look into when I get a chance.

Lunch was a garlic bread, Hot American Pizza and coke. Take away style. I also managed to squeeze in a back massage which was nice 🙂 A very worthwhile expo all in all.