[Qgis-user] SPIT crashes in QGIS 2.1 & 2.0

[Víctor Manuel Herreros Villanueva]

Hello all,

I've been trying QGIS Dufour and I've realized about a problem in Ubuntu
versions of QGIS 2 (Windows versions don't suffer this problem).

When trying to import local shape files into PostGIS database through SPIT
plugin, if you select more than two shape files then QGIS silently closes.
If you select just one or two files then the import process runs smoothly.
The problem is not due to badly-formed shape files, cause I'm able to
import all of them one by one, and then use them in a QGIS project.

This is the environment I'm using:

   - Operating System and version: Ubuntu 12.04.3 LTS precise on 64bit
   Oracle Virtualbox virtual machine platform.
   - QGIS version: 2.1.0-Master (though I got the same behaviour on stable
   QGIS 2.0.1).
   - PostGIS version: PostgreSQL 9.3.0.1 plus PostGIS 2.1.0-2.
   - QGIS installed by apt-get from http://qgis.org/debian-nightly.
   - At what time did it break: When trying to import more than two shape
   files into PostGIS through SPIT plugin. It doesn't matter wether you have
   an open project or you've just started your QGIS sessions with a blank new
   project.
   - What exactly is the error: QGIS  closes without further notification.
   It leaves a crash file in /var/crash/, whose apport-retrace output can be
   get on this link:
   
http://www.mediafire.com/view/8n8e8qjrbulx0m1/_usr_bin_qgis.bin.1000.crash_retrace
   .

Has anybody experienced sucha failure or found any solution?


Thanks in advance.



   *Universidad Complutense de Madrid*
*Víctor Manuel Herreros Villanueva*, PhD.
Project Manager  *Facilities Management
Data Warehouse*
 Jardín Botánico
Av. Complutense s/n
28040 Madrid
Spain  *Phn. no. (+34) 91 394 7275
Fax no.  (+34) 91 394 4773*  vherre...@ucm.es
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] SPIT: new conection and database

[Agustin Lobo]

As far as I'm seeing, the database that
has to be entered in the New Connection panel
of SPIT must have been previously defined.
I did so using createdb following directions in the
book by G. Sherman, but I wonder if
there is a way for defining the database from within QGIS
before using SPIT/New Connection

Thanks,

Agus
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] SPIT not seeing PostGres SQL Connections

[Agustin Lobo]

Micha,

If I enter "postgres" as user in SPIT, I'm prompted
to enter the password. As user postgres was automatically
set up during the installation, was a password also set up
for it or should I set up one using the same procedure
than the one you indicated for user alobo ?
(things work out with SPIT using user alobo thanks to your directions, this is
just for completeness)

Thanks

Agus


2012/6/11 Agustin Lobo :
> Micha,
>
> Just one question before I try: that password has to be the real
> password or can it be
> an specific password to be used by user alobo for postgres?
> Actually writing a password is very unsecure.
> Thanks
> Agus
>
> 2012/6/11 Micha Silver :
>> On 06/11/2012 12:16 PM, Agustin Lobo wrote:
>>
>> Hi!
>>
>> I've followed (not without pain, see at the end) the example
>> of creating a PostGIS database in G.Sherman book
>> p. 113-121 on ubuntu 10.04.
>> Thus, I have created a database named geospatial_desktop.
>> Nevertheless, when I try to use SPIT to load the data,
>> geospatial_desktop is not listed (actually nothing is listed)
>> in the PostgSQL connections list.
>> Is there any place where I have to tell QGIS the path
>> of the databases?
>>
>> Problems I mentioned:
>> 1. createdb -E UTF8 geospatial_desktop
>> resulted into
>> ident authentication failed for user "alobo"
>> which was solved by modifying /etc/postgresql/8.4/main/pg_hba.conf
>> according to
>> http://stackoverflow.com/questions/2942485/psql-fatal-ident-authentication-failed-for-user-postgres
>>
>> 2. The same command produced a second error:
>> createdb: could not connect to database postgres: FATAL: role  "alobo"
>> does not exist
>>
>> This was solved by running the commands preceded by sudo -i -u postgres,
>> i.e.
>>
>> sudo -i -u postgres createdb -E UTF8 geospatial_desktop
>>
>> as mentioned in
>> http://ubuntuforums.org/showthread.php?t=1515069
>>
>> (actually, is it "normal" having to su to user postgres for using postgres?)
>>
>>
>> If this is a local-only database then what you might want to do is create a
>> second superuser with your username, and grant him all privileges. Then go
>> and re-edit the pg_hba.conf to allow this new user access from localhost,
>> and you should be good to go. So:
>>
>> sudo -i -u postgres psql
>> postgres=# CREATE USER alobo WITH LOGIN SUPERUSER PASSWORD 'yourpassword';
>> postgres=# GRANT ALL PRIVILEGES ON geospatial_desktop.* TO alobo WITH GRANT
>> OPTION;
>> postgres=# \q
>>
>> Now put another line into pg_hba.conf
>> host    all            alobo        127.0.0.1/32    trust
>>
>> Restart postgresql and try, as alobo, to connect with psql. If that works
>> then pgAdmin3 and QGIS should be OK.
>>
>> --
>> Micha
>>
>>
>> Agus
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>> This mail was received via Mail-SeCure System.
>>
>>
>>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] SPIT not seeing PostGres SQL Connections

[Agustin Lobo]

Micha,

Just one question before I try: that password has to be the real
password or can it be
an specific password to be used by user alobo for postgres?
Actually writing a password is very unsecure.
Thanks
Agus

2012/6/11 Micha Silver :
> On 06/11/2012 12:16 PM, Agustin Lobo wrote:
>
> Hi!
>
> I've followed (not without pain, see at the end) the example
> of creating a PostGIS database in G.Sherman book
> p. 113-121 on ubuntu 10.04.
> Thus, I have created a database named geospatial_desktop.
> Nevertheless, when I try to use SPIT to load the data,
> geospatial_desktop is not listed (actually nothing is listed)
> in the PostgSQL connections list.
> Is there any place where I have to tell QGIS the path
> of the databases?
>
> Problems I mentioned:
> 1. createdb -E UTF8 geospatial_desktop
> resulted into
> ident authentication failed for user "alobo"
> which was solved by modifying /etc/postgresql/8.4/main/pg_hba.conf
> according to
> http://stackoverflow.com/questions/2942485/psql-fatal-ident-authentication-failed-for-user-postgres
>
> 2. The same command produced a second error:
> createdb: could not connect to database postgres: FATAL: role  "alobo"
> does not exist
>
> This was solved by running the commands preceded by sudo -i -u postgres,
> i.e.
>
> sudo -i -u postgres createdb -E UTF8 geospatial_desktop
>
> as mentioned in
> http://ubuntuforums.org/showthread.php?t=1515069
>
> (actually, is it "normal" having to su to user postgres for using postgres?)
>
>
> If this is a local-only database then what you might want to do is create a
> second superuser with your username, and grant him all privileges. Then go
> and re-edit the pg_hba.conf to allow this new user access from localhost,
> and you should be good to go. So:
>
> sudo -i -u postgres psql
> postgres=# CREATE USER alobo WITH LOGIN SUPERUSER PASSWORD 'yourpassword';
> postgres=# GRANT ALL PRIVILEGES ON geospatial_desktop.* TO alobo WITH GRANT
> OPTION;
> postgres=# \q
>
> Now put another line into pg_hba.conf
> host    all            alobo        127.0.0.1/32    trust
>
> Restart postgresql and try, as alobo, to connect with psql. If that works
> then pgAdmin3 and QGIS should be OK.
>
> --
> Micha
>
>
> Agus
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> This mail was received via Mail-SeCure System.
>
>
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] SPIT not seeing PostGres SQL Connections

[Micha Silver]

  
  
On 06/11/2012 12:16 PM, Agustin Lobo wrote:

  Hi!

I've followed (not without pain, see at the end) the example
of creating a PostGIS database in G.Sherman book
p. 113-121 on ubuntu 10.04.
Thus, I have created a database named geospatial_desktop.
Nevertheless, when I try to use SPIT to load the data,
geospatial_desktop is not listed (actually nothing is listed)
in the PostgSQL connections list.
Is there any place where I have to tell QGIS the path
of the databases?

Problems I mentioned:
1. createdb -E UTF8 geospatial_desktop
resulted into
ident authentication failed for user "alobo"
which was solved by modifying /etc/postgresql/8.4/main/pg_hba.conf
according to
http://stackoverflow.com/questions/2942485/psql-fatal-ident-authentication-failed-for-user-postgres

2. The same command produced a second error:
createdb: could not connect to database postgres: FATAL: role  "alobo"
does not exist

This was solved by running the commands preceded by sudo -i -u postgres, i.e.

sudo -i -u postgres createdb -E UTF8 geospatial_desktop

as mentioned in
http://ubuntuforums.org/showthread.php?t=1515069

(actually, is it "normal" having to su to user postgres for using postgres?)


If this is a local-only database then what you might want to do is
create a second superuser with your username, and grant him all
privileges. Then go and re-edit the pg_hba.conf to allow this new
user access from localhost, and you should be good to go. So:

sudo -i -u postgres psql
postgres=# CREATE USER alobo WITH LOGIN SUPERUSER PASSWORD
'yourpassword';
postgres=# GRANT ALL PRIVILEGES ON geospatial_desktop.* TO alobo
WITH GRANT OPTION;
postgres=# \q

Now put another line into pg_hba.conf
host    all            alobo        127.0.0.1/32    trust

Restart postgresql and try, as alobo, to connect with psql. If that
works then pgAdmin3 and QGIS should be OK.

--
Micha


  

Agus
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

This mail was received via Mail-SeCure System.






  

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] SPIT not seeing PostGres SQL Connections

[Agustin Lobo]

Hi!

I've followed (not without pain, see at the end) the example
of creating a PostGIS database in G.Sherman book
p. 113-121 on ubuntu 10.04.
Thus, I have created a database named geospatial_desktop.
Nevertheless, when I try to use SPIT to load the data,
geospatial_desktop is not listed (actually nothing is listed)
in the PostgSQL connections list.
Is there any place where I have to tell QGIS the path
of the databases?

Problems I mentioned:
1. createdb -E UTF8 geospatial_desktop
resulted into
ident authentication failed for user "alobo"
which was solved by modifying /etc/postgresql/8.4/main/pg_hba.conf
according to
http://stackoverflow.com/questions/2942485/psql-fatal-ident-authentication-failed-for-user-postgres

2. The same command produced a second error:
createdb: could not connect to database postgres: FATAL: role  "alobo"
does not exist

This was solved by running the commands preceded by sudo -i -u postgres, i.e.

sudo -i -u postgres createdb -E UTF8 geospatial_desktop

as mentioned in
http://ubuntuforums.org/showthread.php?t=1515069

(actually, is it "normal" having to su to user postgres for using postgres?)

Agus
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Spit removing decimal places?

[Darren Norris]

With QGIS 1.2 .0 Daphnis, standalone install, windows vista.
PostgreSQL 8.4, PostGIS 1.4.0.

Does any one know if Spit intentionally limits accuracy to 4 decimal 
places (looks like values are getting truncated)?
I am importing a shape file of points (sample of .dbf and resulting 
values from the created database table below).

But I need more accurate values.
Is it possible to get Spit to carry over values to a user specified 
accuracy? Or is this a result of PostGIS settings?

Many thanks for any suggestions.
Darren

Coordinates from .dbf file
-45.08601700,-23.32381800
-45.08600200,   -23.32382700
-45.08598600,-23.32383600
-45.08597100,-23.32384500
-45.08595500,-23.32385400
-45.08593900,-23.32386300
-45.08592400,-23.32387200
-45.08590800,   -23.32388100
-45.08589300,-23.32389000
-45.08587700,-23.32389900
-45.08586100,-23.32390800
-45.08584600,-23.32391700
-45.08583000,-23.32392600
-45.08581400,-23.32393500
-45.08579900,-23.32394400
-45.08578300,-23.32395300
-45.08576800,-23.32396200
-45.08575200,-23.32397100
-45.08573600,-23.32398000
-45.08572100,-23.32398900
-45.08570500,-23.32399800
-45.08569000,-23.32400700

Coordinates as imported via SPIT plugin.
-45.086,-23.3238
-45.086,-23.3238
-45.086,-23.3238
-45.086,-23.3238
-45.086,-23.3239
-45.0859,-23.3239
-45.0859,-23.3239
-45.0859,-23.3239
-45.0859,-23.3239
-45.0859,-23.3239
-45.0859,-23.3239
-45.0858,-23.3239
-45.0858,-23.3239
-45.0858,-23.3239
-45.0858,-23.3239
-45.0858,-23.324
-45.0858,-23.324
-45.0858,-23.324
-45.0857,-23.324
-45.0857,-23.324
-45.0857,-23.324
-45.0857,-23.324


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] spit

[Peter Bange]

To get people to use Qgis combined with a geospatial database, it is
rather important that Spit works well to import all the shapefiles. Up
to now unfortunately I have often problems with spit. Now I found out
that when a shapefile has both polygons and multipolygons Spit cannot
import them into the postgis database. Is this a known problem ? Does
anyone know a workaround ?

 

Peter Bange

Ecofys Nederland b.v.

tel +316 28 130310

 

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user