Error: No section: 'default' in Robot Framework using DatabaseLibrary

Question

I am using Robot Framework with Database Library to test database queries on localhost. I am running it by XAMPP.
This is my test case:

*** Settings ***
Library           DatabaseLibrary

*** Variables ***
@{DB}             robotframework    root    \    localhost    3306

*** Test Cases ***
Select from database
    [Tags]    This
    Connect To Database    MySQLdb    @{DB}[0]    @{DB}[1]    @{DB}[2]    @{DB}[3]    @{DB}[4]
    @{results}=    Query    Select * From tbName
    Log Many    @{results}

I have installed MySQLDb for Python 2.7, however, when I run it using pybot, it keeps returning error:
Select from database | FAIL |
NoSectionError: No section: 'default'
Please help me to solve this problem. Thanks.

I think that you have your arguments a little muddled, can you make sure that the details fit the spec: dbapiModuleName=None, dbName=None, dbUsername=None, dbPassword=None, dbHost=localhost, dbPort=5432, dbConfigFile=./resources/db.cfg — LeonH
– LeonH, Commented Aug 8, 2014 at 8:46

alpert · Accepted Answer · 2015-08-28 08:23:14Z

3

You should check the content of dbConfigFile. You don't specify one so the default one is ./resources/db.cfg.

The error says when python try to parse that file it cannot find a section named default. In documentation it says:

note: specifying dbapiModuleName, dbName dbUsername or dbPassword directly will override the properties of the same key in dbConfigFile

so even if you specify all properties it reads config file.

answered Aug 28, 2015 at 8:23

alpert

4,6751 gold badge21 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error: No section: 'default' in Robot Framework using DatabaseLibrary

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related