[Maps-l] running tools on cassini / db / old-name

[Tim Alder]

Hello,
the outdating is not so the problem for me because I only want to make 
my first steps in postgres on this way (I hope I find time).
For regular updating we should wait for our db-server.

But it would be nice if you can tell me how you contact the database, in 
which language your scripts are and where they are.
So why doesn't http://cassini.toolserver.org/~kolossos/osm work (PHP) if 
it's fine on http://toolserver.org/~kolossos/osm ?

Greetings Kolossos
 


Peter Körner schrieb:
> Tim Alder schrieb:
>   
>> Nice to see the tool of Peter Körner.
>> So it seems possible to run scripts on cassini and connect to the 
>> database (postgres or mysql?).
>> Could somebody please document who it works.
>> My trys to start my php-scripts from cassini and to start psql were 
>> without success.
>>
>> I also want to develop a little text based tool that gives back all 
>> street names in alphabetic order which are in a bbox or (more difficult) 
>> in a way/relation.
>> Such a street list is part of each paper city map and the streetnames 
>> could be linked to things like Query-to-map.
>>
>> ----
>>
>> Whats the schedule for our database-server? The last date for start that 
>> I know is beginning of august.
>>
>> ----
>>
>> A question to Avar: Would it be possible for you to rendering easily 
>> also the name-variations?
>> http://wiki.openstreetmap.org/wiki/Key:name#Key%20Variations
>>
>> We had a talk in Dresden that the "old-name"-tag would be interesting, 
>> especcially in germany with its changefull in history. 
>> But to push this feature a map with it would be nice.
>>
>> Greetings Kolossos
>>     
>
> It is possible to connect to the local postgres-db, although it is very 
> outdated (it's from 2009-07-15) and not updated at the moment. It is 
> also possible to connect to the sql-servers.
>
> Tools may be written in php, perl or python, although i can't guarantee 
> that everything will work in every language right now, but i don't see 
> any problems that can't be resolve by a ticket in jira.
>
> I think i could write a beginners-guide on how to use cassini (I'd 
> propose https://wiki.toolserver.org/view/Cassini/Usage_notes) but at the 
> moment it's not too useful as the main database is not updated.
>
> I worked around this by once doing an import of all country-nodes from 
> the (outdated) postgresql-database into my mysql-db and have them 
> checked regularly against the api. This works for countries (no support 
> for new nodes, only ~230 nodes to fetch) but if you'd like to do 
> something similar on a city-level, this wouldn't work anymore.
>
> So what is needed to get the database updated? I don't think we'll need 
> a root-user to do this, just someone with write-perms on /sql and maybe 
> a file under /etc/cron.d/. I never set up a postgres-db with 
> hourly/minutely diff-support but I think I could give it a try, if this 
> would be ok. On the other hand, if someone already has experience whith 
> such a setup, he's welcome to do this.
>
> Any suggestions?
> Peter
>
> _______________________________________________
> Maps-l mailing list
> Maps-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/maps-l
>