Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Seva Feldman
    @felka
    main DB connection fails on broken views
    BI does not connect at all(I prefer to resolve this problem)
    Victor Olex
    @agilevic
    can you create another database user that does not have any GRANT statements to those broken views? this way only objects, which you want in the API will be reflected.
    so, let's work on the BI schema
    whatever you want to resolve first
    @mdobrzanski please create an issue to see if we can improve the Autodiscovery so that broken objects are skipped
    Seva Feldman
    @felka
    BI:
    alternate_key: {}
    autoconnect: true
    autoload: true
    autoload_user: {dbpass: password, dbuser: app}
    connection: 10.10.2.102:3306/BI
    creator: admin
    db_encoding: utf-8
    db_id: BI
    db_schema: BI
    db_type: mysql
    desc: ''
    excluded_columns: {}
    execute: []
    foreign_keys: {}
    read: []
    write: []
    this is DB definition from databases.conf
    looks good
    Victor Olex
    @agilevic
    looks fine, maybe db_schema is unnecesarry
    from what I recall in MySQL there are no "schemas" just databases
    Seva Feldman
    @felka

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql> use bi;
    ERROR 1049 (42000): Unknown database 'bi'
    mysql> use BI;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Database changed
    mysql>

    this is mysql client output
    so you can see BI db exists
    Victor Olex
    @agilevic
    yes, I can see that
    any clues in /var/log/slashdb ?
    Seva Feldman
    @felka
    Couldn't load model BI due to OperationalError. (_mysql_exceptions.OperationalError) (1049, "Unknown database 'bi'") [SQL: u'SHOW FULL TABLES FROM bi'] (Background on this error at: http://sqlalche.me/e/e3q8)
    that is . an output . from UI
    Victor Olex
    @agilevic
    oi
    ok
    Seva Feldman
    @felka
    no you can see bi in lower case . while defined in upper case
    Victor Olex
    @agilevic
    yes, I see that.
    I am not sure why it changes to lower case
    Seva Feldman
    @felka
    is there a cache for DB configuration?
    Victor Olex
    @agilevic
    let's disconnect, clear the schema field from the db config screen and connect again
    Seva Feldman
    @felka
    ok
    changed it to null
    ok?
    Victor Olex
    @agilevic
    word "null" or just left empty form?
    Michal Dobrzanski
    @mdobrzanski
    I've tried with mysql on our beta and the error message contained database name with letter case preserved.
    Seva Feldman
    @felka
    i see that proper value is null not empty
    ok after putting null in schema connection and autodiscovery worked
    Michal Dobrzanski
    @mdobrzanski
    @felka, have you disconnected and connected again after making changes to config?
    Victor Olex
    @agilevic
    OK, good
    so they entry into the schema was the problem
    Seva Feldman
    @felka
    look like
    Victor Olex
    @agilevic
    @felka you are confusing me with this null. are you editing the yaml file by hand or using the gui?
    Seva Feldman
    @felka
    by hand
    Victor Olex
    @agilevic
    @mdobrzanski another ticket - hide the schame field when MySQL is database type
    Michal Dobrzanski
    @mdobrzanski
    It's hidden...
    Victor Olex
    @agilevic
    OK
    so @felka , when you edit this by hand you have restart the service
    Seva Feldman
    @felka
    it is hidden in UI but populated in conf file
    Victor Olex
    @agilevic
    I mean you don't HAVE to but the behavior is not certain
    @felka I see. interesting how it got there in the first place
    Seva Feldman
    @felka
    it is populated
    i will create new connection
    Victor Olex
    @agilevic
    yeah, let's do that
    also let's dot this first
    service slashdb restart