Having problems with Blowfish encryption!
We have several cases where several different servers are accessing the same MySql database.
Problem is that Blowfish works fine for each server by itself, but the encrypted strings differ from one server to another (although the code is identical).
Inspection running the same code on 2 servers with diagnostics make me suspect the code:
$Xl = ((($this->S[0][($temp>>24) & 255] +
$this->S[1][($temp>>16) & 255]) ^
$this->S[2][($temp>>8) & 255]) +
$this->S[3][$temp & 255]) ^ $Xr;
which is reentered repeatedly and produces different results on about the 2000th iteration.
I suspect the problem is to do with different hardware representation of numbers.
I could use MySql encryption, but that means data is sent unencrypted from database to server.
Any suggestions on encryption which does not hit this problem?
Malcolm
