Signature Web Media http://signaturewebmedia.com/blog Signature Web Media Staff's Ordinary Blog (more like a technical memos) Tue, 18 Feb 2014 15:33:04 +0000 en-US hourly 1 https://wordpress.org/?v=6.2.9 MySQL Order By date type issue http://signaturewebmedia.com/blog/178/mysql-order-by-date-type-issue/?utm_source=rss&utm_medium=rss&utm_campaign=mysql-order-by-date-type-issue http://signaturewebmedia.com/blog/178/mysql-order-by-date-type-issue/#respond Tue, 18 Feb 2014 15:33:04 +0000 http://signaturewebmedia.com/blog/?p=178 This must be the “gotcha” type of stuff when you think just using the “ORDER BY <date type>” clause would give you back the correct results in MySQL.
My original table structure and its data:
mysql> describe holidays;
+-----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+----------------+
| holidayId | int(11) | NO | PRI | NULL | auto_increment |
| holidayName | varchar(255) | NO | | NULL | |
| holidayDate | date | NO | | NULL | |
| holidayDuration | int(11) | NO | | NULL | |
+-----------------+--------------+------+-----+---------+----------------+
mysql> select holidayId, holidayName, holidayDate from holidays;
+-----------+-------------------+-------------+
| holidayId | holidayName | holidayDate |
+-----------+-------------------+-------------+
| 1 | Memorial Day | 2014-05-26 |
| 2 | Independence Day | 2014-07-04 |
| 3 | Labor Day | 2014-09-01 |
| 4 | Thanks Giving Day | 2014-11-27 |
| 5 | Christmas Day | 2014-12-25 |
| 6 | New Year's Day | 2015-01-01 |
+-----------+-------------------+-------------+
Then I’d query the table with the ORDER BY clause with some DATE_FORMAT():
mysql> SELECT holidayId, holidayName, date_format(holidayDate,'%m/%d/%Y') holidayDate
-> FROM holidays
-> ORDER BY holidayDate;
+-----------+-------------------+-------------+
| holidayId | holidayName | holidayDate |
+-----------+-------------------+-------------+
| 6 | New Year's Day | 01/01/2015 |
| 1 | Memorial Day | 05/26/2014 |
| 2 | Independence Day | 07/04/2014 |
| 3 | Labor Day | 09/01/2014 |
| 4 | Thanks Giving Day | 11/27/2014 |
| 5 | Christmas Day | 12/25/2014 |
+-----------+-------------------+-------------+
As you can see, the New Year’s Day for 2015 is at top. It seems like the records were sorted based on the numbers and not by the chronological orders.
According to the manual (http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format), the DATE_FORMAT() would return “a string.”
Thus, the correct way to sort the date type column is to sort by the original column name. In our case, the original column name was aliased/renamed as “holidayDate.” If we did not alias this, it would have been:
mysql> SELECT date_format(holidayDate,'%m/%d/%Y')
-> FROM holidays;
+-------------------------------------+
| date_format(holidayDate,'%m/%d/%Y') |
+-------------------------------------+
| 05/26/2014 |
| 07/04/2014 |
| 09/01/2014 |
| 11/27/2014 |
| 12/25/2014 |
| 01/01/2015 |
+-------------------------------------+
===> it became "date_format(holidayDate,'%m/%d/%Y')"
Thus my workaround is (I want to use alias!):
mysql> SELECT holidayId, holidayName, date_format(holidayDate,'%m/%d/%Y') 'Holiday Date'
-> FROM holidays
-> ORDER BY holidayDate;
+-----------+-------------------+--------------+
| holidayId | holidayName | Holiday Date |
+-----------+-------------------+--------------+
| 1 | Memorial Day | 05/26/2014 |
| 2 | Independence Day | 07/04/2014 |
| 3 | Labor Day | 09/01/2014 |
| 4 | Thanks Giving Day | 11/27/2014 |
| 5 | Christmas Day | 12/25/2014 |
| 6 | New Year's Day | 01/01/2015 |
+-----------+-------------------+--------------+

The post MySQL Order By date type issue first appeared on Signature Web Media.]]> This must be the “gotcha” type of stuff when you think just using the “ORDER BY <date type>” clause would give you back the correct results in MySQL.

My original table structure and its data:

mysql> describe holidays;
+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| holidayId       | int(11)      | NO   | PRI | NULL    | auto_increment |
| holidayName     | varchar(255) | NO   |     | NULL    |                |
| holidayDate     | date         | NO   |     | NULL    |                |
| holidayDuration | int(11)      | NO   |     | NULL    |                |
+-----------------+--------------+------+-----+---------+----------------+
mysql> select holidayId, holidayName, holidayDate from holidays;
+-----------+-------------------+-------------+
| holidayId | holidayName       | holidayDate |
+-----------+-------------------+-------------+
| 1         | Memorial Day      | 2014-05-26  |
| 2         | Independence Day  | 2014-07-04  |
| 3         | Labor Day         | 2014-09-01  |
| 4         | Thanks Giving Day | 2014-11-27  |
| 5         | Christmas Day     | 2014-12-25  |
| 6         | New Year's Day    | 2015-01-01  |
+-----------+-------------------+-------------+

Then I’d query the table with the ORDER BY clause with some DATE_FORMAT(): 

mysql> SELECT holidayId, holidayName, date_format(holidayDate,'%m/%d/%Y') holidayDate
 -> FROM holidays
 -> ORDER BY holidayDate;
+-----------+-------------------+-------------+
| holidayId | holidayName       | holidayDate |
+-----------+-------------------+-------------+
| 6         | New Year's Day    | 01/01/2015  |
| 1         | Memorial Day      | 05/26/2014  |
| 2         | Independence Day  | 07/04/2014  |
| 3         | Labor Day         | 09/01/2014  |
| 4         | Thanks Giving Day | 11/27/2014  |
| 5         | Christmas Day     | 12/25/2014  |
+-----------+-------------------+-------------+

As you can see, the New Year’s Day for 2015 is at top. It seems like the records were sorted based on the numbers and not by the chronological orders.

According to the manual (http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format), the DATE_FORMAT() would return “a string.”

Thus, the correct way to sort the date type column is to sort by the original column name. In our case, the original column name was aliased/renamed as “holidayDate.” If we did not alias this, it would have been:

mysql> SELECT date_format(holidayDate,'%m/%d/%Y')
 -> FROM holidays;
+-------------------------------------+
| date_format(holidayDate,'%m/%d/%Y') |
+-------------------------------------+
| 05/26/2014                          |
| 07/04/2014                          |
| 09/01/2014                          |
| 11/27/2014                          |
| 12/25/2014                          |
| 01/01/2015                          |
+-------------------------------------+
===> it became "date_format(holidayDate,'%m/%d/%Y')"

Thus my workaround is (I want to use alias!):

mysql> SELECT holidayId, holidayName, date_format(holidayDate,'%m/%d/%Y') 'Holiday Date'
 -> FROM holidays
 -> ORDER BY holidayDate;
+-----------+-------------------+--------------+
| holidayId | holidayName       | Holiday Date |
+-----------+-------------------+--------------+
|         1 | Memorial Day      | 05/26/2014   |
|         2 | Independence Day  | 07/04/2014   |
|         3 | Labor Day         | 09/01/2014   |
|         4 | Thanks Giving Day | 11/27/2014   |
|         5 | Christmas Day     | 12/25/2014   |
|         6 | New Year's Day    | 01/01/2015   |
+-----------+-------------------+--------------+
The post MySQL Order By date type issue first appeared on Signature Web Media.]]> http://signaturewebmedia.com/blog/178/mysql-order-by-date-type-issue/feed/ 0 HP 10BII financial calculator – comma and decimal point swap http://signaturewebmedia.com/blog/174/hp-10bii-financial-calculator-comma-and-decimal-point-swap/?utm_source=rss&utm_medium=rss&utm_campaign=hp-10bii-financial-calculator-comma-and-decimal-point-swap http://signaturewebmedia.com/blog/174/hp-10bii-financial-calculator-comma-and-decimal-point-swap/#respond Sun, 09 Feb 2014 17:54:26 +0000 http://signaturewebmedia.com/blog/?p=174 This is really funny – one day, I realized that my HP© 10BII financial calculator is displaying a comma instead of a decimal point and displaying a decimal point for a comma…
Very confusing…
The fix is to press “shift”(brown key on the left) and “.” (the decimal point).
The calculator’s user manual is downloadable from the manufacturer’s site: direct link to the manual

The post HP 10BII financial calculator – comma and decimal point swap first appeared on Signature Web Media.]]> This is really funny – one day, I realized that my HP© 10BII financial calculator is displaying a comma instead of a decimal point and displaying a decimal point for a comma…

Very confusing…

The fix is to press “shift”(brown key on the left) and “.” (the decimal point).

The calculator’s user manual is downloadable from the manufacturer’s site: direct link to the manual

The post HP 10BII financial calculator – comma and decimal point swap first appeared on Signature Web Media.]]> http://signaturewebmedia.com/blog/174/hp-10bii-financial-calculator-comma-and-decimal-point-swap/feed/ 0 /usr/bin/convert.exe: error while loading shared libraries: ?: cannot open shared object file: No such file or directory http://signaturewebmedia.com/blog/169/usrbinconvert-exe-error-while-loading-shared-libraries-cannot-open-shared-object-file-no-such-file-or-directory/?utm_source=rss&utm_medium=rss&utm_campaign=usrbinconvert-exe-error-while-loading-shared-libraries-cannot-open-shared-object-file-no-such-file-or-directory http://signaturewebmedia.com/blog/169/usrbinconvert-exe-error-while-loading-shared-libraries-cannot-open-shared-object-file-no-such-file-or-directory/#respond Thu, 11 Jul 2013 15:33:57 +0000 http://signaturewebmedia.com/blog/?p=169 I was trying to use the ImageMagick in cygwin to create a jpeg file; however, the execution ended up with the error:
$ convert -size 94×54 xc:white lh.jpg
/usr/bin/convert.exe: error while loading shared libraries: ?: cannot open shared object file: No such file or directory
 It seems like some DLL file(s) were missing. To figure that out,
$ cygcheck convert
Found: .\convert.exe
Found: C:\cygwin\bin\convert.exe
Found: C:\cygwin\bin\convert.exe
Found: C:\WINDOWS\system32\convert.exe
Found: C:\cygwin\bin\convert.exe
.\convert.exe
.\cygMagickCore-5.dll
.\cyggcc_s-1.dll
.\cygwin1.dll
C:\WINDOWS\system32\KERNEL32.dll
C:\WINDOWS\system32\ntdll.dll
.\cyggomp-1.dll
.\cygautotrace-3.dll
.\cygming-1.dll
.\cygfreetype-6.dll
.\cygbz2-1.dll
.\cygz.dll
.\cyggif-4.dll
.\cygX11-6.dll
.\cygxcb-1.dll
.\cygXau-6.dll
.\cygXdmcp-6.dll
.\cygpng15-15.dll
.\cygpstoedit-0.dll
.\cygstdc++-6.dll
.\cyggd-2.dll
.\cygfontconfig-1.dll
.\cygexpat-1.dll
.\cygjpeg-8.dll
.\cygXpm-4.dll
.\cygcairo-2.dll
.\cygpixman-1-0.dll
.\cygxcb-render-0.dll
.\cygxcb-shm-0.dll
.\cygXext-6.dll
.\cygXrender-1.dll
.\cygfftw3-3.dll
.\cygfpx-1.dll
.\cygglib-2.0-0.dll
.\cygiconv-2.dll
.\cygintl-8.dll
.\cygpcre-1.dll
.\cyggobject-2.0-0.dll
.\cygffi-6.dll
.\cyggs-9.dll
.\cygidn-11.dll
.\cyglcms2-2.dll
.\cygpaper-1.dll
.\cygtiff-5.dll
.\cygjbig-2.dll
.\cygXt-6.dll
.\cygICE-6.dll
.\cygSM-6.dll
.\cyguuid-1.dll
.\cygjasper-1.dll
.\cygltdl-7.dll
.\cyglzma-5.dll
.\cygpango-1.0-0.dll
.\cyggmodule-2.0-0.dll
.\cygthai-0.dll
.\cygdatrie-1.dll
.\cygpangocairo-1.0-0.dll
.\cygpangoft2-1.0-0.dll
.\cygharfbuzz-0.dll
.\cyggraphite2-3.dll
.\cygicule48.dll
.\cygicuuc48.dll
.\cygicudata48.dll
.\cygrsvg-2-2.dll
.\cygcroco-0.6-3.dll
.\cygxml2-2.dll
.\cyggdk_pixbuf-2.0-0.dll
.\cyggio-2.0-0.dll
C:\WINDOWS\system32\ADVAPI32.DLL
C:\WINDOWS\system32\RPCRT4.dll
C:\WINDOWS\system32\Secur32.dll
C:\WINDOWS\system32\GDI32.dll
C:\WINDOWS\system32\USER32.dll
.\cygMagickWand-5.dll
cygcheck: track_down: could not find cygpng14-14.dll
 
Installing “linpng: PNG library (docs and demos)” solved the issue. (I had to reboot the machine.)

The post /usr/bin/convert.exe: error while loading shared libraries: ?: cannot open shared object file: No such file or directory first appeared on Signature Web Media.]]> I was trying to use the ImageMagick in cygwin to create a jpeg file; however, the execution ended up with the error:

$ convert -size 94×54 xc:white lh.jpg
/usr/bin/convert.exe: error while loading shared libraries: ?: cannot open shared object file: No such file or directory

 It seems like some DLL file(s) were missing. To figure that out,

$ cygcheck convert
Found: .\convert.exe
Found: C:\cygwin\bin\convert.exe
Found: C:\cygwin\bin\convert.exe
Found: C:\WINDOWS\system32\convert.exe
Found: C:\cygwin\bin\convert.exe
.\convert.exe
.\cygMagickCore-5.dll
.\cyggcc_s-1.dll
.\cygwin1.dll
C:\WINDOWS\system32\KERNEL32.dll
C:\WINDOWS\system32\ntdll.dll
.\cyggomp-1.dll
.\cygautotrace-3.dll
.\cygming-1.dll
.\cygfreetype-6.dll
.\cygbz2-1.dll
.\cygz.dll
.\cyggif-4.dll
.\cygX11-6.dll
.\cygxcb-1.dll
.\cygXau-6.dll
.\cygXdmcp-6.dll
.\cygpng15-15.dll
.\cygpstoedit-0.dll
.\cygstdc++-6.dll
.\cyggd-2.dll
.\cygfontconfig-1.dll
.\cygexpat-1.dll
.\cygjpeg-8.dll
.\cygXpm-4.dll
.\cygcairo-2.dll
.\cygpixman-1-0.dll
.\cygxcb-render-0.dll
.\cygxcb-shm-0.dll
.\cygXext-6.dll
.\cygXrender-1.dll
.\cygfftw3-3.dll
.\cygfpx-1.dll
.\cygglib-2.0-0.dll
.\cygiconv-2.dll
.\cygintl-8.dll
.\cygpcre-1.dll
.\cyggobject-2.0-0.dll
.\cygffi-6.dll
.\cyggs-9.dll
.\cygidn-11.dll
.\cyglcms2-2.dll
.\cygpaper-1.dll
.\cygtiff-5.dll
.\cygjbig-2.dll
.\cygXt-6.dll
.\cygICE-6.dll
.\cygSM-6.dll
.\cyguuid-1.dll
.\cygjasper-1.dll
.\cygltdl-7.dll
.\cyglzma-5.dll
.\cygpango-1.0-0.dll
.\cyggmodule-2.0-0.dll
.\cygthai-0.dll
.\cygdatrie-1.dll
.\cygpangocairo-1.0-0.dll
.\cygpangoft2-1.0-0.dll
.\cygharfbuzz-0.dll
.\cyggraphite2-3.dll
.\cygicule48.dll
.\cygicuuc48.dll
.\cygicudata48.dll
.\cygrsvg-2-2.dll
.\cygcroco-0.6-3.dll
.\cygxml2-2.dll
.\cyggdk_pixbuf-2.0-0.dll
.\cyggio-2.0-0.dll
C:\WINDOWS\system32\ADVAPI32.DLL
C:\WINDOWS\system32\RPCRT4.dll
C:\WINDOWS\system32\Secur32.dll
C:\WINDOWS\system32\GDI32.dll
C:\WINDOWS\system32\USER32.dll
.\cygMagickWand-5.dll
cygcheck: track_down: could not find cygpng14-14.dll

 
Installing “linpng: PNG library (docs and demos)” solved the issue. (I had to reboot the machine.)

The post /usr/bin/convert.exe: error while loading shared libraries: ?: cannot open shared object file: No such file or directory first appeared on Signature Web Media.]]> http://signaturewebmedia.com/blog/169/usrbinconvert-exe-error-while-loading-shared-libraries-cannot-open-shared-object-file-no-such-file-or-directory/feed/ 0 訃報 http://signaturewebmedia.com/blog/166/%e8%a8%83%e5%a0%b1/?utm_source=rss&utm_medium=rss&utm_campaign=%25e8%25a8%2583%25e5%25a0%25b1 http://signaturewebmedia.com/blog/166/%e8%a8%83%e5%a0%b1/#respond Mon, 23 Jul 2012 03:57:35 +0000 http://signaturewebmedia.com/blog/?p=166 日本オラクル社員時代に大変お世話になった木脇高太郎氏がお亡くなりになられたとのこと。
ご冥福を祈ります。どうもありがとうございました。

The post 訃報 first appeared on Signature Web Media.]]> 日本オラクル社員時代に大変お世話になった木脇高太郎氏がお亡くなりになられたとのこと。
ご冥福を祈ります。どうもありがとうございました。

The post 訃報 first appeared on Signature Web Media.]]> http://signaturewebmedia.com/blog/166/%e8%a8%83%e5%a0%b1/feed/ 0 MSI Sound Effect Manager removal http://signaturewebmedia.com/blog/160/msi-sound-effect-manager-removal/?utm_source=rss&utm_medium=rss&utm_campaign=msi-sound-effect-manager-removal http://signaturewebmedia.com/blog/160/msi-sound-effect-manager-removal/#respond Thu, 12 Jan 2012 01:55:12 +0000 http://signaturewebmedia.com/blog/?p=160 I’ve personally suffered from MSI’s Sound Effect manager’s weird behavior on Windows 7: the sound effects are on even if they are disabled. Re-installing the drive from Reaktek did not help either. I know the Sound Effect manager is a legacy control panel application, thus it was a possibility this to happen…
Searching on internet did not really help. After suffering almost whole day, I was finally able to fix the problem.
Here’s what I did.

Disable AC97 device from bios.
reboot (naturally)
deleted entries from registry via regedit.exe

(Make sure you make export of appropriate registry section each time.)
download PsTools from Microsoft’s Sysinternals.
run regedit.exe via psexec.exe:

psexec -s -i -d c:\windows\regedit.exe

delete following entries in the registory:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Control Panel\Extended Properties\{305CA226-D286-468e-B848-2B2E8E697B74} 2]
“%SystemRoot%\\system32\\ALSNDMGR.CPL”=dword:00000004
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Control Panel\Extended Properties\{305CA226-D286-468e-B848-2B2E8E697B74} 2]
“%SystemRoot%\\system32\\ALSNDMGR.CPL”=dword:00000004
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\PnpLockdownFiles]
“%SystemPath%\\system32\\drivers\\RTKVAC.SYS”=dword:00000005
“%SystemPath%\\SOUNDMAN.EXE”=dword:00000005
“%SystemPath%\\system32\\ALSNDMGR.CPL”=dword:00000005
“%SystemPath%\\system32\\ALSNDMGR.WAV”=dword:00000005
“%SystemPath%\\system32\\RTLCPL.EXE”=dword:00000005
“%SystemPath%\\system32\\RTLCPAPI.dll”=dword:00000005
“%SystemPath%\\system32\\RtkCfg.dll”=dword:00000005
“%SystemPath%\\system32\\RtkAPO.dll”=dword:00000005
“%SystemPath%\\system32\\RtkPgExt.dll”=dword:00000005
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers]
“C:\\Windows\\System32\\ALSNDMGR.CPL”=”RUNASADMIN”
[HKEY_USERS\S-1-5-21-3750584346-3454113483-1130964700-1000\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Compatibility Assistant\Persisted]
“C:\\Windows\\System32\\ALSNDMGR.CPL”=dword:00000010
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run]
“SoundMan”=”SOUNDMAN.EXE”

and deleted the files mentioned in the deleted registry values.

After this, restart the computer and re-enable the AC97. Windows should automatically re-configure the sound device.
Good luck!

The post MSI Sound Effect Manager removal first appeared on Signature Web Media.]]> I’ve personally suffered from MSI’s Sound Effect manager’s weird behavior on Windows 7: the sound effects are on even if they are disabled. Re-installing the drive from Reaktek did not help either. I know the Sound Effect manager is a legacy control panel application, thus it was a possibility this to happen…

Searching on internet did not really help. After suffering almost whole day, I was finally able to fix the problem.

Here’s what I did.

  1. Disable AC97 device from bios.
  2. reboot (naturally)
  3. deleted entries from registry via regedit.exe
    1. (Make sure you make export of appropriate registry section each time.)
    2. download PsTools from Microsoft’s Sysinternals.
    3. run regedit.exe via psexec.exe:
      • psexec -s -i -d c:\windows\regedit.exe
    4. delete following entries in the registory:
      • [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Control Panel\Extended Properties\{305CA226-D286-468e-B848-2B2E8E697B74} 2]
      • “%SystemRoot%\\system32\\ALSNDMGR.CPL”=dword:00000004
      • [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Control Panel\Extended Properties\{305CA226-D286-468e-B848-2B2E8E697B74} 2]
      • “%SystemRoot%\\system32\\ALSNDMGR.CPL”=dword:00000004
      • [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\PnpLockdownFiles]
      • “%SystemPath%\\system32\\drivers\\RTKVAC.SYS”=dword:00000005
      • “%SystemPath%\\SOUNDMAN.EXE”=dword:00000005
      • “%SystemPath%\\system32\\ALSNDMGR.CPL”=dword:00000005
      • “%SystemPath%\\system32\\ALSNDMGR.WAV”=dword:00000005
      • “%SystemPath%\\system32\\RTLCPL.EXE”=dword:00000005
      • “%SystemPath%\\system32\\RTLCPAPI.dll”=dword:00000005
      • “%SystemPath%\\system32\\RtkCfg.dll”=dword:00000005
      • “%SystemPath%\\system32\\RtkAPO.dll”=dword:00000005
      • “%SystemPath%\\system32\\RtkPgExt.dll”=dword:00000005
      • [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers]
      • “C:\\Windows\\System32\\ALSNDMGR.CPL”=”RUNASADMIN”
      • [HKEY_USERS\S-1-5-21-3750584346-3454113483-1130964700-1000\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Compatibility Assistant\Persisted]
      • “C:\\Windows\\System32\\ALSNDMGR.CPL”=dword:00000010
      • [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run]
      • “SoundMan”=”SOUNDMAN.EXE”
  4. and deleted the files mentioned in the deleted registry values.

After this, restart the computer and re-enable the AC97. Windows should automatically re-configure the sound device.

Good luck!

The post MSI Sound Effect Manager removal first appeared on Signature Web Media.]]> http://signaturewebmedia.com/blog/160/msi-sound-effect-manager-removal/feed/ 0 phpMyAdmin login/logout http://signaturewebmedia.com/blog/156/phpmyadmin-loginlogout/?utm_source=rss&utm_medium=rss&utm_campaign=phpmyadmin-loginlogout http://signaturewebmedia.com/blog/156/phpmyadmin-loginlogout/#respond Mon, 14 Nov 2011 14:16:42 +0000 http://signaturewebmedia.com/blog/?p=156 If you are wondering where the logout link for phpMyAdmin in your installation is, most likely you have the automatic login configured (auth_type is “config”) in your configuration file, config.in.php.
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'admin_user';
$cfg['Servers'][$i]['password'] = 'password';
Just change the auth_type to “cookie” and you will be redirected to login page when refresh the phpMyAdmin session and you will see the logout link. 🙂

The post phpMyAdmin login/logout first appeared on Signature Web Media.]]> If you are wondering where the logout link for phpMyAdmin in your installation is, most likely you have the automatic login configured (auth_type is “config”) in your configuration file, config.in.php.

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'admin_user';
$cfg['Servers'][$i]['password'] = 'password';

Just change the auth_type to “cookie” and you will be redirected to login page when refresh the phpMyAdmin session and you will see the logout link. 🙂

The post phpMyAdmin login/logout first appeared on Signature Web Media.]]> http://signaturewebmedia.com/blog/156/phpmyadmin-loginlogout/feed/ 0 Spam e-mails from SignatureWebMedia.com http://signaturewebmedia.com/blog/154/spam-e-mails-from-signaturewebmedia-com/?utm_source=rss&utm_medium=rss&utm_campaign=spam-e-mails-from-signaturewebmedia-com http://signaturewebmedia.com/blog/154/spam-e-mails-from-signaturewebmedia-com/#respond Tue, 31 May 2011 14:57:42 +0000 http://signaturewebmedia.com/blog/?p=154 We realized that there was a few SPAM e-mails sent out using our domain regarding FOREX stuff.
That was not us and our marketing e-mails always include our contact information as well as the way to opt-out.

The post Spam e-mails from SignatureWebMedia.com first appeared on Signature Web Media.]]> We realized that there was a few SPAM e-mails sent out using our domain regarding FOREX stuff.

That was not us and our marketing e-mails always include our contact information as well as the way to opt-out.

The post Spam e-mails from SignatureWebMedia.com first appeared on Signature Web Media.]]> http://signaturewebmedia.com/blog/154/spam-e-mails-from-signaturewebmedia-com/feed/ 0 osTicket with GMail http://signaturewebmedia.com/blog/147/osticket-with-gmail/?utm_source=rss&utm_medium=rss&utm_campaign=osticket-with-gmail http://signaturewebmedia.com/blog/147/osticket-with-gmail/#respond Sun, 27 Feb 2011 05:47:16 +0000 http://signaturewebmedia.com/blog/?p=147 We installed osTicket for some project. Man! it was not simple as I was hoping for.
Well, the basic installation was no pain, simple and easy; however, we had two issues with e-mail settings for gmail imap/pop utilization so the osTicket can send/receive ticket communication with customers.
Yes, that is right. osTicket let you receive e-mails from the customers for the reply to the ticket updates or to create a new ticket.
Gmail’s configuration instructions says:

imap.gmail.com
Use SSL: Yes
Port: 993

and

smtp.gmail.com (use authentication)
Use Authentication: Yes
Use STARTTLS: Yes (some clients call this SSL)
Port: 465 or 587

No matter what I do, I could not register the imap server nor smtp server. It ended up connection refused error.
I tested those with “telnet” from the command line on the server and they were immediately refused for the connection. My hunch was they are blocked by the firewall of the shared hosting server that the client uses. Then I contacted the hosting company via chat session:

(03:46:17 PM) Me: is it possible that you guys are blocking certain ports?
(04:01:09 PM) Support guy: My apologies, no, we do not block ports when connecting to Googles imap servers in anywya.
(04:01:12 PM) Support guy: *anyway
(04:05:05 PM) Me: $ telnet googlemail-imap.l.google.com 993
Trying 74.125.45.16…
telnet: connect to address 74.125.45.16: Connection refused
telnet: Unable to connect to remote host: Connection refused
(04:05:31 PM) Me: So are you saying I am refused by google?
(04:05:49 PM) Support guy: Yes, it seems they are refusing the connection.
(04:06:39 PM) Me: well, can you provide me a proof?

(03:46:17 PM) Me: is it possible that you guys are blocking certain ports?
(04:01:09 PM) Support guy: My apologies, no, we do not block ports when connecting to Googles imap servers in anywya.
(04:01:12 PM) Support guy: *anyway
(04:05:05 PM) Me: $ telnet googlemail-imap.l.google.com 993
Trying 74.125.45.16…
telnet: connect to address 74.125.45.16: Connection refused
telnet: Unable to connect to remote host: Connection refused
(04:05:31 PM) Me: So are you saying I am refused by google?
(04:05:49 PM) Support guy: Yes, it seems they are refusing the connection.
(04:06:39 PM) Me: well, can you provide me a proof?
(04:07:10 PM) Me: Since I do not have root access, I cannot perform certain operations
(04:07:36 PM) Me: the similar settings work from other hosts other than you.
(04:07:50 PM) Me: just FYI.
(04:08:29 PM) Support guy: One moment please.
(04:08:39 PM) Me: the ports in question are 465, 993 & 587
(04:09:29 PM) Support guy: I understand, one moment please.
(04:09:44 PM) Me: thx.
(04:09:59 PM) Support guy: Sure.
(04:17:50 PM) Support guy: One moment please.
(04:21:38 PM) Support guy: That should be working for port 995 now.
(04:22:34 PM) Me: confirmed. so was it blocked?
(04:23:20 PM) Support guy: It was, which it shouldn’t have been, I do apologize about htat.
(04:23:21 PM) Support guy: *that
(04:28:18 PM) Support guy: Is there anything else that I can assist you with today?
(04:28:38 PM) Me: is port 465 open also?
(04:29:31 PM) Support guy: One moment please.
(04:29:51 PM) Support guy: Yes it should be.

Yep, they were blocking certain ports. You have to trust your knowledge and gut feeling.

The post osTicket with GMail first appeared on Signature Web Media.]]> We installed osTicket for some project. Man! it was not simple as I was hoping for.

Well, the basic installation was no pain, simple and easy; however, we had two issues with e-mail settings for gmail imap/pop utilization so the osTicket can send/receive ticket communication with customers.

Yes, that is right. osTicket let you receive e-mails from the customers for the reply to the ticket updates or to create a new ticket.

Gmail’s configuration instructions says:

imap.gmail.com
Use SSL: Yes
Port: 993

and

smtp.gmail.com (use authentication)
Use Authentication: Yes
Use STARTTLS: Yes (some clients call this SSL)
Port: 465 or 587

No matter what I do, I could not register the imap server nor smtp server. It ended up connection refused error.

I tested those with “telnet” from the command line on the server and they were immediately refused for the connection. My hunch was they are blocked by the firewall of the shared hosting server that the client uses. Then I contacted the hosting company via chat session:

(03:46:17 PM) Me: is it possible that you guys are blocking certain ports?
(04:01:09 PM) Support guy: My apologies, no, we do not block ports when connecting to Googles imap servers in anywya.
(04:01:12 PM) Support guy: *anyway
(04:05:05 PM) Me: $ telnet googlemail-imap.l.google.com 993
Trying 74.125.45.16…
telnet: connect to address 74.125.45.16: Connection refused
telnet: Unable to connect to remote host: Connection refused
(04:05:31 PM) Me: So are you saying I am refused by google?
(04:05:49 PM) Support guy: Yes, it seems they are refusing the connection.
(04:06:39 PM) Me: well, can you provide me a proof?

(03:46:17 PM) Me: is it possible that you guys are blocking certain ports?

(04:01:09 PM) Support guy: My apologies, no, we do not block ports when connecting to Googles imap servers in anywya.

(04:01:12 PM) Support guy: *anyway

(04:05:05 PM) Me: $ telnet googlemail-imap.l.google.com 993

Trying 74.125.45.16…

telnet: connect to address 74.125.45.16: Connection refused

telnet: Unable to connect to remote host: Connection refused

(04:05:31 PM) Me: So are you saying I am refused by google?

(04:05:49 PM) Support guy: Yes, it seems they are refusing the connection.

(04:06:39 PM) Me: well, can you provide me a proof?

(04:07:10 PM) Me: Since I do not have root access, I cannot perform certain operations

(04:07:36 PM) Me: the similar settings work from other hosts other than you.

(04:07:50 PM) Me: just FYI.

(04:08:29 PM) Support guy: One moment please.

(04:08:39 PM) Me: the ports in question are 465, 993 & 587

(04:09:29 PM) Support guy: I understand, one moment please.

(04:09:44 PM) Me: thx.

(04:09:59 PM) Support guy: Sure.

(04:17:50 PM) Support guy: One moment please.

(04:21:38 PM) Support guy: That should be working for port 995 now.

(04:22:34 PM) Me: confirmed. so was it blocked?

(04:23:20 PM) Support guy: It was, which it shouldn’t have been, I do apologize about htat.

(04:23:21 PM) Support guy: *that

(04:28:18 PM) Support guy: Is there anything else that I can assist you with today?

(04:28:38 PM) Me: is port 465 open also?

(04:29:31 PM) Support guy: One moment please.

(04:29:51 PM) Support guy: Yes it should be.

Yep, they were blocking certain ports. You have to trust your knowledge and gut feeling.

The post osTicket with GMail first appeared on Signature Web Media.]]> http://signaturewebmedia.com/blog/147/osticket-with-gmail/feed/ 0 Windows 7: Where is the Wordpad? http://signaturewebmedia.com/blog/144/cygwin-where-is-the-wordpad/?utm_source=rss&utm_medium=rss&utm_campaign=cygwin-where-is-the-wordpad http://signaturewebmedia.com/blog/144/cygwin-where-is-the-wordpad/#respond Fri, 01 Oct 2010 14:04:51 +0000 http://signaturewebmedia.com/blog/?p=144 Every time when I open some Unix/Linux formatted (different newline format than Windows) text file on Windows’ desktop, I have to find the WordPad.exe when the Windows pop-up asks “Windows can’t open this file” and “What do you want to do?.”
I would select “Select a program from a list of installed programs.”
I could open from the list but it is not listed, then I have to browse it. Where is it?
Well, at least for Windows 7, it is in: C:\Program Files\Windows NT\Accessories as “wordpad.exe”

The post Windows 7: Where is the Wordpad? first appeared on Signature Web Media.]]> Every time when I open some Unix/Linux formatted (different newline format than Windows) text file on Windows’ desktop, I have to find the WordPad.exe when the Windows pop-up asks “Windows can’t open this file” and “What do you want to do?.”

I would select “Select a program from a list of installed programs.”

I could open from the list but it is not listed, then I have to browse it. Where is it?

Well, at least for Windows 7, it is in: C:\Program Files\Windows NT\Accessories as “wordpad.exe”

The post Windows 7: Where is the Wordpad? first appeared on Signature Web Media.]]> http://signaturewebmedia.com/blog/144/cygwin-where-is-the-wordpad/feed/ 0 Windows 7 & Vista: Cannot find the files saved on C drive http://signaturewebmedia.com/blog/142/windows-7-vista-cannot-find-the-files-saved-on-c-drive/?utm_source=rss&utm_medium=rss&utm_campaign=windows-7-vista-cannot-find-the-files-saved-on-c-drive http://signaturewebmedia.com/blog/142/windows-7-vista-cannot-find-the-files-saved-on-c-drive/#comments Tue, 13 Jul 2010 04:20:59 +0000 http://signaturewebmedia.com/blog/?p=142 We received a few calls from clients stating that they cannot find files they saved and are very sure that they did.
They also tried to change the folder (and search) option to show hidden files including system files and none of them worked…
Well, this is due to the Windows’ “virtualization” feature as some of the symptom are explained in kb927387. Basically Windows monitors certain directories under C drive (Windows installation drive). Anything written under such directories would be re-directed to c:\Users\<userid>\AppData\Local\VirtualStore
You should be able to find those files there.

The post Windows 7 & Vista: Cannot find the files saved on C drive first appeared on Signature Web Media.]]> We received a few calls from clients stating that they cannot find files they saved and are very sure that they did.

They also tried to change the folder (and search) option to show hidden files including system files and none of them worked…

Well, this is due to the Windows’ “virtualization” feature as some of the symptom are explained in kb927387. Basically Windows monitors certain directories under C drive (Windows installation drive). Anything written under such directories would be re-directed to c:\Users\<userid>\AppData\Local\VirtualStore

You should be able to find those files there.

The post Windows 7 & Vista: Cannot find the files saved on C drive first appeared on Signature Web Media.]]> http://signaturewebmedia.com/blog/142/windows-7-vista-cannot-find-the-files-saved-on-c-drive/feed/ 1