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:45:56 GMT
And,

672 files are new files. Changed only nodes.pp

Thanks.


On Mon, Aug 4, 2014 at 11:09 PM, Rajkumar Rajaratnam <rajkumarr@wso2.com>
wrote:

> 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
>



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

Mime
View raw message