mrkeck Sharing the Love

11Sep/120

phpMyAdmin Change CSV Field Termination

To change phpmyadmin default import/export option settings find "config.inc.php" or "config.default.php" under the phpmyadmin folder and change this line

$cfg['Import']['csv_terminated'] = ',';

If it is not there add it.

Filed under: mySQL, phpMyAdmin, wamp No Comments
14Jul/120

SSL on Wamp Server (Self-Signed and Godaddy)

Self-Signed:

It took some doing but got it going thanks to this tutorial...
SSL on Wamp

Godaddy SSL:

Change the httpd-ssl.conf and setup folders as described in the Self-Signed section, then
Request for Certificate
Install Certificate

Example

In cmd:
cd\ (or where ever you want the files to go)
(the next command is all one long command)
C:\wamp\bin\apache\apache2.2.22\bin\openssl req -config "C:\wamp\bin\apache\apache2.2.22\conf\openssl.cnf" -new -newkey rsa:2048 -nodes -keyout mydomain.key -out mydomain.csr

Note: If you don't use the -config you will get an error saying "Unable to load config info from /usr/local/ssl/openssl.cnf"

Files will go to your current folder in cmd(in this case C:\).
Copy the key into the C:\wamp\OpenSSL\certs
copy the PEM into the C:\wamp\OpenSSL\private
Submit the csr and get certificate from your certifcate provider (Godaddy)
Once downloaded, place your crt and bundle in C:\wamp\OpenSSL\cert
Restart WAMP

Filed under: Godaddy, wamp, web No Comments
27Jun/120

htaccess rewrite not working

In apache httpd.conf file

Uncomment out the following line:
LoadModule rewrite_module modules/mod_rewrite.so

Filed under: wamp, web No Comments
28Dec/110

mySQL ODBC Error

"The specified DSN contains an architecture mismatch between the Driver and Application"

I'm using WAMP on 64-bit Windows 7. Turns out when you go to ODBC connections through control panel that brings up the 64-bit connections. I had to go to c:\windows\sysWOW64\odbcad32.exe to setup the connection for 32-bit on a 64-bit OS.
Works great!

http://msdn.microsoft.com/en-us/library/windows/desktop/ms712362(v=vs.85).aspx

To manage a data source that connects to a 32-bit driver under 64-bit platform, use c:\windows\sysWOW64\odbcad32.exe. To manage a data source that connects to a 64-bit driver, use c:\windows\system32\odbcad32.exe. In Administrative Tools on a 64-bit Windows 8 operating system, there are icons for both the 32-bit and 64-bit ODBC Data Source Administrator dialog box.

Filed under: msaccess, mySQL, PDO, wamp No Comments
14Jun/110

MySQL Remote Computer Wampserver

For error "Connection failed: [hy000] [mysql] [odbc driver 5.1]"

Add a user in phpmyadmin to be accessed by any host.  Grant access accordingly.

Add an exception in Windows Firewall for port 3306 (default MySQL port)

 

Filed under: mySQL, wamp No Comments
26May/110

htaccess in WAMPServer

In the htaccess, I have "<IfModule mod_deflate.c>" so I just need to make sure mod_deflate.c is Loaded in the httpd.conf that Apache is using. Once I uncommented all the Loads that I needed my htaccess worked great!

Side note: I am using the htaccess from HTML 5 Broilerplate

Filed under: HTML, PHP, wamp, web No Comments