#2230 Request for mysql databases on db1
Closed: Fixed None Opened 8 years ago by jlaska.

= phenomenon =

  • The AutoQA service uses the 'autotest' test harness for scheduling and executing jobs. Autotest needs mysql databases to manage internal data.

= background analysis =

  • There is currently an ''autoqa'' database setup on db1. However, that will be used to store information specific to ''autoqa''.

= implementation recommendation =

  1. DATABASES - two new mysql databases on db1
    • ''autotest_tko''
    • ''autotest_web''
  2. ACCESS -
    • I'll need a new user account to access the databases. Whether there is a single user ''autotest'' with access to both, or a user for each database. I have no preference and am open to recommendations.
    • I'll need administrative rights (whether with the user account created above, or with a special admin user) to create and modify tables.
    • Access to these databases is only needed from ''qa01.phx2.fedoraproject.org''

I have created the databases following the commands at

https://fedoraproject.org/wiki/Install_and_configure_autotest

Please test and let me know if it meets needs.

Databases have been installed. Looks good to user?

Replying to [comment:4 smooge]:

Databases have been installed. Looks good to user?

Thanks for the update smooge. I'm building new .el5 packages now and will deploy and test the database creation shortly.

Replying to [comment:4 smooge]:

Databases have been installed. Looks good to user?

I'm having trouble logging into the databases. Could I be doing something wrong?

{{{

mysql --host=db01 --user=autotest -p autotest_web

Enter password:
ERROR 1045 (28000): Access denied for user 'autotest'@'qa01.phx2.fedoraproject.org' (using password: YES)
}}}

I'm not sure why it's listing '''qa01.phx2''' since that host doesn't exist anymore. Perhaps something with the db ACL's?

All fixed, the permissions have been updated and I'm able to connect and create the required tables. This ticket can be closed. Thanks!

Login to comment on this ticket.

Metadata