Bug 369679 – GSoC 2011 gentoostats: Package request on soc.dev.gentoo.org

• Status: RESOLVED FIXED
• Product: Gentoo Infrastructure

[Description Vikraman (RETIRED) 2011-06-01 15:44:05 UTC]

I need some packages installed on the server to deploy my webapp for the 'Package statistics' project for GSoC'11. Please do the needful.

Reproducible: Always




The packages required are :

 dev-db/mysql
=dev-lang/python-2.*
(These are already installed)

dev-python/mysql-python
dev-python/webpy
(These need to be installed)

I also need a mysql user account and a database with all permissions granted for the user (the sql code is in server/sql/setup.sql).

create database gentoostats;
grant all on gentoostats.* to 'gentoo'@'localhost' identified by 'gentoo';

[Comment 1 Robin Johnson 2011-06-09 04:05:10 UTC]

Database is created.
Packages will be installed by cfengine at the next pass.

Auth details for MySQL are in vulture:/home/vikraman/mysql-password

[Comment 2 Vikraman (RETIRED) 2011-06-09 18:41:25 UTC]

Created attachment 276403 [details]
/etc/apache2/modules.d/70_mod_wsgi.conf

I need to deploy the webapp. It's written using webpy and can be deployed using mod_wsgi on apache.

I have attached the wsgi config from my computer, the app being deployed on /var/www/gentoostats

[Comment 3 Theo Chatzimichos (RETIRED) 2011-06-09 22:01:46 UTC]

I have a better idea: put the code in your homedir and only the wsgi in /var/www/gentoostats. That way you'll be able to update it whenever you want (eg with git pull)

[Comment 4 Vikraman (RETIRED) 2011-06-30 10:30:42 UTC]

Created attachment 278685 [details]
main.py

Here's the wsgi handler to be put into /var/www/gentoostats

[Comment 5 Robin Johnson 2011-07-11 06:19:55 UTC]

(In reply to comment #4)
> Created attachment 278685 [details]
> main.py
> 
> Here's the wsgi handler to be put into /var/www/gentoostats

That's not the actual path you get. But your app is now configured to be served at http://soc.dev.gentoo.org/gentoostats

However it seems your app doesn't work?
1. OperationalError: (1045, "Access denied for user 'gentoo'@'localhost' (using password: YES)"). That's NOT the user+password I gave you.
2. Your app seems to be dependant on adding a trailing slash to that URL. Please fix that.

[Comment 6 Vikraman (RETIRED) 2011-07-11 20:13:30 UTC]

> However it seems your app doesn't work?
> 1. OperationalError: (1045, "Access denied for user 'gentoo'@'localhost' (using
> password: YES)"). That's NOT the user+password I gave you.
> 2. Your app seems to be dependant on adding a trailing slash to that URL.
> Please fix that.

I have fixed teh issues. However, apache needs to be restarted to reload the wsgi script.

[Comment 7 Vikraman (RETIRED) 2011-08-11 20:47:11 UTC]

Okay, I now need dev-python/matplotlib for my plots.

[Comment 8 Robin Johnson 2011-08-11 21:59:47 UTC]

Configured for deploy via cfengine, check the box in 30-60 minutes and it will be there.

[Comment 9 Vikraman (RETIRED) 2011-08-11 22:25:27 UTC]

Also apache isn't reloading properly, just by touching the wsgi, the webapp displays random stuff at different times.

[Comment 10 Robin Johnson 2011-08-11 23:11:44 UTC]

restart should be fixed, and your python package is there

[Comment 11 Jeremy Olexa (darkside) (RETIRED) 2012-02-09 21:59:56 UTC]

Please reopen the bug if you need something else since GSoC 2011 is long over.