FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Debian > Debian Development

 
 
LinkBack Thread Tools
 
Old 08-23-2008, 08:37 AM
Norbert Tretkowski
 
Default Bug#477072: mysql-server-5.0: Arbitrary data input plus GIS functions, causes mysql server crash

Am Montag, den 18.08.2008, 09:22 -0700 schrieb tabris:
> This bug has been sitting around since July w/o a resolution.
>
> I tracked it down to a difference between i386 builds and AMD64. The
> crash only occurs on AMD64. I think this is an important bug to be fixed
> as it results in a minor reproducible DoS/data-loss (of temporary tables
> and heap tables).
>
> At this point I am unclear on what to do about it, especially as I
> contacted the maintainer directly 3 weeks ago and still have yet to
> receive a response.

I am still unable to reproduce this crash, even on amd64. I get a bunch
of syntax errors when sourcing country.sql, but no crash when sourcing
mysql-crash.sql.

Norbert


--
To UNSUBSCRIBE, email to debian-devel-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
 
Old 08-23-2008, 06:04 PM
tabris
 
Default Bug#477072: mysql-server-5.0: Arbitrary data input plus GIS functions, causes mysql server crash

Norbert Tretkowski wrote:

Am Montag, den 18.08.2008, 09:22 -0700 schrieb tabris:


This bug has been sitting around since July w/o a resolution.

I tracked it down to a difference between i386 builds and AMD64. The
crash only occurs on AMD64. I think this is an important bug to be fixed
as it results in a minor reproducible DoS/data-loss (of temporary tables
and heap tables).

At this point I am unclear on what to do about it, especially as I
contacted the maintainer directly 3 weeks ago and still have yet to
receive a response.



I am still unable to reproduce this crash, even on amd64. I get a bunch
of syntax errors when sourcing country.sql, but no crash when sourcing
mysql-crash.sql.

Norbert



Find attached a clean copy of both files, and a tarball of them.

I'm guessing that the country.sql may have been corrupted somehow, thus
the syntax errors.


Also, just updated to 5.0.51a-12, and it still happens.
-- MySQL dump 10.11
--
-- Host: localhost Database: svsdev
-- ------------------------------------------------------
-- Server version 5.0.51-3

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `country`
--

DROP TABLE IF EXISTS `country`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `country` (
`low` int(10) unsigned NOT NULL default '0',
`high` int(10) unsigned NOT NULL default '0',
`country` char(2) NOT NULL default '-',
PRIMARY KEY (`low`,`high`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `country`
--

LOCK TABLES `country` WRITE;
/*!40000 ALTER TABLE `country` DISABLE KEYS */;
INSERT INTO `country` VALUES (1432264704,1432272896,'ad'),(1538998272,153900646 4,'ad'),(3262479282,3262479282,'ad'),(3265150976,3 265159168,'ad'),(3278943684,3278943684,'ad'),(3278 943735,3278943735,'ad'),(1040983568,1040983576,'ae '),(1049759984,1049760000,'ae'),(1049764448,104976 4464,'ae'),(1049766512,1049766528,'ae'),(104976793 6,1049767952,'ae'),(1049768768,1049768800,'ae'),(1 049769120,1049769152,'ae'),(1049770112,1049770128, 'ae'),(1049772896,1049772928,'ae'),(1049775088,104 9775104,'ae'),(1049776448,1049776480,'ae'),(104977 8336,1049778352,'ae'),(1049779136,1049779168,'ae') ,(1049782304,1049782336,'ae'),(1049783744,10497837 60,'ae'),(1049817288,1049817296,'ae'),(1307898048, 1307898080,'ae'),(1307898576,1307898592,'ae'),(131 5897344,1315901440,'ae'),(1317113856,1317114112,'a e'),(1331853312,1331855360,'ae'),(1347979752,13479 79760,'ae'),(1347982208,1347982224,'ae'),(13502157 84,1350215788,'ae'),(1350217348,1350217352,'ae'),( 1350217408,1350217424,'ae'),(1350217696,1350217712 ,'ae'),(1354674944,1354675200,'ae'),(1354676480,13 54676736,'ae'),(1354676736,1354676768,'ae'),(13546 76992,1354677024,'ae'),(1354677248,1354677280,'ae' ),(1354678016,1354678032,'ae'),(1354678560,1354678 576,'ae'),(1354679296,1354679808,'ae'),(1354680064 ,1354680080,'ae'),(1354681472,1354681488,'ae'),(13 54682288,1354682304,'ae'),(1354682896,1354682912,' ae'),(1354684416,1354684432,'ae'),(1354684672,1354 684928,'ae'),(1357053952,1357119488,'ae'),(1358899 304,1358899312,'ae'),(1389199360,1389232128,'ae'), (1389272368,1389272384,'ae'),(1389273344,138927360 0,'ae'),(1389274880,1389275136,'ae'),(1399717888,1 399848960,'ae'),(1401423872,1401425920,'ae'),(1403 661216,1403661248,'ae'),(1403661248,1403661280,'ae '),(1403662176,1403662208,'ae'),(1403662272,140366 2304,'ae'),(1403662944,1403662976,'ae'),(140366313 6,1403663168,'ae'),(1403663168,1403663200,'ae'),(1 403663568,1403663576,'ae'),(1410008576,1410008608, 'ae'),(1410013472,1410013504,'ae'),(1410013504,141 0013536,'ae'),(1410013568,1410013632,'ae'),(141001 3664,1410013696,'ae'),(1410013728,1410013760,'ae') ,(1410013952,1410013984,'ae'),(1410014048,14100140 80,'ae'),(1410014208,1410014240,'ae'),(1410014336, 1410014400,'ae'),(1410014944,1410014952,'ae'),(141 0014973,1410014973,'ae'),(1410014974,1410014974,'a e'),(1410015424,1410015488,'ae'),(1410015872,14100 15936,'ae'),(1410016256,1410016320,'ae'),(14100165 76,1410016608,'ae'),(1410016832,1410016864,'ae'),( 1410016896,1410017024,'ae'),(1410018304,1410018560 ,'ae'),(1410022528,1410022592,'ae'),(1410024192,14 10024224,'ae'),(1410025280,1410025312,'ae'),(14100 25408,1410025440,'ae'),(1410025504,1410025520,'ae' ),(1410025728,1410025760,'ae'),(1410025792,1410025 824,'ae'),(1410026016,1410026048,'ae'),(1410026176 ,1410026208,'ae'),(1410026240,1410026368,'ae'),(14 10036224,1410036352,'ae'),(1410036480,1410036512,' ae'),(1410039808,1410041856,'ae'),(1410072320,1410 072576,'ae'),(1410745224,1410745232,'ae'),(1412415 488,1412431872,'ae'),(1424612608,1424612672,'ae'), (1425971712,1425971728,'ae'),(1425979653,142597965 3,'ae'),(1425979654,1425979656,'ae'),(1425979656,1 425979656,'ae'),(1425979661,1425979661,'ae'),(1425 979662,1425979664,'ae'),(1425979664,1425979680,'ae '),(1425979680,1425979688,'ae'),(1425979688,142597 9692,'ae'),(1425979692,1425979692,'ae'),(142597970 5,1425979705,'ae'),(1425979706,1425979708,'ae'),(1 425979708,1425979708,'ae'),(1425979905,1425979905, 'ae'),(1425979906,1425979908,'ae'),(1425979908,142 5979912,'ae'),(1425979912,1425979920,'ae'),(142597 9920,1425979936,'ae'),(1425979936,1425979968,'ae') ,(1425979968,1425979968,'ae'),(1425980096,14259801 60,'ae'),(1432346880,1432347136,'ae'),(1432352768, 1432353280,'ae'),(1433616384,1433624576,'ae'),(144 1562624,1441570816,'ae'),(1446903808,1446920192,'a e'),(1449132032,1449394176,'ae'),(1472724992,14728 56064,'ae'),(1475207168,1475209216,'ae'),(14759526 40,1475953152,'ae'),(1484038244,1484038248,'ae'),( 1496178944,1496179200,'ae'),(1506455808,1506456064 ,'ae'),(1531445248,1531707392,'ae'),(1533420288,15 33420544,'ae');
INSERT INTO `country` VALUES (1533442048,1533444096,'ae'),(1534129152,153412940 8,'ae'),(1536048128,1536048256,'ae'),(1549795328,1 550057472,'ae'),(3227979264,3227979520,'ae'),(3250 324992,3250325248,'ae'),(3252429616,3252429632,'ae '),(3259302144,3259302400,'ae'),(3262472432,326247 2436,'ae'),(3262475792,3262475808,'ae'),(326247810 9,3262478109,'ae'),(3262478382,3262478382,'ae'),(3 262478384,3262478384,'ae'),(3264408576,3264409600, 'ae'),(3265569280,3265569792,'ae'),(3265921024,326 5986560,'ae'),(3277882112,3277882368,'ae'),(327894 3567,3278943567,'ae'),(3286564864,3286630400,'ae') ,(3288548096,3288548352,'ae'),(3288548352,32885493 76,'ae'),(3557173696,3557173704,'ae'),(3557174784, 3557175040,'ae'),(3557960976,3557960984,'ae'),(355 7961376,3557961408,'ae'),(3560942940,3560942944,'a e'),(3564862864,3564862872,'ae'),(3576299520,35763 65056,'ae'),(3582205952,3582214144,'ae'),(35872885 76,3587288704,'ae'),(3590156960,3590156992,'ae'),( 3590319104,3590319136,'ae'),(3590319136,3590319152 ,'ae'),(3590319152,3590319160,'ae'),(3590319160,35 90319164,'ae'),(3590319164,3590319166,'ae'),(35903 19168,3590319232,'ae'),(3590319232,3590319360,'ae' ),(3590319376,3590319392,'ae'),(3590319424,3590319 488,'ae'),(3590319488,3590319616,'ae'),(3590319616 ,3590319872,'ae'),(3590319872,3590320000,'ae'),(35 90320000,3590320064,'ae'),(3590320064,3590320096,' ae'),(3590320096,3590320112,'ae'),(3590320112,3590 320112,'ae'),(3642265600,3642269696,'ae'),(3645764 045,3645764045,'ae'),(3651403776,3651534848,'ae'), (3651952640,3651960832,'ae'),(3653744896,365374496 0,'ae'),(982745088,982753280,'af'),(1049547296,104 9547328,'af'),(1347293584,1347293592,'af'),(134729 5056,1347295064,'af'),(1358400256,1358400512,'af') ,(1389215232,1389215744,'af'),(1389215744,13892177 92,'af'),(1389218304,1389218816,'af'),(1389218816, 1389219840,'af'),(1389229568,1389229696,'af'),(141 0013824,1410013888,'af'),(1410015488,1410015744,'a f'),(1410027264,1410027520,'af'),(1475957760,14759 58016,'af'),(1546091520,1546091648,'af'),(19665879 04,1966592000,'af'),(1969807360,1969809408,'af'),( 2000375808,2000377856,'af'),(2033885184,2033887232 ,'af'),(2036609024,2036611072,'af'),(2038374400,20 38382592,'af'),(2111160320,2111168512,'af'),(33927 12704,3392716800,'af'),(3394637824,3394641920,'af' ),(3417185024,3417185280,'af'),(3419873280,3419877 376,'af'),(3528458240,3528474624,'af'),(3564431568 ,3564431584,'af'),(3641353984,3641354240,'af'),(36 53472280,3653472288,'af'),(3653472288,3653472292,' af'),(1160921088,1160925184,'ag'),(1161420800,1161 428992,'ag'),(1280090112,1280098304,'ag'),(3495120 896,3495122944,'ag'),(3510321152,3510337536,'ag'), (3649709296,3649709312,'ag'),(3423533056,342353510 4,'ai'),(3493998592,3494000640,'ai'),(1045119232,1 045119488,'al'),(1045119488,1045119744,'al'),(1307 709440,1307713536,'al'),(1331851264,1331853312,'al '),(1332346880,1332412416,'al'),(1336619008,133662 1056,'al'),(1347305472,1347309568,'al'),(134809600 0,1348100096,'al'),(1348169728,1348173824,'al'),(1 361037876,1361037880,'al'),(1410613248,1410621440, 'al'),(1432255488,1432256512,'al'),(1547440128,154 7444224,'al'),(1566195712,1566199808,'al'),(325243 9552,3252439584,'al'),(3254649088,3254649344,'al') ,(3254649344,3254649856,'al'),(3254883584,32548838 40,'al'),(3583337728,3583337984,'al'),(3583338816, 3583338832,'al'),(3583339520,3583340032,'al'),(358 3340032,3583340288,'al'),(3583341040,3583341056,'a l'),(3583341056,3583341312,'al'),(3587121152,35871 29344,'al'),(3587290368,3587290432,'al'),(35872919 68,3587292032,'al'),(3642290176,3642294272,'al'),( 1042300224,1042300256,'am'),(1046020096,1046028288 ,'am'),(1298118656,1298120704,'am'),(1315782656,13 15786752,'am'),(1336592384,1336594432,'am'),(13478 70720,1347874816,'am'),(1357372928,1357373184,'am' ),(1364840448,1364844544,'am'),(1401618432,1401634 816,'am'),(1406787584,1406795776,'am'),(1407547912 ,1407547920,'am'),(1438876160,1438876416,'am'),(14 38880256,1438880512,'am'),(1438883584,1438883840,' am'),(1438884864,1438885888,'am'),(1475444736,1475 461120,'am');
INSERT INTO `country` VALUES (1509539840,1509543936,'am'),(1533483008,153348505 6,'am'),(1533491200,1533493248,'am'),(1539580928,1 539581952,'am'),(1539766016,1539766272,'am'),(1539 778048,1539778304,'am'),(1539826176,1539826432,'am '),(1546356736,1546358784,'am'),(1566496768,156649 8816,'am'),(3251143168,3251143424,'am'),(325326540 8,3253265920,'am'),(3259226624,3259227136,'am'),(3 275509888,3275509920,'am'),(3282749184,3282749440, 'am'),(3287957504,3287965696,'am'),(3559571456,355 9579648,'am'),(3561570304,3561578496,'am'),(358441 2160,3584412416,'am'),(3587186944,3587187200,'am') ,(3590309544,3590309552,'am'),(3590321920,35903219 28,'am'),(3648061440,3648069632,'am'),(3653404136, 3653404144,'am'),(3653404752,3653404760,'am'),(365 3404984,3653404992,'am'),(3653405120,3653405136,'a m'),(1426855808,1426855936,'an'),(3187834880,31878 51264,'an'),(3187949568,3187953664,'an'),(31879659 52,3187974144,'an'),(3193438208,3193454592,'an'),( 3193503744,3193569280,'an'),(3194355712,3194359808 ,'an'),(3199795200,3199811584,'an'),(3262478632,32 62478632,'an'),(3272086976,3272087040,'an'),(32789 45028,3278945032,'an'),(3278945532,3278945536,'an' ),(3281359072,3281359104,'an'),(3288535040,3288539 136,'an'),(3355850752,3355852800,'an'),(3355873280 ,3355875328,'an'),(3355910144,3355918336,'an'),(33 55949056,3355951104,'an'),(3357196288,3357212672,' an'),(3360159744,3360161792,'an'),(3363602432,3363 610624,'an'),(3386392576,3386408960,'an'),(3386638 336,3386642432,'an'),(3386777600,3386781696,'an'), (3560947356,3560947360,'an'),(3633881088,363388518 4,'an'),(701308928,701317120,'ao'),(701677568,7016 93952,'ao'),(702410752,702414848,'ao'),(702475264, 702476288,'ao'),(702478336,702480384,'ao'),(702480 384,702481408,'ao'),(702490624,702491648,'ao'),(70 2505984,702507008,'ao'),(702520320,702521344,'ao') ,(702522368,702523392,'ao'),(1043895984,1043896000 ,'ao'),(1317668344,1317668352,'ao'),(1347979328,13 47979336,'ao'),(1347980072,1347980080,'ao'),(14075 19016,1407519024,'ao'),(1407519032,1407519040,'ao' ),(1407519040,1407519048,'ao'),(1407520728,1407520 736,'ao'),(1407534392,1407534400,'ao'),(1407536920 ,1407536928,'ao'),(1407536928,1407536936,'ao'),(14 07536944,1407536952,'ao'),(1407539088,1407539096,' ao'),(1407542608,1407542616,'ao'),(1407547184,1407 547192,'ao'),(1407547208,1407547216,'ao'),(1546090 880,1546091008,'ao'),(3252425472,3252425536,'ao'), (3252425536,3252425544,'ao'),(3253469184,325347123 2,'ao'),(3262478121,3262478121,'ao'),(3262478347,3 262478347,'ao'),(3272085504,3272086016,'ao'),(3272 086528,3272086656,'ao'),(3272086832,3272086848,'ao '),(3272086848,3272086880,'ao'),(3272087296,327208 7552,'ao'),(3278939592,3278939596,'ao'),(327893975 6,3278939760,'ao'),(3290284032,3290288128,'ao'),(3 290480640,3290482688,'ao'),(3291324416,3291325440, 'ao'),(3291367424,3291369472,'ao'),(3301637120,330 1638144,'ao'),(3302949120,3302949376,'ao'),(358583 7568,3585838080,'ao'),(3585838080,3585838144,'ao') ,(3585838248,3585838256,'ao'),(3585838272,35858382 80,'ao'),(3585838296,3585838304,'ao'),(3590309512, 3590309520,'ao'),(3590309576,3590309584,'ao'),(359 0316096,3590316128,'ao'),(3590322024,3590322032,'a o'),(3590322400,3590322416,'ao'),(3641355264,36413 55520,'ao'),(3642028320,3642028328,'ao'),(36516966 40,3651698688,'ao'),(1438892032,1438908416,'aq'),( 417857536,417923072,'ar'),(1111228416,1111244800,' ar'),(1310247088,1310247104,'ar'),(1310248664,1310 248672,'ar'),(1383239296,1383239424,'ar'),(2361327 616,2361393152,'ar'),(2640052224,2640117760,'ar'), (2713583616,2713649152,'ar'),(2735341568,273540710 4,'ar'),(2818310144,2818375680,'ar'),(2824011776,2 824077312,'ar'),(2824863744,2824929280,'ar'),(2825 191424,2825256960,'ar'),(2833383424,2833448960,'ar '),(2855469056,2855534592,'ar'),(2862284800,286235 0336,'ar'),(2865889280,2865954816,'ar'),(318773657 6,3187752960,'ar'),(3187802112,3187818496,'ar'),(3 187826688,3187830784,'ar'),(3187867648,3187900416, 'ar'),(3187900416,3187908608,'ar'),(3187998720,318 8006912,'ar'),(3188088832,3188092928,'ar'),(318812 9792,3188146176,'ar');
INSERT INTO `country` VALUES (3188187136,3188191232,'ar'),(3188195328,318819942 4,'ar'),(3188260864,3188264960,'ar'),(3188400128,3 188404224,'ar'),(3188416512,3188420608,'ar'),(3188 424704,3188432896,'ar'),(3188441088,3188445184,'ar '),(3188482048,3188490240,'ar'),(3188506624,318852 3008,'ar'),(3188580352,3188584448,'ar'),(318858854 4,3188596736,'ar'),(3188604928,3188621312,'ar'),(3 188629504,3188633600,'ar'),(3188678656,3188682752, 'ar'),(3188703232,3188711424,'ar'),(3188719616,318 8981760,'ar'),(3189637120,3189768192,'ar'),(319081 6768,3191078912,'ar'),(3191275520,3191308288,'ar') ,(3191308288,3191324672,'ar'),(3193733120,31937495 04,'ar'),(3194028032,3194036224,'ar'),(3194126336, 3194134528,'ar'),(3196583936,3196846080,'ar'),(319 8943232,3199205376,'ar'),(3199205376,3199336448,'a r'),(3199467520,3199500288,'ar'),(3199500288,31995 16672,'ar'),(3199664128,3199696896,'ar'),(31999918 08,3200253952,'ar'),(3201433600,3201449984,'ar'),( 3201826816,3201892352,'ar'),(3202088960,3202121728 ,'ar'),(3202351104,3202613248,'ar'),(3203661824,32 03792896,'ar'),(3238239712,3238239744,'ar'),(32624 73016,3262473020,'ar'),(3262473690,3262473692,'ar' ),(3262475308,3262475312,'ar'),(3262476132,3262476 136,'ar'),(3262476352,3262476356,'ar'),(3262476548 ,3262476552,'ar'),(3262477248,3262477252,'ar'),(32 62477448,3262477452,'ar'),(3273055232,3273055488,' ar'),(3278939148,3278939152,'ar'),(3278939264,3278 939272,'ar'),(3278939292,3278939296,'ar'),(3278939 316,3278939320,'ar'),(3278941284,3278941288,'ar'), (3278941344,3278941348,'ar'),(3278941440,327894144 4,'ar'),(3278941848,3278941856,'ar'),(3278944347,3 278944347,'ar'),(3278944361,3278944361,'ar'),(3278 944390,3278944390,'ar'),(3278944538,3278944538,'ar '),(3278944560,3278944560,'ar'),(3278944580,327894 4580,'ar'),(3278944655,3278944655,'ar'),(327894465 6,3278944658,'ar'),(3278944660,3278944660,'ar'),(3 278944664,3278944666,'ar'),(3278944668,3278944668, 'ar'),(3278944688,3278944688,'ar'),(3278944736,327 8944736,'ar'),(3278944755,3278944755,'ar'),(327894 4764,3278944764,'ar'),(3278944820,3278944824,'ar') ,(3278945128,3278945132,'ar'),(3278945172,32789451 76,'ar'),(3278945204,3278945208,'ar'),(3278945268, 3278945272,'ar'),(3278945324,3278945328,'ar'),(327 8945396,3278945400,'ar'),(3278945432,3278945436,'a r'),(3278945508,3278945512,'ar'),(3278945512,32789 45516,'ar'),(3278945536,3278945540,'ar'),(32789455 80,3278945584,'ar'),(3278945660,3278945664,'ar'),( 3278945700,3278945704,'ar'),(3278945724,3278945728 ,'ar'),(3290447872,3290456064,'ar'),(3325142016,33 25142272,'ar'),(3354955776,3354956032,'ar'),(33554 47552,3355447808,'ar'),(3355463424,3355463680,'ar' ),(3355463680,3355463936,'ar'),(3355467776,3355468 800,'ar'),(3355488000,3355488256,'ar'),(3355489536 ,3355489792,'ar'),(3355489792,3355490304,'ar'),(33 55490304,3355492352,'ar'),(3355492352,3355494400,' ar'),(3355494400,3355494656,'ar'),(3355496448,3355 498496,'ar'),(3355500544,3355508736,'ar'),(3355516 928,3355525120,'ar'),(3355538432,3355538944,'ar'), (3355538944,3355539200,'ar'),(3355566080,335557427 2,'ar'),(3355604992,3355607040,'ar'),(3355648000,3 355656192,'ar'),(3355656192,3355664384,'ar'),(3355 664384,3355668480,'ar'),(3355668480,3355668992,'ar '),(3355669248,3355669504,'ar'),(3355669504,335567 0528,'ar'),(3355670528,3355672576,'ar'),(335568281 6,3355684864,'ar'),(3355686912,3355688960,'ar'),(3 355695104,3355697152,'ar'),(3355720448,3355720704, 'ar'),(3355779072,3355781120,'ar'),(3355783168,335 5785216,'ar'),(3355787264,3355803648,'ar'),(335582 0032,3355836416,'ar'),(3355871232,3355873280,'ar') ,(3355934720,3355938816,'ar'),(3355947008,33559490 56,'ar'),(3356052224,3356052480,'ar'),(3356070656, 3356070912,'ar'),(3356082688,3356082944,'ar'),(335 6086272,3356086528,'ar'),(3356087296,3356087808,'a r'),(3356089088,3356089344,'ar'),(3356091136,33560 91392,'ar'),(3356093184,3356093440,'ar'),(33560934 40,3356093952,'ar'),(3356094976,3356095488,'ar'),( 3356095488,3356096000,'ar'),(3356096000,3356096256 ,'ar'),(3356097792,3356098048,'ar'),(3356098048,33 56098304,'ar');
INSERT INTO `country` VALUES (3356123136,3356131328,'ar'),(3356131328,335613184 0,'ar'),(3356134144,3356134400,'ar'),(3356134400,3 356134656,'ar'),(3356139776,3356140032,'ar'),(3356 146176,3356146432,'ar'),(3356148736,3356148992,'ar '),(3356149504,3356149760,'ar'),(3356150016,335615 0272,'ar'),(3356150272,3356150528,'ar'),(335615078 4,3356151040,'ar'),(3356151552,3356151808,'ar'),(3 356154624,3356154880,'ar'),(3356192768,3356194816, 'ar'),(3356263680,3356263936,'ar'),(3356263936,335 6264448,'ar'),(3356264448,3356264960,'ar'),(335626 4960,3356265216,'ar'),(3356269056,3356269312,'ar') ,(3356280832,3356282880,'ar'),(3356284928,33562869 76,'ar'),(3356305664,3356305920,'ar'),(3356495872, 3356499968,'ar'),(3356508160,3356508672,'ar'),(335 6510208,3356511232,'ar'),(3356511232,3356511744,'a r'),(3356511744,3356512000,'ar'),(3356512256,33565 14304,'ar'),(3356516352,3356520448,'ar'),(33565214 72,3356521728,'ar'),(3356522496,3356524544,'ar'),( 3356524544,3356557312,'ar'),(3357077504,3357081600 ,'ar'),(3357147136,3357179904,'ar'),(3357194240,33 57196288,'ar'),(3357407232,3357409280,'ar'),(33574 74816,3357483008,'ar'),(3357532160,3357536256,'ar' ),(3357540352,3357573120,'ar'),(3357573120,3357581 312,'ar'),(3358130176,3358195712,'ar'),(3358195712 ,3358228480,'ar'),(3358228480,3358236672,'ar'),(33 58261248,3358326784,'ar'),(3358392320,3358457856,' ar'),(3358523392,3358588928,'ar'),(3358654464,3358 658560,'ar'),(3358660608,3358662656,'ar'),(3358666 752,3358670848,'ar'),(3358670848,3358687232,'ar'), (3358687232,3358695424,'ar'),(3358703616,335871180 8,'ar'),(3358711808,3358715904,'ar'),(3358717952,3 358720000,'ar'),(3358760960,3358769152,'ar'),(3358 781440,3358785536,'ar'),(3358785536,3358851072,'ar '),(3359047680,3359080448,'ar'),(3359272960,335927 7056,'ar'),(3359309824,3359313920,'ar'),(335931801 6,3359326208,'ar'),(3359326208,3359342592,'ar'),(3 359342592,3359350784,'ar'),(3359350784,3359354880, 'ar'),(3359358976,3359363072,'ar'),(3359367168,335 9371264,'ar'),(3359440896,3359473664,'ar'),(335948 1856,3359490048,'ar'),(3359490048,3359498240,'ar') ,(3359571968,3359580160,'ar'),(3359580160,33595822 08,'ar'),(3359584256,3359586304,'ar'),(3359588352, 3359596544,'ar'),(3359604736,3359621120,'ar'),(335 9916032,3359932416,'ar'),(3359948800,3359965184,'a r'),(3359965184,3359981568,'ar'),(3359981568,33599 89760,'ar'),(3359997952,3360006144,'ar'),(33600143 36,3360030720,'ar'),(3360030720,3360096256,'ar'),( 3360153600,3360157696,'ar'),(3360256000,3360258048 ,'ar'),(3360260096,3360276480,'ar'),(3360702464,33 60710656,'ar'),(3360718848,3360751616,'ar'),(33607 51616,3360759808,'ar'),(3360759808,3360763904,'ar' ),(3360768000,3360776192,'ar'),(3360776192,3360780 288,'ar'),(3360784384,3360788480,'ar'),(3360792576 ,3360796672,'ar'),(3360800768,3360817152,'ar'),(33 60817152,3360849920,'ar'),(3361038336,3361046528,' ar'),(3361308672,3361325056,'ar'),(3362324480,3362 340864,'ar'),(3362340864,3362349056,'ar'),(3362484 224,3362486272,'ar'),(3362506752,3362508800,'ar'), (3362512896,3362514944,'ar'),(3362537472,336254566 4,'ar'),(3362693120,3362695168,'ar'),(3362697216,3 362701312,'ar'),(3362701312,3362703360,'ar'),(3362 705408,3362709504,'ar'),(3362709504,3362711552,'ar '),(3362816000,3362832384,'ar'),(3362947072,336297 9840,'ar'),(3362979840,3362983936,'ar'),(336302899 2,3363045376,'ar'),(3363110912,3363176448,'ar'),(3 363438592,3363471360,'ar'),(3363520512,3363536896, 'ar'),(3363536896,3363553280,'ar'),(3363553280,336 3557376,'ar'),(3363651584,3363667968,'ar'),(336373 3504,3363766272,'ar'),(3363766272,3363831808,'ar') ,(3386114048,3386245120,'ar'),(3386425344,33864417 28,'ar'),(3386589184,3386597376,'ar'),(3386679296, 3386683392,'ar'),(3386728448,3386732544,'ar'),(338 7359232,3387424768,'ar'),(3387555840,3387686912,'a r'),(3388604416,3388735488,'ar'),(3388735488,33889 97632,'ar'),(3507290112,3507355648,'ar'),(35129835 52,3512987648,'ar'),(3558368016,3558368032,'ar'),( 3558368240,3558368256,'ar'),(3558368320,3558368384 ,'ar'),(3560944164,3560944168,'ar'),(3560944316,35 60944320,'ar');
INSERT INTO `country` VALUES (3560944320,3560944324,'ar'),(3560944364,356094436 8,'ar'),(3560944376,3560944380,'ar'),(3560944460,3 560944460,'ar'),(3560944476,3560944480,'ar'),(3560 945728,3560945732,'ar'),(3560945748,3560945752,'ar '),(3560945764,3560945768,'ar'),(3560945792,356094 5796,'ar'),(3560945816,3560945820,'ar'),(356094619 0,3560946190,'ar'),(3560946199,3560946199,'ar'),(3 560946230,3560946230,'ar'),(3560946238,3560946238, 'ar'),(3560946260,3560946260,'ar'),(3560946263,356 0946263,'ar'),(3560946344,3560946344,'ar'),(356094 6500,3560946504,'ar'),(3560946588,3560946592,'ar') ,(3560946604,3560946608,'ar'),(3560946644,35609466 48,'ar'),(3560946717,3560946717,'ar'),(3560946964, 3560946968,'ar'),(3560947016,3560947020,'ar'),(356 0947068,3560947072,'ar'),(3560947276,3560947280,'a r'),(3560947400,3560947408,'ar'),(3560947412,35609 47416,'ar'),(3639918592,3639934976,'ar'),(33936138 24,3393617920,'as'),(3557597712,3557597720,'as'),( 1041088512,1041096704,'at'),(1041945088,1041945152 ,'at'),(1042841600,1042874368,'at'),(1043202048,10 43333120,'at'),(1043350588,1043350592,'at'),(10436 09280,1043609344,'at'),(1045138432,1045138464,'at' ),(1046298624,1046315008,'at'),(1046708224,1046740 992,'at'),(1047560764,1047560768,'at'),(1047566848 ,1047566852,'at'),(1047566868,1047566872,'at'),(10 47567040,1047567044,'at'),(1047567164,1047567168,' at'),(1047567316,1047567320,'at'),(1047567452,1047 567456,'at'),(1047567876,1047567880,'at'),(1047789 568,1047822336,'at'),(1048844352,1048844384,'at'), (1049370624,1049378816,'at'),(1049405632,104940569 6,'at'),(1049768176,1049768192,'at'),(1049771904,1 049771968,'at'),(1049776696,1049776704,'at'),(1049 778536,1049778544,'at'),(1049785000,1049785008,'at '),(1050625960,1050625968,'at'),(1051852800,105191 8336,'at'),(1051949312,1051949568,'at'),(105225779 2,1052258304,'at'),(1052260632,1052260640,'at'),(1 052272544,1052272576,'at'),(1052275200,1052275712, 'at'),(1052278832,1052278848,'at'),(1052288304,105 2288320,'at'),(1052288512,1052289024,'at'),(105231 0784,1052311040,'at'),(1052315104,1052315136,'at') ,(1052325200,1052325216,'at'),(1052331616,10523316 48,'at'),(1052335552,1052335616,'at'),(1052340224, 1052340480,'at'),(1052340480,1052340512,'at'),(105 2340512,1052340528,'at'),(1052340736,1052340768,'a t'),(1052340864,1052340992,'at'),(1052340992,10523 41248,'at'),(1052341504,1052341760,'at'),(10523417 60,1052342272,'at'),(1052345536,1052345552,'at'),( 1052345728,1052345856,'at'),(1052358496,1052358512 ,'at'),(1052401312,1052401344,'at'),(1052405760,10 52406784,'at'),(1052406784,1052407296,'at'),(10524 07296,1052407424,'at'),(1052407424,1052407488,'at' ),(1052407488,1052407520,'at'),(1052407552,1052407 808,'at'),(1052407808,1052407840,'at'),(1052407936 ,1052408064,'at'),(1052408064,1052408128,'at'),(10 52408128,1052408160,'at'),(1052408576,1052408832,' at'),(1052417088,1052417120,'at'),(1052427872,1052 427904,'at'),(1052438528,1052439040,'at'),(1052439 040,1052439296,'at'),(1052439296,1052439424,'at'), (1052439424,1052439488,'at'),(1052439488,105243950 4,'at'),(1052439520,1052439552,'at'),(1052453376,1 052453888,'at'),(1052457984,1052458240,'at'),(1052 458240,1052458368,'at'),(1052458432,1052458496,'at '),(1052487424,1052487680,'at'),(1052490752,105249 1264,'at'),(1052491264,1052491520,'at'),(105249152 0,1052491648,'at'),(1052491648,1052491680,'at'),(1 052491688,1052491696,'at'),(1052491696,1052491712, 'at'),(1052491712,1052491776,'at'),(1053294848,105 3295104,'at'),(1053295392,1053295424,'at'),(105329 5424,1053295456,'at'),(1053295456,1053295472,'at') ,(1053295616,1053296640,'at'),(1053339648,10533401 60,'at'),(1054121984,1054130176,'at'),(1054474240, 1054539776,'at'),(1054969032,1054969040,'at'),(105 6522240,1056538624,'at'),(1296605184,1296607232,'a t'),(1296715776,1296717824,'at'),(1296723968,12967 26016,'at'),(1296764928,1296766976,'at'),(12976087 04,1297610752,'at'),(1299447808,1299709952,'at'),( 1306288128,1306296320,'at'),(1307262976,1307271168 ,'at'),(1307385856,1307394048,'at'),(1307721728,13 07725824,'at');
/*!40000 ALTER TABLE `country` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2008-04-20 5:31:09
drop table if exists tmpcountry;
CREATE TABLE `tmpcountry` (
`id` int unsigned NOT NULL auto_increment,
`ip_line` linestring NOT NULL,
`low` int unsigned NOT NULL,
`high` int unsigned NOT NULL,
`country` char(2) NOT NULL default '-',
PRIMARY KEY (`id`),
SPATIAL INDEX (`ip_line`)
);
INSERT INTO tmpcountry (low,high,country,ip_line)
SELECT low, high, country, LineString(POINT(low,0), POINT(high,0)) FROM country;
 

Thread Tools




All times are GMT. The time now is 12:33 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org