wambachr

May 14, 2021

thanks,

working fine

regards

walter

May 13, 2021

sorry

username: wambachr

main domain wambachr.heliohost.org

postgresql-database: wambachr_osm

server: tommy

regards

walter

May 13, 2021

Hi, i would like to create indixes used by the like-phrase

something like select name from collected_admin_boundaries where name ilike 'san %';

This type of query will only use trgm-indices which can be created using

create index idx_collected_admin_boundaries_name on collected_admin_boundaries using gin(name gin_trgm_ops);

But for that i need the extension pg_trbn, which is installed but not activated.

wambachr_osm=> create extension pg_trgm with schema pg_catalog;

ERROR: permission denied to create extension "pg_trgm"
HINT: Must be superuser to create this extension.
Time: 2486,759 ms (00:02,487)

Regards

walter

May 12, 2021

Thanks, Krydos

have a nice day

walter

May 11, 2021

thanks

and waiting is no problem.

Regards

walter

May 11, 2021

i was not asked to use paypal, therefore i used visa + gofundme

Dear walter nordmann,
Thanks for your generous donation to PayPal Giving Fund. You have selected Helio Networks as your chosen charity. PayPal Giving Fund, a public charity (Federal Tax ID: 45-0931286), in partnership with PayPal, processes your donation so it can be granted to your chosen charity. Track your donation
Your donation summary:
Benefiting charity: Helio Networks Program: GoFundMe Charity Transaction ID: 5T811011SD786284V Date: May 11, 2021 05:06:51 PDT Your contribution: $11.00 USD Your Tax deductible contribution: $10.00 USD

regards

walter

May 11, 2021

ok, did it:

Transaction ID: 3AW52485E68405919

a little bit strange: added my visa card and was billed by paypal

walter

May 10, 2021

Hi,

i would like to add onother table to my postgresql/postgis database (wambachr_osm), but my disk quota does not allow this

Size of this table is about 400 MB but there may be a little overhead.

I'm trying to minimize my tables but 1 GB space is not enough. 2 GB would be fine.

what can i do? Donate? ok for me.

regards

walter

ps: Still waiting to get access to your new "payed" server. Of course i'm willing to pay for that (some bucks per month is fine)

March 29, 2021

Hi,

just got this message:

Hey Wambachr,

It's been a while since we've seen you. Are you still using your hosting account?
The last time you logged in was 2021-03-01. In order to keep your website active you must log into your control panel at least once every 30 days.
...

My websites on tommy.heliohost.org /https://wambachers-osm.website/ are in heavy development and use. (*)

I'm using cPanel/Filemanager day for day and sometimes (1-2 times a week) i have to login in cPanel, which i do.

But i don't use heliohost.org (Main page), because i don't need this. cPanel is enough.

May be there is a bug in your usage monitor?

ok, i'll login to heliohost.org right now to get rid of this "problem"

regards

walter aka wambachr

*) Still waiting for a solution for ticket HH#816382 i don't have any problem to spend some $. Good work must be well paid.

;

November 26, 2020

Bingo

select ST_Astext(ST_Transform(ST_MakeEnvelope(905014.414896487,6467184.089152194,907460.
           3998016127,6469630.074057321,3857),4326));

                                                                            st_astext                                                                             
------------------------------------------------------------------------------------------------------------------------------------------------------------------
 POLYGON((8.1298828125 50.1205780979601,8.1298828125 50.134664322167,8.15185546875 50.134664322167,8.15185546875 50.1205780979601,8.1298828125 50.1205780979601))
(1 row)

Yes, that problem is gone.

regards

walter, may be the only user on tommy doing this stuff

November 26, 2020

Hi,

select ST_Astext(ST_Transform(ST_MakeEnvelope(905014.414896487,6467184.089152194,907460.3998016127,6469630.074057321,3857),4326));

does not work (yet):

ERROR: permission denied for relation spatial_ref_sys
CONTEXT: SQL statement "SELECT proj4text FROM spatial_ref_sys WHERE srid = 3857 LIMIT 1"

this PostGIS tables/views will need r/o access:

spatial_ref_sys

geography_column

geometry_columns

Regard

walter

host: Tommy

db: wambachr_osm

db user: wambachr_postgres & wambachr_osmuser

November 24, 2020

thanks

regards

walter

November 24, 2020

Hi,

i'm planning to switch from tommy to a vps but i can't find what i'm looking for.

I there a way to rent a preinstalled vps? More than the OS only?

I like the comfort using cpanel and don't like to install and maintain all the stuff i need.

The current setup of wambachr.helioshost.org (postgresql, postgis) is fine for me but may be i need more performance and stability 2021. And i want to pay for it

Regards

walter

btw: Searching for VPS is rejected on your site:

-> "The following search terms are not allowed and were removed from your query: vps"

November 23, 2020

Hi Krydos

yes you are right. no big problem using postgis/hstore.

Thanks

walter

btw: may be i'll switch to one of your paid servers next year.

November 22, 2020

Hi,

Please create hstore and postgis extensions on my postgres database.

Host: tommy.heliohost.org

User: wambachr

Database: wambachr_osm

Regards,

Walter

ps: would like to add some simple OpenStreetMap based maps.

Posted October 29, 2020 · October 29, 2020

Bingo! you got it.

Thanks

walter

Posted October 29, 2020 · October 29, 2020

sorry, no

$dbconn = pg_connect("host=127.0.0.1 dbname=wambachr_osm user=wambachr_osmuser password=public");

=> Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "wambachr_osmuser", database "wambachr_osm", SSL off in /home/wambachr/public_html/getSoftware4.php on line 31

$dbconn = pg_connect("host=localhost dbname=wambachr_osm user=wambachr_osmuser password=public");

=> Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "wambachr_osmuser", database "wambachr_osm", SSL off in /home/wambachr/public_html/getSoftware4.php on line 31

$dbconn = pg_connect("host=tommy.heliohost.org dbname=wambachr_osm user=wambachr_osmuser password=public");

=> Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "65.19.143.6", user "wambachr_osmuser", database "wambachr_osm", SSL off in /home/wambachr/public_html/getSoftware4.php on line 31

$dbconn = pg_connect("host=65.19.143.6 dbname=wambachr_osm user=wambachr_osmuser password=public");

=> Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "65.19.143.6", user "wambachr_osmuser", database "wambachr_osm", SSL off in /home/wambachr/public_html/getSoftware4.php on line 31

$dbconn = pg_connect("host=wambachr.heliohost.org dbname=wambachr_osm user=wambachr_osmuser password=public");

=> Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "65.19.143.6", user "wambachr_osmuser", database "wambachr_osm", SSL off in /home/wambachr/public_html/getSoftware4.php on line 31

even tried "no host"

$dbconn = pg_connect("dbname=wambachr_osm user=wambachr_osmuser password=public");

=> Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "[local]", user "wambachr_osmuser", database "wambachr_osm", SSL off in /home/wambachr/public_html/getSoftware4.php on line 31

regards
walter

Testpage http://wambachr.heliohost.org/SoftwareWatchlist4.html will try to connect using "$dbconn = pg_connect("host=localhost dbname=wambachr_osm user=wambachr_osmuser password=public"); not working

switching to real db admin and his db password will work.

Posted October 28, 2020 · October 28, 2020

Hi,

i'm using postgresql and php - it's running fine

I recently added a second database user (wambachr_osmuser) and granted r/o access to my tables. This userid/password will be visible to any user reading the php-script. But that is ok for me.

Now i'm getting error "Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "65.19.143.6", user "wambachr_osmuser", database "wambachr_osm", SSL off in ..."

That is Tommies ip address and i think this should be added to pg_hba_conf too. Better using Tommys name instead of ip address, i think.

BUT i'm not 100% shure if this is the correct way, and you may tell me a better solution.

regards

walter aka wambacher

btw: "osm" stands for https://OpenStreetMap.org

October 26, 2020

Hi,

having (knowledge) problems with java servlets i swichted to php and got my programm running.

Therefore i don't need java any more.

Regards

walter

October 17, 2020

thanks

walter

October 16, 2020

Having trouble getting my servlet running, somebody pointed to http://wiki.helionet.org/Java_Servlet#Edit_index.jsp_Source but this page is missing too

regards

walter

btw: what are your buisines times? Lining in Germany and don't know where your location/timezone is.

October 13, 2020

ok, only one war without VPS is fine for me.

just wanted to know what's going on.

Regards

walter

October 12, 2020

Hi, is it possible to deploy more than one war? would like to use 2 of them - otherwise i have to rewrite alot code.

Walter

btw: "If you are interested in deploying a servlet we recommend taking a look at the guide to get started wiki.helionet.org/Java_Servlet." does not work. Wiki does not exist.

October 12, 2020

great. this will help me a lot

Regards

walter

October 12, 2020

Hi, i sent a java activation request yesterday and i'm waiting for it.

somebody asked the same and you told him that will need some days.

then you said "The line for Java only moves if someone else loses their Java."

question: do i have to check the activation page each day or will i get an email when it's done? (which is less work - and less frustration - for me )`

If this is still necessary i would like to register my application (SoftwareWatchlist.war) just to save time.

Will this war file be checked on a regular base by the system? Just replace it and the new version will go live in some minutes?

Best regards

walter

Sign In

wambachr

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by wambachr

[Solved] pg_trgm extension

[Solved] pg_trgm extension

[Solved] pg_trgm extension

[Solved] request for more database space

[Solved] request for more database space

[Solved] request for more database space

[Solved] request for more database space

[Solved] request for more database space

[Solved] heliohost inactivity warning

[Solved] PostGIS needs read acces to some spatial tables

[Solved] PostGIS needs read acces to some spatial tables

[Answered] switching to vps?

[Answered] switching to vps?

[Solved] add postgresql extensions

[Solved] add postgresql extensions

[Solved] accessing my postgres database by second (read only) user

[Solved] accessing my postgres database by second (read only) user

[Solved] accessing my postgres database by second (read only) user

[Solved] remove java support

[Answered] wiki file missing :(

[Answered] wiki file missing :(

java activation and some more questions

java activation and some more questions

java activation and some more questions

java activation and some more questions

HelioHost

Donate

Forums

Activity