[GRASS-user] v.db.connect.all - errors

GRASS GRASS user
1

Hi all

I just tried to change all the vector maps of one location from DBF to SQLite, following this page: https://grasswiki.osgeo.org/wiki/Convert_all_GRASS_6_vector_maps_to_GRASS_7

these are the steps:

first rebuild topology for all vector maps in current mapset

v.build.all

define new default DB connection (switch from DBF to SQLite)

db.connect -d

transfer all attribute tables from DBF to SQLite and clean old DBF tables

v.db.reconnect.all -cd

steps 1 and 2 work fine, but #3 doesn’t v.db.reconnect.all -c
dbmi: db_list_databases() not implemented
dbmi: db_list_databases() not implemented
ERROR: Unable to list databases. Try to define correct connection settings
by db.login.
Traceback (most recent call last):
File “/usr/local/Cellar/grass-70/7.0.3/grass-7.0.3/scripts/v.db.reconnect.all”, line 260, in
sys.exit(main())
File “/usr/local/Cellar/grass-70/7.0.3/grass-7.0.3/scripts/v.db.reconnect.all”, line 188, in main
create_db(new_driver, new_database)
File “/usr/local/Cellar/grass-70/7.0.3/grass-7.0.3/scripts/v.db.reconnect.all”, line 87, in create_db
driver = driver).splitlines():
File “/usr/local/Cellar/grass-70/7.0.3/grass-7.0.3/etc/python/grass/script/core.py”, line 445, in read_command
return handle_errors(returncode, stdout, args, kwargs)
File “/usr/local/Cellar/grass-70/7.0.3/grass-7.0.3/etc/python/grass/script/core.py”, line 312, in handle_errors
returncode=returncode)
grass.exceptions.CalledModuleError: Module run None [‘db.databases’, ‘–q’, ‘driver=sqlite’] ended with error
Process ended with non-zero return code 1. See errors in the (error) output.

I’m running 7.0.3 installed via homebrew on Mac OSX

thanks

Carlos

···

Prof. Carlos Henrique Grohmann
Institute of Energy and Environment - Univ. of São Paulo, Brazil

  • Digital Terrain Analysis | GIS | Remote Sensing -

http://carlosgrohmann.com
http://orcid.org/0000-0001-5073-5572

Can’t stop the signal.

2

On Wed, Apr 13, 2016 at 10:33 PM, Carlos Grohmann
<carlos.grohmann@gmail.com> wrote:

Hi all

I just tried to change all the vector maps of one location from DBF to
SQLite, following this page:
https://grasswiki.osgeo.org/wiki/Convert_all_GRASS_6_vector_maps_to_GRASS_7

these are the steps:

# first rebuild topology for all vector maps in current mapset
v.build.all

# define new default DB connection (switch from DBF to SQLite)
db.connect -d

Can you here please run

db.connect -p

to see what it picked up? (should be sqlite).

# transfer all attribute tables from DBF to SQLite and clean old DBF tables
v.db.reconnect.all -cd

steps 1 and 2 work fine, but #3 doesn't v.db.reconnect.all -c
dbmi: db_list_databases() not implemented
dbmi: db_list_databases() not implemented
ERROR: Unable to list databases. Try to define correct connection settings
       by db.login.

I think that this error got reported in the past on MacOSX:
So it would be important to know where it comes from (hence my
question above to get an idea).

Markus

3

here is the output:

GRASS 7.0.3 (latlong):~ > db.connect -p
driver: sqlite
database: /Volumes/MacintoshHD2/grassdata/latlong/base_maps/sqlite/sqlite.db
schema:
group:
GRASS 7.0.3 (latlong):~ >

thanks

···

On Wed, Apr 13, 2016 at 6:58 PM, Markus Neteler <neteler@osgeo.org> wrote:

On Wed, Apr 13, 2016 at 10:33 PM, Carlos Grohmann
<carlos.grohmann@gmail.com> wrote:

Hi all

I just tried to change all the vector maps of one location from DBF to
SQLite, following this page:
https://grasswiki.osgeo.org/wiki/Convert_all_GRASS_6_vector_maps_to_GRASS_7

these are the steps:

first rebuild topology for all vector maps in current mapset

v.build.all

define new default DB connection (switch from DBF to SQLite)

db.connect -d

Can you here please run

db.connect -p

to see what it picked up? (should be sqlite).

transfer all attribute tables from DBF to SQLite and clean old DBF tables

v.db.reconnect.all -cd

steps 1 and 2 work fine, but #3 doesn’t v.db.reconnect.all -c
dbmi: db_list_databases() not implemented
dbmi: db_list_databases() not implemented
ERROR: Unable to list databases. Try to define correct connection settings
by db.login.

I think that this error got reported in the past on MacOSX:
So it would be important to know where it comes from (hence my
question above to get an idea).

Markus

–

Prof. Carlos Henrique Grohmann
Institute of Energy and Environment - Univ. of São Paulo, Brazil

  • Digital Terrain Analysis | GIS | Remote Sensing -

http://carlosgrohmann.com
http://orcid.org/0000-0001-5073-5572

Can’t stop the signal.