I am one of the main developers to a browser based game and I am currently setting up an Auth server to store all the users account information,
this uses OpenSSL with RSA key pairs to talk to and from our Auth Server to Game Servers so that we only pass hash to the game servers which is then used to requiest the required user infomation, so we have secure communication between the two servers.
The issue that I am having is I am trying to store the RSA Key Certifcates into the database but when I insert all the information via the insert GUI its displays the following:
"You don't have permission to access /URLPATH/tbl_replace.php on this server."
This also happens if I try it with the root login which has full access (MySQL and Appache) so its not an access issue.
However it works fine if I add the following into the SQL GUI:
INSERT INTO `servers2` (`id`, `game`, `url`, `hash_id`, `caption`, `description`, `status`, `type`, `last_reset`, `next_reset`, `duration`, `iduration`, `cert`, `cert_pw`) VALUES
(NULL, 'gamename', 'gameurl', 'gamehash', 'gametitle', 'gamedesc', 'disabled', 'invite', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'gameduration', 0, '-----BEGIN CERTIFICATE-----\nKEYINFO_REMOVED\n-----END CERTIFICATE-----\n', '');
Also once its all inserted fine I can no longer edit that row via the GUI, however I can edit it if I use the SQL GUI and enter SQL to change the required data.
Not too sure, but I think it may be down to the '-----BEGIN CERTIFICATE-----' and the '-----END CERTIFICATE-----' that is wrapped around the Certificate data.
I can strip those lines and base64_decode the data and then store that as binary data thats works fine, but I shouldn't need to do all that, I should be able to strore it as text with the wrappers.
So is there any chance in this being fixed because I am ATM entering them in by hand while I am working on my Admin page.
Let me know if you require any more information.
Thanks in advance Paul