[RELEASE] DA-PgSQL v0.1 - PostgreSQL plugin

[hehachris]

What is DA-PgSQL?

DA-PgSQL is a PostgreSQL plugin for DirectAdmin.

This plugin provides a feature riched management interface for PostgreSQL, just like the MySQL one orginally comes with DirectAdmin.

You can purchase this plugin in http://www.daplugin.com/orders. We accept Paypal and CC payment (via 2Checkout).


Links:

Features and Screenshots (http://daplugin.com/products/da-pgsql.shtml)

Documentation (http://daplugin.com/docs/)

ChangeLogs (http://forum.daplugin.com/index.php/topic,16.0.html)

Auto Build Script: PostgreSQL + phpPgAdmin (Forum member only) (http://forum.daplugin.com/index.php/topic,6.0.html)

[hehachris]

please refer to http://daplugin.com/doc_pgsql.shtml for installations

[ArielHost]

Anyone tried this on BSD yet?

[scott9824]

I can't order. I get to the "make payment" screen and it has errors.

Warning: main(modules/processor/): failed to open stream: No such file or directory in /home/daplugin/domains/daplugin.com/public_html/orders/skins/default/verify_order.php on line 321

Warning: main(modules/processor/): failed to open stream: No such file or directory in /home/daplugin/domains/daplugin.com/public_html/orders/skins/default/verify_order.php on line 321

Warning: main(modules/processor/): failed to open stream: No such file or directory in /home/daplugin/domains/daplugin.com/public_html/orders/skins/default/verify_order.php on line 321

Warning: main(): Failed opening 'modules/processor/' for inclusion (include_path='.:/usr/local/lib/php') in /home/daplugin/domains/daplugin.com/public_html/orders/skins/default/verify_order.php on line 321

I click the "make payment" button and it doesn't do anything. :(

[hehachris]

Originally posted by scott9824
I click the "make payment" button and it doesn't do anything. :( [/B]
pm sent.

i have contacted phpaudit to figure out the problem


edit:
the problem has been fixed.

[scott9824]

Originally posted by hehachris
pm sent.

i have contacted phpaudit to figure out the problem


edit:
the problem has been fixed.

Thanks! Nice plugin. It's working great. :)

[jouwnaam]

Will PqSQL databases be backed up when using DA's reseller backup? If not, maybe you should add an option to make backups every x hours or so and place these backups somewhere in the user's home dir.

[explodehost.com]

When I click on download, I get: Invalid Resource Path

[hehachris]

Originally posted by explodehost.com
When I click on download, I get: Invalid Resource Path
Sorry for the inconvenience.
Please try again now.

[explodehost.com]

When I run /usr/local/bin/php -f /usr/local/directadmin/plugins/pgsql/include/write_user_conf.php all

I get

[****@*****]# /usr/local/bin/php -f /usr/local/directadmin/plugins/pgsql/include/write_user_conf.php all
Could not open input file: /usr/local/directadmin/plugins/pgsql/include/write_user_conf.php

[hehachris]

pm sent

Originally posted by explodehost.com
When I run /usr/local/bin/php -f /usr/local/directadmin/plugins/pgsql/include/write_user_conf.php all

I get

[****@*****]# /usr/local/bin/php -f /usr/local/directadmin/plugins/pgsql/include/write_user_conf.php all
Could not open input file: /usr/local/directadmin/plugins/pgsql/include/write_user_conf.php

[explodehost.com]

I found a small bug.
If you un install it, the PostgreSQL area in the packages is still there.
I uninstalled and reinstalled and now I see 2 of the boxes.

[hehachris]

v0.2 released!

Change Log: http://daplugin.com/doc_tomcat.shtml

[mobitoc]

root@login1# ./daplugin.build
./daplugin.build: 637: Syntax error: Bad substitution
root@login1#

[hehachris]

Originally posted by mobitoc
root@login1# ./daplugin.build
./daplugin.build: 637: Syntax error: Bad substitution
root@login1#
the problem has been resolved in our helpdesk.

[albatroz]

Hello, I purchased the postgresql plugin and downloaded the autobuild script.

However I would like to install only postgresql not tomcat or anything else, do I need to do something with it?

[hehachris]

Originally posted by albatroz
Hello, I purchased the postgresql plugin and downloaded the autobuild script.

However I would like to install only postgresql not tomcat or anything else, do I need to do something with it?

You can install only pgsql by typing:

./daplugin.build pgsql



You could type ./daplugin.build to see available options

[Sven]

I don't manage to install it.
I'm using Directadmin on a CentOS server.
I reinstalled postgresql but it still doesn't work.

This is the error I receive at the footer of the page where I need to fill in the settings:
Warning: pg_version(): supplied argument is not a valid PostgreSQL link resource in /usr/local/directadmin/plugins/pgsql/include/db_pgsql_conn.php on line 132 v0.2 / PostgreSQL

This is the error I receive after I save the settings:
SQL Error

Details


Unable to connect to PostgreSQL server

Click HERE to go back

[hehachris]

please dont post here if you have submitted a ticket.
It will confuse my wok if I need to answer a same question in both places.
if i dont reply here, some body may think i am not willing to answer questions


Originally posted by Sven
I don't manage to install it.
I'm using Directadmin on a CentOS server.
I reinstalled postgresql but it still doesn't work.

This is the error I receive at the footer of the page where I need to fill in the settings:
Warning: pg_version(): supplied argument is not a valid PostgreSQL link resource in /usr/local/directadmin/plugins/pgsql/include/db_pgsql_conn.php on line 132 v0.2 / PostgreSQL

This is the error I receive after I save the settings:
SQL Error

Details


Unable to connect to PostgreSQL server

Click HERE to go back

[hehachris]

DA-PgSQL v0.3 has been released.

Changelog: http://forum.daplugin.com/index.php/topic,16.0.html

[albatroz]

How can I upgrade from version 0.2 to 0.3 of your Plugin?

[hehachris]

How can I upgrade from version 0.2 to 0.3 of your Plugin?

You can update this plugin easily using the daplugin.build script.

[code]
# cd /usr/local/directadmin/customapache/daplugin.com
# ./daplugin.build clean
# ./daplugin.build update
# ./daplugin.build da-pgsql
[code]

If you never use this script, please read this: http://forum.daplugin.com/index.php/topic,7.0.html

[albatroz]

I have lost/forgot the password for da_admin (the main PostgreSQL password)

Is there a way to reinstall PostgreSQL and solve this issue?

[hehachris]

Simply drop it and re-create it:

# su progres
# dropuser da_admin
# createuser da_admin

[winger]

the script (for postgre) still does not support CentOS 5, isn´t?

[cyberneticos]

Is this plugin recent ?

Most links on the main post are not working :confused:

[hehachris]

Is this plugin recent ?

Most links on the main post are not working :confused:

Sorry, I should have updated the links on the first post :p

BTW you can always vists our website http://www.daplugin.com

[hehachris]

We are exited to annouce tht DA-PgSQL v0.4 has been released.

The major update in this version is the support for PostgreSQL 8.2.

DA-PgSQL is now encoded using Nu-Coder instead of Ioncube. For existing customers, it is recommended to install DA-PgSQL from scratch (uninstall and then re-install).


Detailed Changelogs can be found at: http://forum.daplugin.com/index.php/topic,16.0.html


Existing Customers are always encouraged to upgrade your purchased products using the daplugin.build script. Please refer to the howto: http://forum.daplugin.com/index.php/topic,21.0.html

[ilan]

Does anybody know what happened to daplugin.com?

I was interested in DA-PgSQL plugin but for at least a month they have being out of the air.

Does any body know of another PostgreSQL plugin?

Thanks
Ilan

[hehachris]

a month? we are still accepting orders and resolving support tickets every day. And the latest bug fix release, which is for Rails in DA, was released on Apr 01, 2008.

Our HK mirror site (daplugin.com) was having temporary outage this morning (GMT+8), but the US mirror (daplugin.net) is still accessible.

[gate2vn]

DA has option to run mysql on external server. Is this can run on external server too?

[hehachris]

DA has option to run mysql on external server. Is this can run on external server too?

Yes. There is an option for admin to specify the Database Host.

[hehachris]

We are exited to annouce tht DA-PgSQL v0.5 has been released.

The major update in this version is the support for PostgreSQL 8.3.

Due to popular request, the files in /var/www/html/daplugin are now encoded with Zend Encoder. So you don't need to have Nusphere's PhpExpress any more.


Detailed Changelogs can be found at: http://forum.daplugin.com/index.php/topic,16.0.html


Existing Customers are always encouraged to upgrade your purchased products using the daplugin.build script. Please refer to the howto: http://forum.daplugin.com/index.php/topic,21.0.html