| *** bcoca has quit IRC | 00:21 | |
| *** helloweenx_ has joined #ara | 06:51 | |
| *** helloweenx has quit IRC | 06:53 | |
| *** themurph has joined #ara | 07:13 | |
| *** themurph has quit IRC | 07:17 | |
| *** gvincent has joined #ara | 07:34 | |
| *** openstackgerrit has quit IRC | 07:35 | |
| *** sshnaidm_ has joined #ara | 08:59 | |
| helloweenx_ | hey guys, anyone can help me out with finishing configure ARA? I have installed ARA with role in apache mode, i have website running, but database is empty. | 09:01 |
|---|---|---|
| Xaroth | have you configured ansible, and run a play? | 09:08 |
| helloweenx_ | i have my ansible up and running for a few months, configured in ansible.cfg paths to ARA callback (not sure if right) and tried to run some plays | 09:09 |
| Xaroth | is there a ~/.ara folder and a database in there? | 09:13 |
| helloweenx_ | i guess, its ansible.sqlite right? | 09:14 |
| Xaroth | yeah | 09:16 |
| helloweenx_ | well that is present | 09:17 |
| helloweenx_ | in that file i can see some data | 09:17 |
| Xaroth | what you want to do is make sure that your ansible ara config writes to the same database as apache is reading out of | 09:17 |
| Xaroth | as in https://ara.readthedocs.io/en/latest/webserver.html#create-the-ansible-and-ara-configuration | 09:17 |
| helloweenx_ | yea i was going oveer this | 09:18 |
| *** sshnaidm_ has quit IRC | 09:18 | |
| helloweenx_ | so now apache is just not reading the right database, right? | 09:19 |
| Xaroth | most likely | 09:19 |
| helloweenx_ | and i can specify these settings in my ansible.cfg with these variables? https://ara.readthedocs.io/en/latest/configuration.html#parameters-and-their-defaults | 09:22 |
| Xaroth | mhm | 09:25 |
| helloweenx_ | i'm quite puzzled from sqlite settings. isnt it weird that every user have its on DB file in his home folder? shouldnt there be just one main DB file? | 10:00 |
| apollo13 | helloweenx_: switch from sqlite to postgres and tada :D | 10:01 |
| helloweenx_ | oh well if its that easy.. :-D | 10:01 |
| helloweenx_ | so in production environment is recommended to use like mysql or postgresql? | 10:02 |
| *** sshnaidm has joined #ara | 10:06 | |
| *** sshnaidm has quit IRC | 10:12 | |
| *** sshnaidm has joined #ara | 10:58 | |
| helloweenx_ | pretty stupid question.. ara will create tables in db once it tries to write into it or i need to do it by myself? | 11:04 |
| helloweenx_ | i mean in mysql | 11:04 |
| Xaroth | ara-manage createall | 11:21 |
| Xaroth | creates the tables | 11:21 |
| Xaroth | (make sure you tell it where and what etc) | 11:22 |
| helloweenx_ | huh, is this information somewhere in documentation? didnt run into it | 11:22 |
| Xaroth | the createall command? | 11:24 |
| Xaroth | that's just ara-manage -h | 11:24 |
| Xaroth | for the rest: https://ara.readthedocs.io/en/latest/configuration.html#ara | 11:24 |
| helloweenx_ | yea i mean how should i know, there is something like ara-manage? i saw it once in documentation, where it was starting devel server i think | 11:30 |
| Xaroth | Whenever I see a command I try to see what else it can do :P | 11:33 |
| helloweenx_ | hehe, i am working in linux environment for few months, not used to this from windows :-D | 11:35 |
| helloweenx_ | bwt let me correct you, its ara-manage -? :-D | 11:36 |
| Xaroth | in linux land it's usually -h or --help | 11:37 |
| Xaroth | so I try them in that order | 11:37 |
| Xaroth | but yeah, for ara it's --help and -? | 11:37 |
| Xaroth | -h is for the --host option I think | 11:37 |
| helloweenx_ | so my another stupid question would be, how do i tell to ara-manage, that i want create tables in my mysql database.. do i have to edit some cfg file, or i add some parameters that point to mysql db? | 11:41 |
| Xaroth | check the link I pasted, it shows where ara looks for its config | 11:42 |
| helloweenx_ | yea i read whole documentation back and forward many times now :-D so "ara-manage" will use configuration file ara.cfg? | 11:43 |
| Xaroth | try it? I mean, [ara] port = 1234 | 11:44 |
| Xaroth | then ara-manage runserver | 11:44 |
| Xaroth | and see what port it starts on | 11:44 |
| *** sshnaidm_ has joined #ara | 11:50 | |
| *** sshnaidm has quit IRC | 11:53 | |
| *** themurph has joined #ara | 11:54 | |
| helloweenx_ | alright, i'm oficialy lost. Can you please walk through my settings with me and look for mistake i dont see? | 12:22 |
| gundalow | helloweenx_: put them in pastebin or gist (make sure their aren't any passwords) then someone here maybe able to review | 13:07 |
| helloweenx_ | thanks for tip | 13:11 |
| *** jrist has quit IRC | 13:11 | |
| helloweenx_ | so this is my /etc/ara/ara.cfg settings - i have back sqlite, with mysql website just dies.. but i would like to go with mysql definitly | 13:13 |
| helloweenx_ | https://pastebin.com/sp19NxXC | 13:13 |
| *** jrist has joined #ara | 13:13 | |
| helloweenx_ | not really sure what other settings needs to be reviewed | 13:14 |
| helloweenx_ | for mysql i used this default connection string - database = mysql+pymysql://ara:password@localhost/ara | 13:15 |
| Xaroth | why ara.cfg? shouldn't that be /etc/ansible/ansible.cfg ? | 13:15 |
| Xaroth | ara checks the ansible.cfg paths for the [ara] block | 13:15 |
| helloweenx_ | i think ara read this cfg file too, if he dont find it in ansible.cfg | 13:16 |
| Xaroth | fair enough | 13:16 |
| helloweenx_ | but you know, its just what i think, not what i know :-D | 13:16 |
| Xaroth | I'd say try ansible.cfg :) | 13:16 |
| helloweenx_ | alright, on it | 13:16 |
| Xaroth | it uses `find_ini_config_file` from ansible itself | 13:18 |
| Xaroth | so I doubt it'll find an ara.cfg | 13:18 |
| helloweenx_ | so i just moved ara.cfg content into ansible.cfg, tried to delete ara.cfg and there is no change - so now ara is reading ansible.cfg file for sure | 13:24 |
| helloweenx_ | sadly i still have website without connection to right db | 13:24 |
| helloweenx_ | whoa whoa whoa | 13:26 |
| helloweenx_ | its working now, what the hell | 13:26 |
| helloweenx_ | so all i need is just to connect it to mysql instead of sqlite and i wont bother any of you for a while :-D | 13:31 |
| *** tbielawa has joined #ara | 13:32 | |
| *** bcoca has joined #ara | 13:41 | |
| helloweenx_ | so in this connection string: database = mysql+pymysql://ara:password@localhost/ara mysql+pymysql:// is mandatory. ara is username? password i guess will be his password :-D @localhost is server, where is mysql hosted and /ara is database name, is that correct? | 14:22 |
| dmsimard | helloweenx_: yes | 15:23 |
| dmsimard | Xaroth: thanks for helping out! Appreciate it :) | 15:23 |
| dmsimard | helloweenx_: maybe reading this FAQ will help you understand how things work: https://ara.readthedocs.io/en/stable/faq.html#can-ansible-with-ara-run-on-a-different-server-than-the-web-application | 15:25 |
| dmsimard | sqlite vs mysql doesn't matter | 15:25 |
| dmsimard | If your data didn't end up in the web interface, that's likely because Ansible and Apache were not using the same one | 15:26 |
| dmsimard | The database by default is located at ~/.ara/ansible.sqlite, I think the role sets it up in /var/lib/ara so Apache can read from it | 15:27 |
| dmsimard | The most likely cause of your data not being in the UI was likely because of a "disagreement" between apache and your user's configuration | 15:27 |
| dmsimard | mysql is useful if you want to aggregate data from multiple locations or need increased concurrency | 15:28 |
| gnupyx | in my company, Ara write a sqlite At the end of the deployment, pgloader send the data in a postgres | 15:37 |
| dmsimard | gnupyx: so you aggregate data in a central database ? | 15:38 |
| gnupyx | yes | 15:38 |
| dmsimard | Neat! I'd love to read a blog post or something on your setup :D | 15:39 |
| dmsimard | OpenStack doesn't need to aggregate data so we keep sqlite but we load them dynamically: https://ara.readthedocs.io/en/stable/advanced.html | 15:40 |
| gnupyx | and I have an other ara to read the postgresql | 15:40 |
| dmsimard | So where do your sqlite databases come from ? | 15:41 |
| gnupyx | ansible is in a docker container, and after a deploy is destroyed | 15:43 |
| gnupyx | my stack is jenkins + ansible (in docker) | 15:43 |
| gnupyx | a project use jenkins to deploy | 15:43 |
| dmsimard | Oh now I really want to read about it haha | 15:43 |
| gnupyx | yes why not | 15:44 |
| gnupyx | for the moment, i don't have a blog but it's an idea | 15:44 |
| gnupyx | i'm french, so my english is not very good, but i will try to write an english post about my need | 15:45 |
| dmsimard | I might move my ara blog posts to getara.org | 15:45 |
| dmsimard | Instead of my personal blog | 15:45 |
| dmsimard | So perhaps it could be a community blog | 15:45 |
| gnupyx | I read your blog, it's very interesting | 15:46 |
| gnupyx | my main problem with ara + postgres is the loss connection with the database | 15:48 |
| gnupyx | if I lose the connection my deployment failed, not acceptable for my company | 15:49 |
| dmsimard | Yes, exactly why I tend to privilege sqlite | 15:50 |
| gnupyx | I have 13 jenkins | 15:50 |
| gnupyx | :) | 15:50 |
| dmsimard | ARA 1.0 will allow for better scalability and availability if you need it | 15:51 |
| gnupyx | pgloader is not a very good solution, but it's worked | 15:51 |
| dmsimard | While not required, 1.0 ships an stateless API server | 15:52 |
| gnupyx | i think, i need a message queue for aggregate and have real time deployment in a dashboard | 15:52 |
| gnupyx | Yes | 15:52 |
| dmsimard | So you can just load balance as many API servers as you need | 15:52 |
| gnupyx | for the moment all ara is with ansible then i just use the callback | 15:52 |
| gnupyx | I try to follow the development on gerrit | 15:53 |
| dmsimard | gnupyx: https://demo.getara.org/api/v1/ | 15:54 |
| gnupyx | django is a good product | 15:55 |
| gnupyx | :) | 15:55 |
| gnupyx | it's time for me | 16:07 |
| gnupyx | see you later | 16:07 |
| dmsimard | see ya | 16:07 |
| *** sshnaidm_ is now known as sshnaidm | 16:14 | |
| *** tbielawa is now known as tbielawa|lunch | 17:50 | |
| *** bcoca has quit IRC | 18:34 | |
| *** tbielawa|lunch is now known as tbielawa | 18:49 | |
| *** tbielawa is now known as tbielawa|g0n3 | 20:26 | |
| *** tbielawa|g0n3 has quit IRC | 20:27 | |
Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!