Tip Mysql : Cannot delete or update a parent row: a foreign key constraint fails

Code

For those of you who are faced to this type of error, the command “SHOW ENGINE INNODB STATUS;” is your friend.

[...]
------------------------
LATEST FOREIGN KEY ERROR
------------------------
130322 12:03:42  Cannot drop table `test`.`events`
because it is referenced by `test`.`attachments`
[...]

Here it is my 2 cents of the day ;)

Sting concert in Rouen

Non-Classe

For the first time of  life I have seen Sting in concert and it was in rouen : my city. It was great ! It was really great ! Thank you Sting for this awful moment ! This concert will remain etched in my memory. Ok I’m a fan!

THANK YOU !

MPLS RD, RT, label : where is the truth ?!

Non-Classe, Telecom

I was reading all my RSS feeds and I am subscribed to http://mellowd.co.uk/ccie/ . I have noticed this post for you : http://mellowd.co.uk/ccie/?p=2923 It talks about RD, RT and label about MPLS. I found this post really clear about this terms and concepts.

To sum-up :

  • RD = marks routes with an ‘id’. This ‘id’ is composed by two terms (IP_ASN:number)
    • IP_ASN : IP address or ASN
    • Number : which identify the VPN

I recommand to use IP in IP_ASN. I understand it is really easy to read : 3215:100 and not 81.252.160.88:100. The last one is less easy, but when you deploy a large MPLS cloud and you must supply some load-balancing or fail-over on different PE, the RR(Route Reflector) will choice the best route in the two : 3215:100:192.168.1.0 which is received). With IP1:100:192.168.1.0 and IP2:100:192.168.1.0 the two routes will be used, so you will be able to load balance trafic over two links.

NetBSD-6.0 is on the way...

Bsd

As said riz@ :

NetSBD 6.0 is currently being copied to ftp.netbsd.org.  Sometime in
the next 24h it will be made world-readable so mirrors can
begin the process of copying it.

It will be announced sometime on Wednesday.

Thanks!
+j

Ready to test it and upgrade/install servers…

Linux : Remote desktop && Hamachi

Linux, Non-Classe, Telecom

For those of you which need to access by means of “Remote Desktop” you can use :

  • Nomachine NX
  • Teamviewer
  • VNC

And you can use both LogmeIn Hamachi and VNC. Hamachi is a software which can make network betweeen devices. Against logmein product which lot of you know, here it is at Level2 (OSI).

 

How you create your VPN ?

For Linux users, you must install vnc4server and hamachi (supplied by LogmeIn) package (dpkg is your friend). Then you launch your vnc server :

IPSec and packet loss

Cisco, Telecom

For those of you which configuring IPSec and have packet loss in transit… Perhaps this configuration could help :

crypto ipsec client ezvpn REGISBTP
 connect auto
 group VPN-CLIENT2 key jsdfxkqwpoe
 local-address FastEthernet0
 mode network-extension
 peer 22.22.22.22
 username ipsec1@client2.vpn password jsdfxkqwpoe
 xauth userid mode local

interface FastEthernet0
 ip address 192.168.1.36 255.255.255.0
 ip mtu 1460
 no ip route-cache cef
 ip tcp adjust-mss 1420
 duplex auto
 speed auto
 crypto ipsec client ezvpn CLIENT2
!         

interface Vlan1
 ip address 10.20.0.1 255.255.255.0
 ip mtu 1460
 ip virtual-reassembly
 ip tcp adjust-mss 1420
 crypto ipsec client ezvpn CLIENT2 inside
!         
ip forward-protocol nd
ip route 0.0.0.0 0.0.0.0 192.168.1.254

The really interesting command (which resolves packet loss) is :