a day in the life of wayne ward….

[HOWTO] Grant and Revoke Remote root Access to MySQL

To grant root access from all hosts (except for localhost):

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'topsecret';

To revoke root access from all hosts (except for localhost):

DELETE FROM mysql.user WHERE User = 'root' AND Host = '%';
FLUSH PRIVILEGES;

To enable MySQL service to accept connections from all hosts change the following line in file mysql.conf:bind-address=127.0.0.1tobind-address=0.0.0.0or better just comment out:#bind-address=127.0.0.1and restart the MySQL service.

Notes:*) The percent symbol ("%") in the notation root@"%" means “any host”, but it doesn’t imply localhost. You need to repeat the commands above with root@localhost in order to grant/revoke permissions for localhost.

Was quite shocked that something so widely used and as mature as photoshop not to have facility for bullet points on text editing! Had to google it and on the mac you press command and the number 8 and get some ball bullet point which does the trick I suppose !! Adobe add some cool bullet points I don’t wanna make my own!!

Im sorry for the few people who were messed around over xmas with URLS. Ive closed GBN as i could not get control of the domains. I need the domain all together professionally not scattered around the globe for reasons of future investments and expanding business. Im afraid this had obstacles and had to move away from the domains and name. I bought new domains – renewed all the licences to the new domain and rebuilt the whole system. The good thing is the whole system only has one bug as it stands after a full rebuild which is getting looked at no rush as it something minor.

The site main features include

• Social networking
• Chat
• Photos
• Groups
• Music Uploads
• Events
• Vidoes
• Classifieds
• Facebook / Twitter Intergration
• Last.fm / Soundcloud Intergration
• Mobile Phone Client

Im just re-registering the reviews module and will be integrating today, I’ve never wrote any reviews but will try some this week I have plenty of new musical instruments and gadgets to review plus computer software reviews! So ill give it a damn good go.

Im expecting a iPad client this month and looking at adding some custom fields and upgrading the search system. Im also brainstorming a link sharing system were users can submit there own links that they think may be useful, as i have loads and sometimes forget to book mark them! So think this could be a great feature…. Its all about sharing

Im looking for advertisers so please get in touch we can look at getting you some free advertising for your business for the first year! If you can supply us with a banner and a URL.

You can sign up and join for free and also follow us on – twitter – Facebook and our blog which is being added this week….

http://www.globalmusiciannetwork.com

http://www.facebook.com/pages/Global-Musician-Network/221563824589183

http://twitter.com/themusiciannet

We wish you all the best for the new year and thank you for reading – Sign up today – Connect with musicians globally….

We are available on .co.uk .net & .com and also support is enabled on them domains. The real deal!!!

Recently sold my iMac as it was sat in the back not getting used a lot – it was our media server for movies using plea and iTunes to share music – to laptops and out ATV in the front room. Ive replaced it with a dual screen ubuntu studio box from bits i had kicking around – a old shuttle i built ten years ago – runs perfect!!!! Any how i thought the idea of a NAS was the way forward just to keep all our files in one central location. So i took a look for a unit that was multi platform as i don’t buy anything that isn’t really as i use all platforms apart from windows but i need access from windows computers from the virus repaired machines i take in!!

Plugged in the nas fired the CD in my mac the assistant found the NAS and fired in the 3.1 DSM as the older versions is on the CD. I logged on to the NAS through the IP address gave to me through a browser and updated the DSM to 3.2 straight away though the browser it did it all really easily! proceeded to give it a fixed IP address and format the two drives. A hour later i created the users and gave them the permissions required and enabled the services i required – photo sharing – video sharing – and I added one of my YCAMS with one of the free licences provided to test. I moved across some pictures to the pictures directory and and videos to my videos directory and some albums to the music directory all through networking that popped up on my mac!! I then added the movie location to my XBMC on my ATV and streamed my first movie which was perfect! I added the music location in XBMC which was ok just a bit slow and the standard ATV desnt see the iTunes share like it did on the mac using home sharing which was a pain – so now i use the synology music app on the iPhone and simply airplay it direct to the ATV – simples

I moved about 8 gig of pictures in which took the NAS about 3 days to generate all the thumbnails!! but now its done its fine as ill only be adding small amounts at one time. I tried to get the NAS to do a auto configure on my router for automatic port forwards but my router draytek 2830 so did this manually which is kind or working… I added my HP F380 no problem and shared it on the network by plugging it in to the external UBB port – works a treat its always available.

Ive setup my iPhone / iPad and android devices using the free apps available which work a treat! and payed 2.50 for the bittorent front end which I’ve got on a schedule that kicks in 2am to 9pm so it doesn’t download when I’m working! all the apps work great!! Ive ordered a UPS for power outages when that arrives ill blog to let you know how that went as I had to search for a compatibility list for the UP’s so it automatically shuts it down in a long power outage…..

The surveillance software works pretty damn well and adding the cameras was a breeze it asked me how much room i wanted to use for the cameras and i have full schedule and can select from motion detection to full time recording. It came with one licence and i managed  to get a additional licence for £35 which was worth it – I can go back a month if not more on each camera at specific times and dates. Works great on the iPad.

Last but not least i enabled airplay on my printer but my iPhone and iPad send the job but don’t print which is a pain – I enabled webdav and told onmi focus to use the webdav for its database so I have it shared and that didn’t work either. Im going to test time machine this week.

My verdict – 9/10 couple of things not as a like but the administration and the mobile apps are 100% great!!! invest in one

Ive been setting up a vpn for a client and wanted to do some testing on my mac so poked around at mac osx vpn gui and found a handful – tested them all and basically only got vpn tracker to work easy – i probably could get the others to work with some hacking around but i like things to be easy nowadays! anyway vpn tracker is like a hundred quid for one licence which is expensive. Im sat there thinking macs are to cool and must have this buit in so i googled to connect to a draytek 2820 from mac osx and yes it was under my nose – changed a few settings on the router and added a new vpn which was easy following some easy instructions – see below 
Once i made the vpn I had enabled remote desktops on the server so used the mac os remote desktop gui RDC 2.01 and put in the ip of the server i want to have remote desktop to and viola it works i get full access – also in the preferences you can share local printers and folders to the remote machine which works great!
a mac – a vpn – remote desktop and your away!! awsome – check this howto

Setting up VPN, consists of 2 main operations – configuring the router to accept VPN connections, and setting the computer up to connect via VPN.

Setting up the Draytek router
In the new page that opens, configure the IPSec Setup as follows:
IKE Authentication Method
IPSec Security Method

In the “VPN & Remote Access” tab in the left menu, select “Remote Dial-in User”.Select an index position from the list of users, by clicking on a number (1 for example)
In the new user page that opens, configure the user as follows:
User Account & Authentication
Allowed Dial-in Type
Username & Password

Setting up a PPTP VPN connection in OSX
At this point, you should see the VPN icon appear in the menu bar. If all has gone according to plan, it will begin with “Connecting” being displayed, followed by “Authenticating”, and then should start a timer, indicating the duration that the VPN connection has been up.

“macs kick ass”

I must admit its nice to get comments on my blog posts and trackbacks

but I’m getting spammed so I’ve disabled them sorry but sick of emails every day for them for no reason!!

TA TA !!

quick fox for licence problems with mac osx – i just remove the licence and test from then on…

try again – no need to change the machine name like the dreaded windows

HOW TO RESET WINDOWS TERMINAL SERVICES 3 MONTH TRIAL

Make sure you’ve installed “Terminal Services Licensing”. By the way, this method only makes sense if you need to use Terminal Services in Application Mode, which is the one that requires licensing.

The idea is quite simple.

First, disconnect all users from the terminal. If you need to do this remotely, you can also disconnect yourself, and access the files remotely.

Go to %WINDIR%\system32\lserver

Notice the file TSLIC.edb. Rename it to tslic.old

In every client computer, remove the CAL TS registry keys, located at:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSLicensing

Restart your server.

Or change laptop /computer name

In every client computer, remove the CAL TS registry keys, located at:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSLicensing

Restart machine

When double clicking on remote desktop software for 1st time

Right click on remote desktop and run as administrator

im watchin you

here is my new gallery 3 set up ill be posting all my public albums to it

Costa Web Solution – Multilingual and Multi Platform Web Service provider in spain and england. Offering a range of web services from content management systems, blogs, real estate applications, automotive applications, content management systems, customer relationship management systems and optimisation. A great range of hosting services and great  packages available.

Visit the site here http://costawebsolutions.es/

Or join the Facebook group here. Or join twitter here.