stratos-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajkumar Rajaratnam <rajkum...@wso2.com>
Subject Re: PostgreSQL Cartridge for Apache Stratos
Date Mon, 04 Aug 2014 17:39:05 GMT
Hi Akila,

I am using PostgreSQL puppet module from Puppet Laps. This module has
dependency to another 4 modules of them. We need to have all. We can edit
their modules and remove unwanted files. But it will be very hard to sync
with their libraries in future (for example, if we want to update their
modules, we may have to do it manually again).

Actually 664 files are coming from their libraries. What should I do?

Thanks.


On Mon, Aug 4, 2014 at 10:58 PM, Akila Ravihansa Perera <ravihansa@wso2.com>
wrote:

> Hi Rajkumar,
>
> Nice work.
>
> But there are 673 files changed in your PR. Something is not right.
> Can you create a JIRA for this and attach the patch?
>
> Thanks.
>
> On Mon, Aug 4, 2014 at 10:39 PM, Rajkumar Rajaratnam <rajkumarr@wso2.com>
> wrote:
> > Hi,
> >
> > Pull request link is https://github.com/apache/stratos/pull/10
> >
> > Thanks.
> >
> >
> > On Mon, Aug 4, 2014 at 10:35 PM, Rajkumar Rajaratnam <rajkumarr@wso2.com
> >
> > wrote:
> >>
> >> Hi Devs,
> >>
> >> I have created a PostgreSQL cartridge [3] for Apache Stratos. It
> consists
> >> of 2 modules.
> >>
> >> PostgreSQL server
> >> phpPgAdmin web interface
> >>
> >>
> >> PostgreSQL server
> >>
> >> I have utilized PostgreSQL puppet module [1] from puppet laps and
> plugged
> >> in my phpPgAdmin module[2] to come up with a PostgreSQL cartridge.
> >>
> >> Puppet laps' PostgreSQL module has several great features. Some of them
> >> are,
> >>
> >> configure and manage PostgreSQL server (for example, who can access
> and/or
> >> from where)
> >> creating and managing databases
> >> managing users, roles and permissions
> >> install PostgreSQL bindings for languages such as java (JDBC), Perl and
> >> Python.
> >>
> >> There are more, you may refer [1] for the complete documentation.
> >>
> >> phpPgAdmin Web Interface
> >>
> >> I have developed a phpPgAdmin puppet module [2] for PostgreSQL server
> >> management through browsers.
> >>
> >> Usage
> >>
> >> Everything is documented in more detail here [3].
> >>
> >> Sample cartridge deployment would looks like below in an openstack
> >> environment,
> >>
> >> {
> >>   "type": "postgresql",
> >>   "provider": "data",
> >>   "host": "stratos.com",
> >>   "displayName": "postgresql",
> >>   "description": "postgresql Cartridge",
> >>   "version": "9.1",
> >>   "multiTenant": "false",
> >>   "portMapping": [
> >>     {
> >>       "protocol": "http",
> >>       "port": "5432",
> >>       "proxyPort": "80"
> >>     }
> >>   ],
> >>   "deployment": {},
> >>   "iaasProvider": [
> >>     {
> >>       "type": "openstack",
> >>       "imageId": "RegionOne/f2ddf72a-4e76-4893-a9fa-e5f4352f1a86",
> >>       "property": [
> >>         {
> >>           "name": "instanceType",
> >>           "value": "RegionOne/3"
> >>         },
> >> {
> >>           "name": "keyPair",
> >>           "value": "raj-openstack"
> >>         },
> >> {
> >>           "name": "securityGroups",
> >>           "value": "all-open"
> >>         }
> >>       ]
> >>     }
> >>   ]
> >> }
> >>
> >> Sample node definition (in nodes.pp) would looks like,
> >>
> >> # postgresql cartridge node
> >> node /postgresql/ inherits base {
> >>   require java
> >>   class {'agent':}
> >>
> >>   class { 'postgresql::server':
> >>     ip_mask_deny_postgres_user => '0.0.0.0/32',
> >>     ip_mask_allow_all_users    => '0.0.0.0/0',
> >>     listen_addresses           => '*',
> >>     manage_firewall            => true,
> >>     postgres_password          => 'postgres'
> >>   }
> >>
> >>   postgresql::server::db { 'stratos-postgres-sample':
> >>     user     => 'root',
> >>     password => postgresql_password('root', 'root'),
> >>   }
> >>
> >>   class {'phppgadmin':
> >>     db_host   => 'localhost',
> >>     db_port        => '5432',
> >>     owned_only   => false,
> >>     extra_login_security => false
> >>   }
> >>
> >>   Class['postgresql::server']->Class['phppgadmin']~> Class['agent']
> >> }
> >>
> >> I have sent pull request 4.0.0
> >>
> >> Can someone review and merge the pull request [4]?
> >>
> >> 1. https://forge.puppetlabs.com/puppetlabs/postgresql
> >> 2. https://github.com/R-Rajkumar/phppgadmin.git
> >> 3.
> >>
> http://blog.rajkumarr.com/2014/08/using-postgresql-cartridge-on-apache-stratos.html
> >> 4. https://github.com/apache/stratos/pull/9
> >>
> >> Thanks.
> >>
> >> --
> >> Rajkumar Rajaratnam
> >> Software Engineer | WSO2, Inc.
> >> Mobile +94777568639 | +94783498120
> >
> >
> >
> >
> > --
> > Rajkumar Rajaratnam
> > Software Engineer | WSO2, Inc.
> > Mobile +94777568639 | +94783498120
>
>
>
> --
> Akila Ravihansa Perera
> Software Engineer
> WSO2 Inc.
> http://wso2.com
>
> Phone: +94 77 64 154 38
> Blog: http://ravihansa3000.blogspot.com
>



-- 
Rajkumar Rajaratnam
Software Engineer | WSO2, Inc.
Mobile +94777568639 | +94783498120

Mime
View raw message