Changes between Version 1 and Version 2 of support-team/mysql-mysqli-conversion

Timestamp:

Apr 17, 2014, 1:07:11 AM (12 years ago)

Author:

Ross

Comment:

--

support-team/mysql-mysqli-conversion

@@ -8 +8 @@
 
 === mysql_connect ===
+mysql_connect takes only the parameters (host, user, password) and returns the connection resource.
+==== mysqli_connect ===
+For this function requires a few more parameters.  Our currently functional implementation looks like this:
+{{{
+$flags = 0;
+$flags = MYSQL_CLIENT_SSL;
+$sql = mysqli_init();
+if (!($sql->options(MYSQLI_READ_DEFAULT_FILE, '/root/horror/my.cnf')))
+  printf("failed to set the default file (MYSQLI_READ_DEFAULT_FILE: %d)\n", MYSQLI_READ_DEFAULT_FILE);
+if (!($sql->options(MYSQLI_READ_DEFAULT_GROUP, 'red')))
+  printf("failed to set the group for the default file (MYSQLI_READ_DEFAULT_GROUP: %d)\n", MYSQLI_READ_DEFAULT_GROUP);
+if (!($sql->real_connect($db_host,$db_user,$db_pass, $db_name))) {
+  printf("failed to really connect\n");
+}
+}}}
+===== Notable changes =====
+ * $flags = MYSQL_CLIENT_SSL;
+  * This flag ensures the client is connection via ssl.
+ * $sql->options(MYSQLI_READ_DEFAULT_FILE, '/root/horror/my.cnf')
+  * Here we add a new set of options in a custom my.cnf file, probably stored in /user/local/etc/red/my.cnf.  The configured options are:
+{{{
+[red]
+ssl=true
+ssl-ca=/etc/mysql/red-cert.pem
+ssl-verify-server-cert=true
+}}}
+   * where `red-cert.pem` is the mysql ca certificate, which will need to be stored on all MOSHes and on hay.
+ * $sql->options(MYSQLI_READ_DEFAULT_GROUP, 'red')
+  * This simply says, "Read from the my.cnf group `red`.
+ * $sql->real_connect($db_host,$db_user,$db_pass, $db_name)
+  * This makes the mysql connection.
 === mysql_data_seek ===
 === mysql_error ===