2019年3月29日金曜日

DELL M6600 を Windows10(64bit)化したときのデバイスドライバエラーの解決方法

07-30-2015 10:40 AM

Experience Installing Windows 10 on M6600 Precision Mobile Workstation

Dell is not supporting installation of Windows 10 on the M6600 (it does on the M6700 and M6800) but Microsoft's Windows 10 tool was reporting the PC would be compatible, so...

I'm sure Dell doesn't recommend this but...

1) I created with Windows 7 a backup of my C: drive and created a system recovery disk, so I could go back to Win 7 if I wanted.

2) Installed the free Windows 10 upgrade choosing to "Install on This PC" over the existing operating system.

3) The install came up OK with the PC working, but not without a nasty surprise with my HP Printer driver for a LaserJet MFP175nw printer, which not only was not working, but also was not corrupted in my Windows control panel. If I tried to run any HP printer app, or delete the driver in Control Panel, etc. a Windows 10 error screen appeared saying the Administrator blocked uninstalling or running it because it wasn't safe (no signature). Of course, I was logged in as the Window Admin so there's was no way to uninstall the old Windows 7 printer drivers. HP Support confirmed they would have no solution except to recommend I do clean install of Windows 10.

Suggestion: delete any HP printer drivers before trying a Windows 10 upgrade.

FYI, when you upgrade Win 10 over Win 7, you within the next 30 days have an option to revert back to Windows 7 -- it saves a recovery version on your C: drive in a Windows Old folder, but after 30 days will auto delete that altogether.

But rather than go back to Win 7, I decided to do the clean install of Windows 10 to fix my HP software bug.

Before you try a clean install, make sure you did register your Windows 10 by logging into a Microsoft Account with your email and password, so your account in the cloud knows you are a valid user.

4) After you install Windows 10 once over your Windows 7, Microsoft will allow you to do a clean install, even though you do not have a Product Key id for Windows 10. You do that by using their Media Creation Tool and choosing to Install On Another PC which lets you copy the OS onto a USB drive or DVD. Then you boot from the USB and DVD to install. You are presented with a listing of your hard drives and partitions on them and choose which partition to install Windows 10 into.

5) This installation asks you to supply a product key. Using your Windows 7 product key that on the sticker is inside your battery area will not validate Windows 10. But since you previously installed Windows 10 over Windows 7, and registered with Microsoft in your account and checked that your Win 10 status in Control Panel as "Activated", you can click SKIP and leave product key blank. You are prompted a second time to enter you product key later on, also skipped that.

6) The PC came up running OK, but Windows was not validated as Activated until I signed into Microsoft with my email and password, after which my status changed to Activated on the PC.

7) Checking Windows Device Manager, I noticed that most devices were installed with Microsoft's own drivers, not with any Dell drivers since I had wiped them out with a clean install.

The good news was Microsoft installed by itself the correct drivers for my two video displays, an Intel HD Graphics 3000 and an nVidia Quadro 3000M and they work fine.

But in Windows Device Manager I found 4 errors…

So, my process was to create a System Restore Point manually before I tried to resolve each error by installing some driver. If my attempt failed, I rolled back to the previous restore point so my Windows registry was clean.

Here are the errors I had:

Error: Unknown Device

Due to missing FreeFall Sensor Driver

So Installed DRVR_WIN_R309372 from Dell site. Works!

Next…

Error: PCI Serial Port

Installed

Intel Management Engine 7.1 Components Installer Intel Management Engine 7.1 Components

Chipset_Driver_MPGY4_WN_7.1.70.1205_A05.EXE

From <http://www.dell.com/support/home/us/en/19/product-support/servicetag/BZD7LQ1/drivers?s=BSD>

Works!

Next…

Error: Mass Storage Controller

Due to O2Micro card reader

Dell drivers will not install without error. Do not try to install them. Could not find any driver from the manufacturer either. The good news is the card reader is working OK using Microsoft's own generic driver.

Error: Broadcom USH

This is the fingerprint reader needing a driver. Since I don't use it I didn't try to resolve this one.

Other than that, the M6600 is working fine. Online

On the plus side, the PC boots faster and most programs (like Adobe CC) load faster.

I have no Windows 10 driver for my 3-year old HP LaserJet, perhaps one will come available later.

I have not attempted to override any Microsoft drivers Win 10 installed with those on the Dell site, but might try that (after creating a restore point so I can recover) using Win 8 versions (not Win 7 since I understand there is more similarity between 8 drivers and 10.)

But since my M6600 is working as well as before, I may leave things as is. I don't think I'll need to revert back to my emergency system restore to go back to Win 7.

Since I ended up doing a clean install, I did need to reinstall all programs that were on my C: drive.

Will report more bugs if I encounter them.

DELL LATITUDE E4310 をWindows10化!(不明なデバイス対応) - MoCA研究所(JL1MCA 無線とコンピュータのBlog)

2019年3月28日木曜日

mysqlでの50音順ソート(濁音・半濁音など) 以下の様なテーブル… - 人力検索はてな

http://q.hatena.ne.jp/1410397790


COLLATE 節を使うと、以下のように書けます。

SELECT kana
    FROM table_name
    ORDER BY kana COLLATE utf8_unicode_ci;

COLLATE 節についての、MySQL のマニュアルは、こちらです。

ただ、質問に書いてある内容だけではなくて、「シ」と「ジ」だけではなく「し」や「じ」も順序が同一視されます。

もし、カタカナの読みしか入らない、というカラムだったら、COLLATE utf8_unicode_ci が使えると思います。

Elasticsearch実運用時の注意点とアンチパターンまとめ - サナギわさわさ.json

2019年3月7日木曜日

web開発のためのapacheやコンテンツディレクトリのパーミッション関連まとめ

web開発のためのapacheやコンテンツディレクトリのパーミッション関連まとめ
https://egapool.hatenablog.com/entry/2013/11/29/184300

PHPで現在アクセスされているページのURLを取得する - Qiita

https://qiita.com/tsujimomo/items/c293d15e34646a826266

現在のページ自体
echo $_SERVER["REQUEST_URI"];

ホスト名も取得する場合
echo $_SERVER["HTTP_HOST"] . $_SERVER["REQUEST_URI"];

プロトコルも取得する場合
echo (empty($_SERVER["HTTPS"]) ? "http://" : "https://") . $_SERVER["HTTP_HOST"] . $_SERVER["REQUEST_URI"];

Linux ファイル名に空白文字があっても find | grep する方法

通常ファイル名に空白文字が入っている場合エラーになるが、以下のように -print0 と -0 を付けると空白文字入りファイル名も対処できる。

$ find . -name "*.txt" -print0 | xargs -0 grep "http://www.google.co.jp"

【linux】 スペースを含むファイル名を find | xargs で使う方法 at softelメモ
https://www.softel.co.jp/blogs/tech/archives/5367

2019年3月3日日曜日

Linux ファイル内文字列の検索置換

sed -e "s/置換元/置換後/g" ファイル名 > ファイル名2  
  • -eオプション:指定したスクリプト(条件式)で変換処理を行う
  • s:冒頭のsは「置換元を置換後に変換する」を表す
  • g:末尾のgは「条件を満たす"すべての"文字列を置換する」を表す
  • 置換元:正規表現で記述可
  • 置換後\1\2で、置換元でマッチした文字を取ってこれる
【sed / awk / grep】文字列の置換・抽出・検索と正規表現 | Linux Cheat Sheet - Qiita

  • -iオプション:変換結果を同一ファイル上書きする
sed -i -e "s/置換元/置換後/g" ファイル名  

AWSのロードバランサでSSLリダイレクト

現在、AWSのロードバランサ(ELB)は2種類ありますので、以下のようそれぞれ設定します。



Classic Load Balancerの場合(Apacheサーバ側も設定が必要です)
ELB を使用して HTTP トラフィックを HTTPS にリダイレクトする
https://aws.amazon.com/jp/premiumsupport/knowledge-center/redirect-http-https-elb/

Application Load Balancerの場合(ロードバランサだけで設定可能です)
[新機能]Webサーバでの実装不要!ALBだけでリダイレクト出来るようになりました! | DevelopersIO
https://dev.classmethod.jp/cloud/aws/alb-redirects/

その他参考
AWS Application Load Balancer の SSL(HTTPSリスナー)設定メモ | あぱーブログ
https://blog.apar.jp/web/6645/