cvm-mysql(8) [debian man page]

cvm-mysql(8)						      System Manager's Manual						      cvm-mysql(8)

NAME

       cvm-mysql - MySQL module

SYNOPSIS

       cvm-mysql

CREDENTIALS

       Pass phrase

DESCRIPTION

       This module queries a MySQL database for the account name, compares the stored pass phrase with the given one using crypt(3).

CONFIGURATION VARIABLES

       CVM_MYSQL_DEFAULT_FILE
	      The  full  path of the defaults file to read if the following variable is set.  If not set, the file $HOME/.my.cnf will be read (the
	      MySQL default).

       CVM_MYSQL_DEFAULT_GROUP
	      If set, the module will read connection default options from the named group in the defaults file as above

       CVM_MYSQL_HOST
	      The hostname or IP of the MySQL server.  If not set, a connection to the local host is assumed.

       CVM_MYSQL_USER
	      The MySQL login ID to connect as.  If not set, the invoking user is assumed.

       CVM_MYSQL_PASS
	      The password for the above user.

       CVM_MYSQL_DB
	      The database name, must be set.

       CVM_MYSQL_PORT
	      The port number for the TCP/IP connection (only used if the server is not local).

       CVM_MYSQL_POSTQ (optional)
	      The SQL query to execute after the credentials have been validated, see cvm-sql(7).

       CVM_MYSQL_PWCMP (optional)
	      The password comparison module to use.

       CVM_MYSQL_SOCKET
	      The path to the socket that should be used for connections to a local server.

       CVM_MYSQL_QUERY (optional)
	      The SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7).

SEE ALSO

       cvm-sql(7), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8),  cvm-benchclient(8),  cvm-checkpassword(8),  cvm-test-
       client(8)

	http://untroubled.org/pwcmp/pwcmp.html
	http://untroubled.org/cvm/cvm.html

																      cvm-mysql(8)

grass-mesql(1grass)						Grass User's Manual					       grass-mesql(1grass)

NAME

       grass-mesql - MySQL embedded driver

       MySQL  embedded	driver	MySQL  embedded  driver  in GRASS MySQL database driver in GRASS enables GRASS to store vector attributes in MySQL
       embedded database without necessity to run MySQL server.

Driver and database name
       GRASS modules require 2 parameters to connect to a database.  Those parameters are 'driver' and 'database'. For MySQL embedded  driver  the
       parameter  'driver'  should  be	set  to value 'mesql'.	The parameter 'database' is a full path to the directory where database tables are
       stored. The best place is a directory in the mapset. The directory must be created before use of the driver. In the name of database it	is
       possible to use 3 variables:

		      $GISDBASE - path to current GISBASE

		      $LOCATION_NAME - name of current location

		      $MAPSET - name of current mapset

       Examples of connection parameters:
	 db.connect driver=mesql database='$GISDBASE/$LOCATION_NAME/$MAPSET/mysql'
	 db.connect driver=mesql database=/home/user1/db

Data types, indexes
       For more informations about supported data types and indexes see the documentation for MySQL (mysql) driver

Database type
       Because	database  closing  was	found  very  slow if InnoDB was used, the InnoDB storage is disabled by default (hardcoded '--skip-innodb'
       server option).

Note
       The embedded server is started with hardcoded '--bootstrap' option to avoid warning about missing mysql.time_zone_leap_second  table.  This
       can be fixed in future.

SEE ALSO

	db.connect, SQL support in GRASS GIS

Credits
       Development of the driver was sponsored by Faunalia (Italy) as part of a project for ATAC.

AUTHOR

       Radim Blazek

       Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
       Help Index

GRASS 6.4.2														       grass-mesql(1grass)