Tag Archives: connection

Picking a 16-channel external power connection

Posted on by
Reply

So I’m planning to put an Xbox power supply,

in a box,

I wasn’t sure exactly which box, so I got four, hoping one would work.
The sockets and pinouts vary,

So I will need to make three different types of cables, one for each version range: v1.0-v1.1, v1.2-v1.5, v1.6. But those vary only on the “motherboard side”, the connector that connects to a power supply in a box can be anything, and I can pick it. By my count the maximum cable requirement is 16 cables. So I’m looking for a recommendation for what power connector to install the on the box. Ideally something I can bolt into the box that can handle a couple of amps of DC and into which I can plug my custom cable. Craig? :)
Update: from here maximum observed current 8.6A. I would like to use D Sub Connector Housing, 25 Ways, D Sub, 3, AMPLIMITE HDP-20, Receptacle, Steel Body but I’m not sure if they’re rated high enough for the current.

PDO Persistent Connection in PHP left broken if connected to dropped database

Posted on by
Reply

So you use PDO and specify PDO::ATTR_PERSISTENT => true. Then you drop your database. Then you open a new persistent connection and bang! Not working. The trick is to not use persistent connections to databases that may be dropped. And probably an ‘apache2ctl graceful’ after you drop a database being used by Apache…

MySQL SSL connections not working with phpMyAdmin and mysqli

Posted on by
44

I had a problem with phpMyAdmin not using encrypted connections.

My server was correctly configured for SSL as indicated by:

SHOW VARIABLES LIKE '%ssl%'

Which returned:

Variable_name Value
have_openssl YES
have_ssl YES
ssl_ca /etc/mysql/cacert.pem
ssl_capath
ssl_cert /etc/mysql/server-cert.pem
ssl_cipher
ssl_key /etc/mysql/server-key.pem

However when I ran:

SHOW STATUS LIKE 'Ssl_cipher'

I got back a null result, indicating that the connection was not encrypted.

Eventually I figured out that the problem was caused by using the ‘mysqli’ provider for my connections in phpMyAdmin. When I switched my connections to use ‘mysql’ instead then encryption started working and an Ssl_cipher was reported.

I’d love to know what the actual problem is, but for now I’m just happy that my connections are actually encrypted. I spent a while hacking on the mysqli dbi interface to try and get it to play nice with SSL but I didn’t make any progress.