vol7ron

Do you still need help with this?

I think it's back up now

ceedew.heliohost.org:2082 failed login

Not exactly sure what area52 is, but I'm guessing phpPgAdmin won't be available from CPanel. Perhaps we can work on that in the future. Right now, having something is better than nothing. As for the tools, I just hope I'm not the only one that will be using these, hopefully they'll bring in more users to the community. Additionally, I hope it doesn't negatively impact the servers, but they are good tools to have. Free, professional-grade tools, at that.

I'll try it out for my account, but i suspect the config files will need to point to Postgres. Wouldn't it be easier to erase the current Postgres path and create a symbolic link to the new Postgres install? I am trying to set it up in my user space, but it's not finding the server. /conf/config.inc.php Update: You have to change the defaultdb in the config file above from 'template1' to 'postgres'. $conf['servers'][0]['defaultdb'] = 'postgres'; //'template1'; Unfortunately, it'll list all users databases, so I'm working on just listing the database of the user that logged in. Update2: So all that needs to be done is changing another config setting, owned_only, from 'false' to 'true' $conf['owned_only'] = true; //false;

Nice. I guess that's all that's left to do, the config auth files may need adjusted and then just port everything from the 8.1 and we should be good.

Sweet were you able to get it working with CPanel/phppgadmin?

That was 12 days ago. That's like 2,318 years in internet time. Haha yeahh... ha ha ha. I really laughed

I just checked that link... it doesn't look to be working anymore

I'm not sure where 8.1 is being hosted, but you might want to try and run a VACUUM FULL on it to reduce it's size. It might temporarily lock the database, but it shouldn't break anything.

Sorry, I was away from my computer xaav, I didn't see your IRC message - I was hoping to leave this thread in y'alls hands To clarify for djbob, I think this is what we want as the plan of action: - Perl: newer version in parallel (two interpreters) - PostgreSQL: update/replace current version (one daemon) Xaav: I'm not sure you really want to run PostgreSQL in parallel, as that might bog down the system. I'm not too sure about that, but I would only do it in parallel for testing, before putting it into production. First you'll want to back up all the 8.1. You might want to also send out a message to the community about the update. The biggest issue that I remember from 8.1 to 8.4 was typecasting. 8.1 was a little less secure and used a little looser data types, whereas 8.4+ requires the user to be more specific (especially regarding dates). Still, I don't know how many of the users are actually using the database (I don't have permission to view the statistics tables). The actual install should not be that difficult. You can download it here (http://www.postgresql.org/download/linux) but the easiest way would be to use the apt installer. As for your error message, I'm not exactly sure what you're doing, though the command might be "service pgsql-9.0 start" because the older versions were called something else (pgsql instead of postgresql). This might be a helpful page: http://www.postgresql.org/docs/current/static/pgupgrade.html The most help you're going to get is from the IRC channel (#postgresql). If you go in there, take whatever RhodiumToad has to say for statement of fact. Though, try to go there with a specific question and be ready to pastebin.com something.

just bumping to see if there's been a status update

I was talking about upgrading postgresql, not installing another version of perl. That's a good question. I don't know the specifics about the current usage to be able to talk about what the upgrade may see. You might have more people attracted to the newer version versus MySQL. I do notice that the autovacuum is off, which you should turn on (on by default in 8.4+), as it will reduce storage space and increase performance. Also, the newer features and query optimizations in the newer engine means the system will use less resources, not more. Currently there are 15446 users, but I don't know how many of those are active.

That would be great! I know we have multiple python versions installed; we may be able to do the same thing for perl. At work we use multiple versions of perl. Everything on the web says to just install to a new directory and it should be good. I doubt that it would impact the server, so long as the environment paths still point to the route. Just let users know that there is a newer version available at something like /opt/bin/perl (instead of /usr/bin/perl) This answer seems to direct the Configure on the command line (I'm not sure who has the ability to ssh and do it, though): http://stackoverflow.com/questions/1289564...1291271#1291271 As for overloading the server, I also doubt it'll do that. I think users submitting bad code is more likely to do that than anything else, but that's for any language, including Python and PHP. Having more than one interpreter shouldn't matter too much, instead of using the one, they'll use the other.

This is interesting, since I would think that Perl would be mostly backwards compatible. To recap what I said in IRC, I think it's possible to run parallel versions of Perl, but users will need to point to that interpreter on the shebang (#!/newpath/perl). If you need me to look into this, I can. How about the PostgreSQL, is it possible to upgrade that that? I wouldn't think there's that many users using it because it's not as popular as MySQL, but I like it so much more. cheers, vol7ron

Thanks Geoff, I went to #HelioHost on irc.freenode.net, but no one was there. Are these forums the best way to openly discuss server wants/wishes/updates?

Thank you Geoff. Originally this topic was titled DBD::Pg, but I guess it was changed to JSON::XS for the other user. I see DBD::Pg has been installed on Stevie (though I must be honest, I didn't see the Show System Installed Modules before, so it may have always been there. Regardless, thank you! Regarding the Perl version, it would be nice to have 5.12+. I think HelioHost is using 5.8.8; I think that's what's shipped by default with RHEL/Red Hat, which could be why this is what's used. The current version according to the Perl docs (http://perldoc.perl.org/) is 5.14.1, but I would be glad to have anything 5.12 and on. The only other update I would request is PostgreSQL. I think HelioHost is using 8.1, which was a long time ago and is no longer being supported by the community. The latest stable release is 9.0.4 (http://www.postgresql.org/), but I would be happy with 8.4 or later. --- RECAP --- Perl 5.8.8 -> 5.12.2+ (preferrably 5.14.1) PostgreSQL 8.1 -> 8.4+ (preferably 9.0.4) ---- The other thing I'm trying to do is install Mason (http://search.cpan.org/~jswartz/Mason-2.13/lib/Mason/Manual/Admin.pod), which is a perl module/templating system that requires mod_perl installed on Apache, which I'm not sure if HH has installed. The point of this module is to make writing web-pages in Perl, more similar to PHP, in that script can easily be interpolated into HTML. Thank you so much, vol7ron

Geoff, I'm very new to HelioHost and am exploring the free hosting for a paid hosting option. I'm not quite sure what the multi-moderation is, but I did check the wiki and the only thing I saw in the wiki were the in-page meta tags, which would have no affect in this case. Perhaps there was something else there, but I was further puzzled by the fact that it was a Chrome-only issue, and didn't affect FF or IE (even though I tried to go to the site in all browsers while it was still in queue).

However there's never anyone in there when I'm there.

These are the kinds of things that ruin free hosts and really piss me off. Good work guys.

This only happens in Chrome, when I go to http://subdomain.heliohost.org, it auto forwards me to http://subdomain.heliohost.org/cgi-sys/defaultwebpage.cgi, which is the page it went to when the site was queued for creation. In Firefox and IE, it acts as it should, showing http://subdomain.heliohost.org/index.html. I've cleared all Chrome cookies, but still no luck. Any suggestions? It's been over a day since the site has been set up and index.html was created. _________________________________________________________________________ I was able to correct this by manually clearing the browser cache. (In version 13.0.782.109) Tools >> Options >> Under the Hood >> Clear browsing data... >> Empty the cache I did it for the past week just to be sure and it worked as it should. The HelioHost Wiki mentions something about the no-cache meta tag, however, the page couldn't even load for that tag to take place. I would think this could be an Apache error (instead of a permanent redirect [301], it should use a temporary redirect [302]).

Testing connection speed...(using fast method)...Done Ping:0 (ticks) Testing connection speed to cpan.yimg.com using pureperl...(77500.00 bytes/s)...Done Ping:0 (ticks) Testing connection speed to cpan.mirrors.hoobly.com using pureperl...(61800.00 bytes/s)...Done Ping:0 (ticks) Testing connection speed to mirrors1.kernel.org using pureperl...(30400.00 bytes/s)...Done Three usable mirrors located Mirror Check passed for cpan.yimg.com (/index.html) Method: Perl Expect Testing connection speed...(using fast method)...Done Ping:0 (ticks) Testing connection speed to cpan.yimg.com using pureperl...(77500.00 bytes/s)...Done Ping:0 (ticks) Testing connection speed to cpan.mirrors.hoobly.com using pureperl...(30900.00 bytes/s)...Done Ping:0 (ticks) Testing connection speed to mirrors1.kernel.org using pureperl...(30400.00 bytes/s)...Done Three usable mirrors located Mirror Check passed for cpan.yimg.com (/index.html) Disabling /bin/wget since LWP is available at /usr/local/cpanel/Cpanel/cPCPAN/Config.pm line 82. Disabling /bin/ftp since Net::FTP is available at /usr/local/cpanel/Cpanel/cPCPAN/Config.pm line 87. Going to read '/home1/vol7ron/.cpan/Metadata' Database was generated on Wed, 03 Aug 2011 17:29:39 GMT Running install for module 'DBD::Pg' Running make for T/TU/TURNSTEP/DBD-Pg-2.18.1.tar.gz CPAN: Digest::SHA loaded ok (v5.61) CPAN: Compress::Zlib loaded ok (v2.035) Checksum for /home1/vol7ron/.cpan/sources/authors/id/T/TU/TURNSTEP/DBD-Pg-2.18.1.tar.gz ok CPAN: Archive::Tar loaded ok (v1.76) DBD-Pg-2.18.1/ DBD-Pg-2.18.1/quote.h DBD-Pg-2.18.1/.perlcriticrc DBD-Pg-2.18.1/TODO DBD-Pg-2.18.1/README DBD-Pg-2.18.1/types.c DBD-Pg-2.18.1/Changes DBD-Pg-2.18.1/Makefile.PL DBD-Pg-2.18.1/t/ DBD-Pg-2.18.1/t/00basic.t DBD-Pg-2.18.1/t/08async.t DBD-Pg-2.18.1/t/01constants.t DBD-Pg-2.18.1/t/03smethod.t DBD-Pg-2.18.1/t/01connect.t DBD-Pg-2.18.1/t/03dbmethod.t DBD-Pg-2.18.1/t/06bytea.t DBD-Pg-2.18.1/t/02attribs.t DBD-Pg-2.18.1/t/04misc.t DBD-Pg-2.18.1/t/lib/ DBD-Pg-2.18.1/t/lib/App/ DBD-Pg-2.18.1/t/lib/App/Info.pm DBD-Pg-2.18.1/t/lib/App/Info/ DBD-Pg-2.18.1/t/lib/App/Info/RDBMS/ DBD-Pg-2.18.1/t/lib/App/Info/RDBMS/PostgreSQL.pm DBD-Pg-2.18.1/t/lib/App/Info/Util.pm DBD-Pg-2.18.1/t/lib/App/Info/Request.pm DBD-Pg-2.18.1/t/lib/App/Info/Handler.pm DBD-Pg-2.18.1/t/lib/App/Info/Handler/ DBD-Pg-2.18.1/t/lib/App/Info/Handler/Prompt.pm DBD-Pg-2.18.1/t/lib/App/Info/RDBMS.pm DBD-Pg-2.18.1/t/dbdpg_test_setup.pl DBD-Pg-2.18.1/t/20savepoints.t DBD-Pg-2.18.1/t/07copy.t DBD-Pg-2.18.1/t/09arrays.t DBD-Pg-2.18.1/t/00_signature.t DBD-Pg-2.18.1/t/12placeholders.t DBD-Pg-2.18.1/t/99cleanup.t DBD-Pg-2.18.1/dbivport.h DBD-Pg-2.18.1/Pg.h DBD-Pg-2.18.1/dbdimp.c DBD-Pg-2.18.1/quote.c DBD-Pg-2.18.1/META.yml DBD-Pg-2.18.1/lib/ DBD-Pg-2.18.1/lib/Bundle/ DBD-Pg-2.18.1/lib/Bundle/DBD/ DBD-Pg-2.18.1/lib/Bundle/DBD/Pg.pm DBD-Pg-2.18.1/Pg.xs DBD-Pg-2.18.1/README.win32 DBD-Pg-2.18.1/win32.mak DBD-Pg-2.18.1/MANIFEST DBD-Pg-2.18.1/SIGNATURE DBD-Pg-2.18.1/Pg.pm DBD-Pg-2.18.1/testme.tmp.pl DBD-Pg-2.18.1/MANIFEST.SKIP DBD-Pg-2.18.1/LICENSES/ DBD-Pg-2.18.1/LICENSES/artistic.txt DBD-Pg-2.18.1/LICENSES/gpl-2.0.txt DBD-Pg-2.18.1/README.dev DBD-Pg-2.18.1/dbdimp.h DBD-Pg-2.18.1/types.h CPAN: File::Temp loaded ok (v0.22) CPAN: Parse::CPAN::Meta loaded ok (v1.4401) CPAN: CPAN::Meta loaded ok (v2.110930) CPAN: Module::CoreList loaded ok (v2.42) CPAN.pm: Going to build T/TU/TURNSTEP/DBD-Pg-2.18.1.tar.gz perl-64bit-hack: enabled Configuring DBD::Pg 2.18.1 PostgreSQL version: 80122 (default port: 5432) POSTGRES_HOME: (not set) POSTGRES_INCLUDE: /usr/include POSTGRES_LIB: /usr/lib64 OS: linux Checking if your kit is complete... Looks good 'EXTRALIBDIR' is not a known MakeMaker parameter name. 'OTHERLDFLAGS' is not a known MakeMaker parameter name. Using DBI 1.616 (for perl 5.008008 on x86_64-linux) installed in /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBI/ Writing Makefile for DBD::Pg Could not read metadata file. Falling back to other methods to determine prerequisites cp testme.tmp.pl blib/lib/DBD/testme.tmp.pl cp lib/Bundle/DBD/Pg.pm blib/lib/Bundle/DBD/Pg.pm cp Pg.pm blib/lib/DBD/Pg.pm /usr/local/bin/perl -p -e "s/~DRIVER~/Pg/g; s/^do\(/dontdo\(/" /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBI/Driver.xst > Pg.xsi /usr/local/bin/perl /usr/local/lib/perl5/site_perl/5.8.8/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.8/ExtUtils/typemap Pg.xs > Pg.xsc && mv Pg.xsc Pg.c cc -c -I/usr/include -I/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBI -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -DPGLIBVERSION=80122 -DPGDEFPORT=5432 -O2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.18.1\" -DXS_VERSION=\"2.18.1\" -fpic "-I/usr/local/lib/perl5/5.8.8/x86_64-linux/CORE" Pg.c Died at /scripts/cpan_sandbox/x86_64/cc line 24. make: *** [Pg.o] Error 2 TURNSTEP/DBD-Pg-2.18.1.tar.gz /usr/bin/make PREFIX=/home1/vol7ron/perl/usr/local OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 PREFIX=/home1/vol7ron/perl/usr/local OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 -- NOT OK CPAN: YAML loaded ok (v0.73) Running make install Make had returned bad status, install seems impossible perlmod--Install done I can't seem to get it installed. Also is there a newer version than 5.8.8 of Perl?