Showing entries 1 to 9
Displaying posts with tag: Help Desk (reset)
How To – Configure MySQL to Use UTF-8

Background Knowledge

Using the character set UTF-8 allows for the use of any language, can represent every character in the Unicode character set and is backward compatibility with ASCII. Not to mention is can handle any platform and be sent through many different systems without corruption. With such advantages this is why so many are making the switch.

The following instructions were done on Debian Squeeze v6.04 AMD64 operating system using MySQL v14.14 Distrib 5.1.61.

Solution – Server Configuration

At present MySQL is configured by default to use “latin1″ character set. Here’s how to change MySQL configuration to use UTF-8 character set and collation.

  1. Check MySQL’s current configuration, run the following two SQL statements.

    1
    2
    
    SHOW VARIABLES LIKE '%collation%'; …
[Read more]
How To – Fix MySQL Option Without Preceding Group

Background Knowledge

You try starting, stopping or connecting to MySQL and receive the following error, “Error: Found option without preceding group in config file: /etc/mysql/conf.d/char_collation_set.cnf at line: 1″. The error message my vary but comes to the same issue. MySQL may not start or might experience connectivity issues.

This issue was experienced on Debian Squeeze v6.04 AMD64 system with MySQL v14.14 Distrib 5.1.61.

Solution

This issue is caused by a improperly formatted MySQL configuration file(s) and refers to one missing the group heading (e.g. [mysqld], [mysqld_safe], etc.).

Source: MySQL 5.1 Reference Manual :: 4.2.3.3. Using Option Files
Source: …

[Read more]
How To – Find The Version of Shockwave/Flash Player Installed

The following links load a flash file that will report what version is installed for Adobe Flash and Adobe Shockwave.

Source: Version test for Adobe Flash Player

Source: Test Adobe Shockwave & Flash Players

Windows Vista SP1 – Explorer Not Refreshing CD/DVD Drives

Background Knowledge

I have Windows Vista Ultimate with Service Pack 1 with the following optical media drives. The system is approximately one year old.

  • Manufacture: LG
  • Model: HL-DT-STDVD-ROM_GDRH20N
  • Firmware version: 0D04
  • Manufacture: LG
  • Model: HL-DT-ST DVD+-RW GSA-H73N
  • Firmware version: B103

Problem

There are two issues I’m experiencing all resulting in the fact that windows explorer is not refreshing the drive contents and/or drive volume label. Both issues occur on CD/DVD reader and CD/DVD writer drives. As well I’ve tried multiple discs from ones I’ve burnt to discs that were commercial produced and these discs all work fine on other computer systems.

  1. My Computer/Windows Explorer is not refreshing the CD/DVD drive contents.
  2. My Computer/Windows Explorer is not refreshing the CD/DVD …
[Read more]
How To – Resolve Adobe PDF Printer is Not Bound to Adobe PDF Port

Background Knowledge

I have Windows Vista with Adobe Acrobat Professional v8.1.3 installed and I was trying to covert to Adobe PDF within Microsoft Publisher 2007.

Error Message

Acrobat PDFMaker reported the following error message dialog, “Adobe PDF Printer is not bound to Adobe PDF Port. Cannot proceed further. Kindly change the PDF Port to Adobe PDF Port in Adobe PDF Printer Settings”.

Solution

  1. Go to Control Panel -> Printers.
  2. Right mouse click on “Adobe PDF” and left click on “Properties”.
  3. Left mouse click on “Ports” tab.
  4. Uncheck mark the current port that is presently check marked. Place a checkmark on either “Desktop\*.pdf” or “Documents\*.pdf”. Ensure the description is “Adobe PDF Port”.
  5. Left …
[Read more]
Apache Warning - MySQL Lib Size Mismatch Solution

I was having some problems with my web site so I went off to check my Apache HTTPD error_log and found three warning messages logged.

Apache HTTPD error_log
/usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(client_errors) size mismatch, relink your program
/usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(default_directories) size mismatch, relink your program
/usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(globerrs) size mismatch, relink your program

After some time of research and with no solution, I decided to mention the problem in Midgard IRC channel. With Piotras

[Read more]
Apache Warning - MySQL Lib Size Mismatch Solution

I was having some problems with my web site so I went off to check my Apache HTTPD error_log and found three warning messages logged.

Apache HTTPD error_log
/usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(client_errors) size mismatch, relink your program
/usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(default_directories) size mismatch, relink your program
/usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(globerrs) size mismatch, relink your program

After some time of research and with no solution, I decided to mention the problem in Midgard IRC channel. With Piotras

[Read more]
PEAR: Command Not Found

I recently installed PHP 4.3.11 from source (due to configuration requirements) on to an OpenBSD i386 v3.7 server. The installation went perfectly as it has many times before, however I found out that the PEAR script was not installed (normally in /usr/local/bin). I discovered this when trying to install some pear packages doing “pear install packagename”. I get a returned error of “-bash: pear: command not found”. I tried locating the PEAR script using “find / -name pear” and “/usr/libexec/locate.updatedb” then “locate -i pear”. The result came up empty with no PEAR script in the returned results. I double checked the PEAR documents, PHP documents and ./configure all three places stated PEAR is installed by default unless a parameter is provided at configure with –without-pear. I’m still not aware as to why the PEAR script was not installed however with help by …

[Read more]
PEAR: Command Not Found

I recently installed PHP 4.3.11 from source (due to configuration requirements) on to an OpenBSD i386 v3.7 server. The installation went perfectly as it has many times before, however I found out that the PEAR script was not installed (normally in /usr/local/bin). I discovered this when trying to install some pear packages doing “pear install packagename”. I get a returned error of “-bash: pear: command not found”. I tried locating the PEAR script using “find / -name pear” and “/usr/libexec/locate.updatedb” then “locate -i pear”. The result came up empty with no PEAR script in the returned results. I double checked the PEAR documents, PHP documents and ./configure all three places stated PEAR is installed by default unless a parameter is provided at configure with –without-pear. I’m still not aware as to why the PEAR script was not installed however with help by …

[Read more]
Showing entries 1 to 9