PrevHomeProLinga TutorialNext

Create the data source

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 databaseDefine application in the Administrator >>