See below answer...
On Sun, Dec 30, 2012 at 3:55 PM, Arnon Marcus <a.m.mar...@gmail.com> wrote: > 10x for the info. > Is there any benefit for using the server vs. the desktop flavor? > > About pgAdmin, I don't really understand what you mean. > We have been using posgreSQL with web2py in production for almost 3 years > now. Using phpPgAdmin on our production was never an option - always a > necessity. Maybe it's becuse we are using an outdated version of web2py, > but from our experience, the DAL isn't perfect - there are many advanced > features of PostgreSQL that are not supported (I can give you a list of > those), so we HAVE to use some kind of interface to further customize our > schema outside of web2py. I don't really see how we can do this in a dev > machine and not need to do the same for the prod. machine. If they share > a database, then the database is on the prod. machine - and we need > phpPgAdmin. If each of them have a separate machine, then we need 2 > phpPgAdmins one on each machine. As far as I know, you can't have your > database installed in one machine, and have your phpPgAdmin hosted on > another - in its configuration file, you have to specify the local path of > the pg_dump.exe and stuff like that it needs for it's operation. And > again, we need it's operation for unsupported feattures of postgreSQL in > web2py. > As for PgAdmin-III, well, we basically only use if when transferring our > database + schema as an SQL string, from one machine to another. Somehow > the same thing using phpPgAdmin doesn't take us the whole way the same > way PgAdmin-III does when doing that. > If we were starting a new project, I could have agreed with you - we > wouldn't need phpPgAdmin AND PgAdmin-III. But since we already have a > database somewhere else (meaning, outside the virtual machine I just > installed thanks to you), we need PgAdmin-III for the database transferring. > And since the installation of it in ubuntu is extremely simple, and > having our solution installing a default ubuntu installation of postgreSQL, > I would have expected the installation of PgAdmin-II to have automatically > identified the postgreSQL service/process that is running - but when I > launch it, and try to "connect", it apparently doesn't find it properly. I > can't seem to be able to connect to the postgreSQL service with it. I > don't see any redmine database I can connect to. I think we are confusing > the database node, with the connection-string/setting for PgAdmin to find > the server/service/process/whatever... > > I am not sure I follow you about service/process, as far as I know you only need to connect to postgres, you need a ip, an user name and a password. So you need to configure you connection in pgAdmin for that. You may need to open access from the prod/staging server, firewall, pg_hba.conf and postgresql.conf in /etc/postgresql/.../.../* About the last point pg_hba.conf, I prefer connect remote sever with ssh, less difficult then setting up SSL with postgres, search for "ssh fowarding" for that, here the command : ssh -L local-port:HOSTNAMEorIP:distant-port ( http://www.debianadmin.com/howto-use-ssh-local-and-remote-port-forwarding.html ) About phpPgAdmin, I can't see what you can't do with pgAdmin, I tweak my database as I which with pgAdmin from remote machine (my dev environnement) without limit, I would not rely on phpPgAdmin for that, but it surely a matter of choice. If you prefer phpPgAdmin go for it (google with the write keyword should allow you to find the way you can configure nginx with php support and then install phpPgAdmin). > Any thought? > > And any pointers you could give me for trying to install phpPgAdmin? > I was able to locate where web2py is and where redmine is. But where is > nginx? How do I further configure it for php ? Any configuration file I > should know aboout? > > Google > And what about web2py? > Is it connected to postgreSQL? > I guess not, because it's just the welcome application, that uses sqlite by > default, right? > I guess if I can connect to postgreSQL with PgAdmin, I will have found > the specification I need to use in the connection string in web2py for our > application (we currently use the default settings for postgreSQL connection > and it works) > > Web2py is just installed, you app should have a connection string that where you define the location of your database server and user name and password. I think, I should have create a web2py dummy app deployed with my script :-P > I was able to install everything smoothly on ubuntu 12.04 desktop x64 > with virtual box on windows 7 x64. Web2py and redmine are loadingsuccessfully > locally with > firefox. But how do I access them elsewhere on our intranet? > That mean that the script if working well for you (if you can connect to both site web2py welcome and redmine)... About the intranet, I don't really understand... I presume that you have deploy a virtual machine on you own desktop computer, if so, and regarding your next sentence and the 10.0.2.15 ip address you mention, I think you should use bridged networking (easier solution to allow internet connection to a VM with VB) interface in you network VirtualBox machine this way all the VM you host on this computer will use the network card (the one of you computer) and get each a IP address. That is far from the purpose of this script. And you maybe need a syst admin if you don't know how to do this kind of stuff your self. Also, hosting a staging/prod server on your own dev computer is kind of use less you will run 2 VMs at the same time on the same machine (one for the prod/staging VM and one for your Dev machine), and you will get in trouble with memory soon. If you don't have a really prod server, for example ESXi or bare metal dedicated server, you should stick with one VM where you configure Nginx, etc. and you developpe with Rocket server included in web2py. Richard I tries "ifcondif" in the reminal, and got a 10.0.2.15 ip adress... That's > not usefull, I guess... I'll admit I am a nube at linux and virtual > machines stuff... Would appreciate any pointers you could give me... > > > On Sun, Dec 30, 2012 at 10:36 AM, Richard Vézina < > ml.richard.vez...@gmail.com> wrote: > >> Arnon, >> >> I test it with 12.04 server 64 bit under VirtualBox with windows 7 64 bit >> as guest and it works fine. It surely work under ubuntu desktop, but not >> tested. The purpose of the script is to deploy rapidly a new prod/stage >> server with basic configuration that you can tweaks for your needs later. >> Since you don't really require Nginx for develppment it make no sens to >> install pgAdmin on the staging/prod server, you generally install it on >> your dev system. You can install phpPGAdmin if you want, but when I try it >> (very longtime ago, may have change) it was not the same quality of >> phpmyadmin, just for you to know that. I let you find your way to install >> it (google...). >> >> Default postgres database name is redmine and user name for redemine is >> redmine and the password is the one you enter when the script ask for it. >> >> You can, try it with 12.10, but I prefer 12.04 since it LTS and I don't >> want to setup new environnement in less than a year. >> >> Richard >> >> >> On Sun, Dec 30, 2012 at 1:26 PM, Richard Vézina < >> ml.richard.vez...@gmail.com> wrote: >> >>> I will be glad, if you want to... >>> >>> :) >>> >>> Richard >>> >>> >>> On Fri, Dec 28, 2012 at 11:12 PM, Massimo Di Pierro < >>> massimo.dipie...@gmail.com> wrote: >>> >>>> Would you suggest we include it in web2py/scripts/? >>>> >>>> >>>> On Friday, 28 December 2012 14:17:12 UTC-6, Richard wrote: >>>>> >>>>> Hello, >>>>> >>>>> This is a new year gift for the one who would use Redmine beside >>>>> web2py... >>>>> >>>>> :) >>>>> >>>>> The script is largely base on new Niphold web2py nginx deployment >>>>> script (https://groups.google.com/**forum/?fromgroups=#!searchin/** >>>>> web2py/nginx$20niphold/web2py/**15J3T35_K_w/v_t1099dIf4J<https://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J> >>>>> ). >>>>> >>>>> I spend many hours write it, test it and debug Redmine, so I copyright >>>>> it and distribute it under CC without commercial use. >>>>> >>>>> Executing it in a fresh Ubuntu 12.04 server you will get : >>>>> - Latest Redmine stable (2.2.0 from http://rubyforge.org), >>>>> - Rails (3.2.9 from GEM) >>>>> - Ruby (ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-linux]) >>>>> (Ubuntu ruby-dev package that should correspond to the latest stable Ruby) >>>>> - working with Unicorn (latest stable from GEM), >>>>> - web2py (latest stable) >>>>> - uWSGI (I think latest stable), start in Emperor mode >>>>> - Nginx (Ubuntu default) >>>>> - PostgreSQL (Ubuntu default) >>>>> - Redmine database will be installed in PostgreSQL >>>>> - Self Signed SSL Certificat >>>>> >>>>> I try to make the script asking all the question at the beginning of >>>>> the installation process just after launch it, but there is a confirmation >>>>> asked during execution where you have to choose which language to use for >>>>> the Redmine default values. Just hit enter you will get English Redmine >>>>> default values. >>>>> >>>>> At the end of the execution, you should access your sever like this : >>>>> >>>>> http://IPADSRESS/ >>>>> # web2py Welcome should appear >>>>> http://IPADSRESS/redmine >>>>> # Redmine! >>>>> >>>>> Please report issue, submit improvement or post any comment here, and >>>>> I will be glad to improve the script. >>>>> >>>>> Happy new year to all! >>>>> >>>>> Richard >>>>> >>>> -- >>>> >>>> >>>> >>>> >>> >>> >> -- >> >> >> >> > > -- > > > > --
