NetKnow Corporate Blog

From - Wed Feb 19 21:26:51 2014

X-Account-Key: account2

X-UIDL: 00056e9d501fb806

X-Mozilla-Status: 0001

X-Mozilla-Status2: 00000000

X-Mozilla-Keys:

Return-path:

Envelope-to: sales@nk.ca

Delivery-date: Wed, 19 Feb 2014 21:26:17 -0700

Received: from mail4.ugr.es ([150.214.35.27] helo=mail1.ugr.es)

by doctor.nl2k.ab.ca with esmtp (Exim 4.82)

(envelope-from )

id 1WGLD4-000608-Oh

for sales@nk.ca; Wed, 19 Feb 2014 21:26:17 -0700

Received: from smtp2.ugr.es (smtp2.ugr.es [150.214.220.62])

by mail1.ugr.es (Postfix) with ESMTP id D3AA426E30;

Thu, 20 Feb 2014 03:17:41 +0100 (CET)

Received: from laygroup.claygroup.com (50-196-106-233-static.hfc.comcastbusiness.net [50.196.106.233])

by smtp2.ugr.es (Postfix) with ESMTPSA id BF585CAE2;

Thu, 20 Feb 2014 01:35:10 +0100 (CET)

Content-Type: text/plain; charset="iso-8859-1"

MIME-Version: 1.0

Content-Transfer-Encoding: quoted-printable

Content-Description: Mail message body

Subject: !!Charity Donation Funds!!

To: you

From: The Alberta Cancer Foundation

Date: Wed, 19 Feb 2014 19:35:02 -0500

Reply-To: albertacancertomcrist@rogers.com



The Alberta Cancer Foundation in alliance with my humble self, Mr. Tom

Crist, the Canadian CEO that won $40 million in the Calgary Canada Lotto are

writing to inform you that Google submitted your "Email" upon our request to

receive a Check for $1.2 million from me, after I decided to donate my

entire winnings in honour of my late wife, Jan, who died of cancer two years

ago. I have already donated $6 million to the Alberta Cancer Foundation,

which collects donations for Calgary's Tom Baker Cancer Centre, where Jan

was treated before her death.



Beneficiaries are always advised to also donate to cancer foundations close

to them as we aim to directly support patients.



Send me your *Full-Names, *Age:, *Tel:, & *Country, and a donation Check for

$1.2million will be issued to you.....See links below for more proof/detail=

s;



http://edition.cnn.com/video/data/2.0/video/world/2013/12/18/dnt-ctv-network

-lotto-winner.ctv-network.html





Sincerely,

Mr. Tom Crist

All data is from Netcraft Toolbar . Looks as if there are major changes to the Netcraft algorithm!

NetKnow

Netknow now ranks 2464 at Netcraft and in Netcraft's top 200 Canadian sites.



A slight increase! We must do security audits regularly!



Some of our others domains and services ranks as follows:



NetKnow Secure Server

ranks 72904 from 70215 on Netcraft and pfs compliant .

NetKnow's secondary server

ranks at 26549 from 41550 last week on Netcraft.

NetKnow's Anonynous FTP server

is at 428945 from 426940 and non-anonymous rank 469512 from 466998.

www.nl2k.ab.ca

ranks 395305 from 409649 on Netcraft.

edmontonab.ca

ranks 429135 from 427132 .

edmontoninternetserviceprovider.ca

is at 429124 from 427122 .

internetedmonton.ca

ranks at 492364 from 489605 .



How do we compare with other providers in

Edmonton, Alberta, Canada?

Netknow again

We at Netknow are up 86 and up 349 the start of the year 2014 from 2813 . We aim to be above 2000 by the end of February 2014.

Telus and reviews

Next we have Telus.com

ranked by Netcraft at 27929 from 28109 with Mytelus

ranking 11526 from 11516.

Sometimes their Web Hosting is done by
title="Internet Names for Business">Internet Names for Business

is ranked by Netcraft at 423193 from 421264.



Is Telus's ADSL network suspectible to Code Red Attacks and Attackers?



Reviews of Telus are available :

• NCIX FORUMS



• DSL Reports

Juno and NetZero

We have Juno Internet ranked on top

at 40425 from 38708 who are the owners of

US Based Netzero at Netcraft Rank 25119 from 25720 .

Shaw Cable

Next, members.shaw.ca

ranks 63325 from 63302 and

Shaw Cable

is next at Netcraft rank 35306 from 35048. Briefly unavailable during high peak demand.

Their Network Hosting Arm,

Big Pipe is at

Netcraft rank ??? from 417310 .

One of customer of Shaw Avalon Global

rank 491663 from 488898 .



Reviews of Shaw are available :

• Rate It All



• Review Stream



• Review Stream Number 2



• DSL reports

University of Alberta

The University of Alberta ranks 36157 from 36180 .

Carbon 14

Carbon 14 Graphic Art and Web Design

ranks 124496 from 133718 on Netcraft and redirect to securepaynet.net .

BTW Illusions Photographics wants a word with you

City of Edmonton

The City of Edmonton ranks 143879 from 143203 by Netcraft and are now with Alentus of Edmonton.

Primus

Primus

ranks 156694 from 154296 and now points to BLACKIRON_DataCentres

ranked 300868 from 284823. Or

Colo Is here ranks 156694 from 154296.

A customer the Progressive Conservative Party of Alberta

ranks 310457 from 308944 .

Xplornet

xplornet

ranks 169725 from 175568 and are listed with

Stentor and are joining up with Shaw.

According to an article in the Sherwood Park Independent they are also getting an Alberta Government subsidy.

Distributel / 3Web / CIA

Next is 3 Web

ranks 492709 from 489960 And a questionable secure certificate. Their parent company

Cybersurf

is ranked 173380 from 179415.

Uniserve / Interbaun

Next, Uniserve

ranks on Netcraft 253941 from 252655.

One of their acquisitions

interbaun

ranks with Netcraft 253941 from 252655 due to merging of sites.

One customer just came over from this organization in Nov 2006.

Tera Byte Edmonton and reviews

Next is Tera-Byte

at Netcraft Rank 259097 from 247443 with

Tera-Byte.ca

ranking 515148 from 512232 and their wireless arm Tera-Byte Wireless

ranks 469624 from 467121 and

airsurfer.ca is now part of Tera-Byte Wireless.

One of Tera-Byte's acquisitions

Edmonton Community Networks

ranks at 467455 from 464889 and

Go Edmonton ranks 508741 from 505294.

Reviews of Tera-byte is available at

here

and another here

NAIT / Northern Alberta Institute of Technology

The Northern Alberta Institute of Technology

ranks 282787 from 274907.

Internet Centre / CCINet

Internet Centre

rank 286671 from 299649 and using Worldgate IPs

Alentus

Alentus

rank by Netcraft 296869 from 295254 and I note they are hosted in the USA .

Pivot Data Centres

Pivot Data Centres ranks 347396 from 357330

And are associated with Rogers Business Solutions .

Grant MacEwen University

MacEwan

ranks 353081 from 295317.

Radiant Communications

Radiant Communications

are ranked by Netcraft 393338 from 391318

WSI Corporation

Next is WSI - We Simply The Internet of Toronto

at Netcraft Position 408965 from 406906

Wild Rose Internet

Wild Rose Internet

ranks 409876 from 407862 and I wonder if this is another wireless branch of Tera-Byte

Nucleus Internet Services

After that we have

Nucleus Information Services which can be found at Netcraft Rank 427898 from 425875

Clearwave Broadband

Clearwave Broadband ranks at 456068 from 475408.

Nisa Custom Internet Solutions

Nisa Custom Internet Solutions

ranks 462441 from 459974 by Netcraft

Wolfpaw

Computer Engineering

ranks 492609 from 489852 . Thank you Scott.

And they seem to be hosted by wolfpaw.net

which ranks at 467896 from 465385.

Koi Media

Koi Media

rank 468190 from 465694

MDCi

MDCi, the company that bought out OANet.com

ranks 488958 from 486194 .

WebFire

Webfire.ca

ranks 492009 from 489233 and seems to be connected with Shaw.

Platinum Communications

Platinum Communications Corp.

ranks 492087 from 466610.

Core Network Solutions Inc.

Core Network Solutions Inc.

ranks at 492279 from 489522.

MediaShaker

Media Shakers of Edmonton

ranks 513634 from 510752.

Emergence by Design

Emergence by Design

now ranks 514886 from 511978

Open Concept Internet, Inc.

Open Concept Internet, Inc.

rank 516337 from 513419.

TIC Internet

TIC Internet

ranks 516732 from 513873 ( I do remember you).

Government of Alberta

The Government of Alberta Website

ranks 517185 from 514343 by Netcraft

The Network Centre

The Network Centre

ranks 517352 from 514513 and are linked with Bell canada.

Wiband Wireless

Wiband Wireless

rank on Netcraft at 655356 from 748316 and

their customer Found Locally

ranks at 510010 from 507146

InterSpots

Interspots of Edmonton

rank ?????? from 514174 ;

Internet Crossroads

Internet Crossroads Ltd of North Edmonton

rank nothing from nothing by Netcraft and seems to merged with Tera-Byte/ecn.ab.ca .



If I remember anymore, I will add to this entry, before Netcraft changes

our ranking. Please watch this space and please feel free to peruse

our services.

All data is from Netcraft Toolbar . Looks as if there are major changes to the Netcraft algorithm!

NetKnow

Netknow now ranks 2550 at Netcraft and in Netcraft's top 200 Canadian sites.



A slight increase! We must do security audits regularly!



Some of our others domains and services ranks as follows:



NetKnow Secure Server

ranks 70215 from 73787 on Netcraft and pfs compliant .

NetKnow's secondary server

ranks at 41550 from 48848 last week on Netcraft.

NetKnow's Anonynous FTP server

is at 426940 from 420041 and non-anonymous rank 466998 from 420164.

www.nl2k.ab.ca

ranks 409649 from 372137 on Netcraft.

edmontonab.ca

ranks 427132 from 386902 .

edmontoninternetserviceprovider.ca

is at 427122 from 386892 .

internetedmonton.ca

ranks at 489605 from 439370 .



How do we compare with other providers in

Edmonton, Alberta, Canada?

Netknow again

We at Netknow are up 263 and up 263 the start of the year 2014 from 2813 . We aim to be above 2000 by the end of February 2014.

Telus and reviews

Next we have Telus.com

ranked by Netcraft at 28109 from 31095 with Mytelus

ranking 11516 from 11674.

Sometimes their Web Hosting is done by
title="Internet Names for Business">Internet Names for Business

is ranked by Netcraft at 421264 from 381488.



Is Telus's ADSL network suspectible to Code Red Attacks and Attackers?



Reviews of Telus are available :

• NCIX FORUMS



• DSL Reports

Juno and NetZero

We have Juno Internet ranked on top

at 38708 from 38251 who are the owners of

US Based Netzero at Netcraft Rank 25720 from 26835 .

Shaw Cable

Next, members.shaw.ca

ranks 63302 from 60809 and

Shaw Cable

is next at Netcraft rank 35048 from 31026. Briefly unavailable during high peak demand.

Their Network Hosting Arm,

Big Pipe is at

Netcraft rank 417310 from 351402 .

One of customer of Shaw Avalon Global

rank 488898 from 438776 .



Reviews of Shaw are available :

• Rate It All



• Review Stream



• Review Stream Number 2



• DSL reports

University of Alberta

The University of Alberta ranks 36180 from 90808 .

Carbon 14

Carbon 14 Graphic Art and Web Design

ranks 133718 from 433522 on Netcraft and redirect to securepaynet.net .

BTW Illusions Photographics wants a word with you

City of Edmonton

The City of Edmonton ranks 143203 from 138079 by Netcraft and are now with Alentus of Edmonton.

Primus

Primus

ranks 154296 from 140833 and now points to BLACKIRON_DataCentres

ranked 284823 from 273759. Or

Colo Is here ranks 154296 from 140833.

A customer the Progressive Conservative Party of Alberta

ranks 308944 from 288641 .

Xplornet

xplornet

ranks 175568 from 241438 and are listed with

Stentor and are joining up with Shaw.

According to an article in the Sherwood Park Independent they are also getting an Alberta Government subsidy.

Distributel / 3Web / CIA

Next is 3 Web

ranks 489960 from 439666 And a questionable secure certificate. Their parent company

Cybersurf

is ranked 179415 from 194714.

Tera Byte Edmonton and reviews

Next is Tera-Byte

at Netcraft Rank 247443 from 234280 with

Tera-Byte.ca

ranking 512232 from 458142 and their wireless arm Tera-Byte Wireless

ranks 467121 from 420277 and

airsurfer.ca is now part of Tera-Byte Wireless.

One of Tera-Byte's acquisitions

Edmonton Community Networks

ranks at 464889 from 418297 and

Go Edmonton ranks 505294 from 452795.

Reviews of Tera-byte is available at

here

and another here

Uniserve / Interbaun

Next, Uniserve

ranks on Netcraft 252655 from 253948.

One of their acquisitions

interbaun

ranks with Netcraft 252655 from 253948 due to merging of sites.

One customer just came over from this organization in Nov 2006.

NAIT / Northern Alberta Institute of Technology

The Northern Alberta Institute of Technology

ranks 274907 from 253405.

Alentus

Alentus

rank by Netcraft 295254 from 290683 and I note they are hosted in the USA .

Grant MacEwen University

MacEwan

ranks 295317 from 270705.

Internet Centre / CCINet

Internet Centre

rank 299649 from 274157 and using Worldgate IPs

Pivot Data Centres

Pivot Data Centres ranks 357330 from 329402

And are associated with Rogers Business Solutions .

Radiant Communications

Radiant Communications

are ranked by Netcraft 391318 from 356845

WSI Corporation

Next is WSI - We Simply The Internet of Toronto

at Netcraft Position 406906 from 356262

Wild Rose Internet

Wild Rose Internet

ranks 407862 from 400941 and I wonder if this is another wireless branch of Tera-Byte

Nucleus Internet Services

After that we have

Nucleus Information Services which can be found at Netcraft Rank 425875 from 334439

Nisa Custom Internet Solutions

Nisa Custom Internet Solutions

ranks 459974 from 432845 by Netcraft

Koi Media

Koi Media

rank 465694 from 418991

Platinum Communications

Platinum Communications Corp.

ranks 466610 from 419805.

Wolfpaw

Computer Engineering

ranks 489852 from 439584 . Thank you Scott.

And they seem to be hosted by wolfpaw.net

which ranks at 465385 from 418705.

Clearwave Broadband

Clearwave Broadband ranks at 475408 from 426544.

MDCi

MDCi, the company that bought out OANet.com

ranks 486194 from 436418.

WebFire

Webfire.ca

ranks 489233 from 438055 and seems to be connected with Shaw.

Core Network Solutions Inc.

Core Network Solutions Inc.

ranks at 489522 from 439311.

MediaShaker

Media Shakers of Edmonton

ranks 510752 from 456887.

Emergence by Design

Emergence by Design

now ranks 511978 from 457920

Open Concept Internet, Inc.

Open Concept Internet, Inc.

rank 513419 from 459128.

TIC Internet

TIC Internet

ranks 513873 from 459567 ( I do remember you).

InterSpots

Interspots of Edmonton

rank 514174 from 459803 ;

Government of Alberta

The Government of Alberta Website

ranks 514343 from 419889 by Netcraft

The Network Centre

The Network Centre

ranks 514513 from 460068 and are linked with Bell canada.

Wiband Wireless

Wiband Wireless

rank on Netcraft at 748316 from 298570 and

their customer Found Locally

ranks at 507146 from 433359

Internet Crossroads

Internet Crossroads Ltd of North Edmonton

rank nothing from nothing by Netcraft and seems to merged with Tera-Byte/ecn.ab.ca .



If I remember anymore, I will add to this entry, before Netcraft changes

our ranking. Please watch this space and please feel free to peruse

our services.

Due to resource taxing, the blog is moved from MySQL to postgres.



And the process:







rootnl2k



Posts: 2

Joined: Mon Jul 16, 2012 11:15 pm



Re: Moved from MySQL to PostGres



Postby rootnl2k » Tue Feb 11, 2014 10:15 am

Correct you are Gavin.



So 4 steps.



1) from http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL#Export_using_CSV-files





When you have a large sql dump and a binary data inside, it will be uneasy to modify the data structure, so there is another way to export your data to PostgreSQL. Mysql have an option to export each tables from database as separate .sql file with table structure and .txt file with table's data in CSV-format:



mysqldump -u username -p -T/path/to/export databasename



Notice that /path/to/export should be writeable by user who runs mysqld, in most case it mysqld.



2) Create a new Serendipity instance specifying posthresql



3) From http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL#Export_using_CSV-files



After that you should modify your table structure according PostgreSQL format:



convert data types

create separate keys definitions

replace escape characters



When table structure will be ready, you should load it as it was shown above. You should prepare data files: replace carriage return characters to "\r" and remove invalid characters for your data encoding. Here is an example bash script how you can do this and load all the data in your database:



#!/bin/bash



CHARSET="utf-8" #your current database charset

DATADIR="/path/to/export"

DBNAME="databasename"



for file in `ls -1 $DATADIR/*.txt`; do

TMP=${file%.*}

TABLE=${TMP##*/}

echo "preparing $TABLE"



#replace carriage return

sed 's/\r/\\r/g' $file > /tmp/$TABLE.export.tmp



#cleanup non-printable and wrong sequences for current charset

iconv -t $CHARSET -f $CHARSET -c < /tmp/$TABLE.export.tmp > /tmp/$TABLE.export.tmp.out



echo "loading $TABLE"

/usr/bin/psql $DBNAME -c "copy $TABLE from '/tmp/$TABLE.export.tmp.out'"



#clean up

rm /tmp/$TABLE.export.tmp /tmp/$TABLE.export.tmp.out

done



4) If the index does not work and you see duplicate key violates unique constraint



Look at http://hcmc.uvic.ca/blogs/index.php?blog=22&p=8105&more=1&c=1&tb=1&pb=1



How to fix PostgreSQL error "duplicate key violates unique constraint"

If you get this message when trying to insert data into a PostgreSQL database:





ERROR: duplicate key violates unique constraint



That likely means that the primary key sequence in the table you're working with has somehow become out of sync, likely because of a mass import process (or something along those lines). Call it a "bug by design", but it seems that you have to manually reset the a primary key index after restoring from a dump file. At any rate, to see if your values are out of sync, run these two commands:





SELECT MAX(the_primary_key) FROM the_table;



SELECT nextval('the_primary_key_sequence');



If the first value is higher than the second value, your sequence is out of sync. Back up your PG database (just in case), then run thisL





SELECT setval('the_primary_key_sequence', (SELECT MAX(the_primary_key) FROM the_table)+1);



That will set the sequence to the next available value that's higher than any existing primary key in the sequence.



Please a \dt might be needed to see what the_primary_key_sequence is.