ProLinga Tutorial |
---|
ProLinga uses gnome-db (libgda) technologies to connect to data providers as PostgreSQL and MySQL.
To be able to connect to a database, a Data
Source needs to be created that holds details as database name, user name, tcp port etc. The easiest way
to create this is to run the gnome-db utility gnome-database-properties
that comes as
part of the libgnomedb package. Make sure you run this application as the user that will run the ProLinga
environment, or for ProLinga Networked configurations, the user that started the
prolingadatd
daemon. Go to the command line and type:
gnome-database-properties
This brings up the gnomedb database properties tool. Click on the tab 'Providers' and check that your data provider is in this list. In this tuturial examples for both PostgreSQL as MySQL will be given. If there is no such entry, make sure that you have installed the libgda and gda-postgres packages as outlined in the ProLinga Installation Instructions.
Click on the tab 'Data Sources' where you will see a list of configured data sources. If this is the first time you run this tool, this list is probably empty or contains just a 1 'Default' entry.
Go to pulldown menu 'File' and click 'New'. This will start a druid that guides you through a series of screens to collect all the data needed. Click 'Forward'. On the screen 'General Information', enter the following details to create a data source to run the ProLinga demo applications netadm:
Data source name : netadm
Provider : PostgreSQL/MySQL
Description : ProLinga Tutorial Application
Username : (leave blank)
Password : (leave blank)
Click 'Forward'. Fill out the fields on screen Provider Parameters as outlined below. Where no data is given, leave the field blank.
The values for PostgreSQL
DATABASE: netadm
SEARCHPATH:
HOST: localhost
HOSTADDR: 127.0.0.1
OPTIONS:
PASSWORD:
PORT: 5432
REQUIRESSL:
TTY:
USER: prolinga
The values for MySQL
Database Name: netadm
Host Name: localhost
Port: 3306
UNIX Socket:
Use Secure Connection:
Click 'Forward' and then 'Apply' to confirm all changes and to create the Data Source.
<< Preparation of MySQL database | Define application in the Administrator >> |