Re: Lion and WO
Right, on Lion client. The big problem is the change in the way the postgres user is set up. Evidently, it existed as 'postgres' on older versions, but it is now '_postgres' with no shell. Ramsey On Aug 6, 2011, at 10:51 PM, Johan Henselmans wrote: Op 7 aug. 2011, om 06:37 heeft Ramsey Gurley het volgende geschreven: Not entirely fine… Just in case anyone is trying to install Postgres on a clean install of Lion, you'll hit a snag at the very end of the installer that prevents the creation of the initial database and installation of the apps in /Applications. Until the Postgres people fix this in their install script, you'll need to: sudo dscl . -append /Users/_postgres RecordName postgres sudo dscl . -append /Groups/_postgres RecordName postgres sudo dscl . -change /Users/_postgres UserShell /usr/bin/false /bin/bash In Lion Server postgresql is directly available, instead of Mysql. I do not know about Lion Client, I upgrade my MacBookPro to Lion, and my macports postgresql just continued to run. I would go the macports route anyway. The first two commands will alias the underscore username with a username/group the install script expects. The third line is necessary to su to the postgres user. It seems all three are required prior to running the installer in order to get it to complete normally. Ramsey On Jul 25, 2011, at 4:24 PM, Andy 'Dru' Satori wrote: PostgreSQL is just fine in lion Andy 'Dru' Satori - all typos courtesy of fat finger and an iPad On Jul 25, 2011, at 7:15 PM, Ramsey Gurley rgur...@smarthealth.com wrote: Postgresql? On Jul 25, 2011, at 11:38 AM, Tim Worman wrote: The only problem I had was that I had to use Direct Connect in Lion - probably a config problem somewhere. I'm stuck in Snow Leopard for dev right now since my current database doesn't install in Lion. Tim Worman UCLA GSEIS On Jul 20, 2011, at 10:08 AM, Mike Schrag wrote: yes, long ago .. works fine. On Jul 20, 2011, at 1:06 PM, Simon wrote: what about upgrading a dev machine - anyone braved it yet ? On 20 July 2011 16:32, Pascal Robert prob...@macti.ca wrote: Just before people start asking. I installed Lion Server on a Mac Mini Server and the Wonder variants of wotaskd and Monitor works well. Apache WO adaptor compiles correctly too. But Java is not pre-installed, so just start any Java process (a simple call to /usr/bin/java will do) and Finder will ask you if you want to install Java. If you say so, it will download Java 1.6 (from Apple) and install it. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/simon%40potwells.co.uk This email sent to si...@potwells.co.uk ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com This email sent to msch...@pobox.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com This email sent to li...@thetimmy.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com This email sent to rgur...@smarthealth.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/dru%40druware.com This email sent to d...@druware.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/ramseygurley%40gmail.com This email sent to ramseygur...@gmail.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/johan%40netsense.nl This email sent to jo...@netsense.nl
Design question: are cross database ManyToMany relationships possible
Dear List, I've got a design question: Is it possible to manage cross database ManyToMany relationships with EOF? Googling the topic brought up: http://lists.apple.com/archives/webobjects-dev/2003/Feb/msg00395.html which gives me the faint hope that such things are possible. But then again almost all of the other search results gave me the impression that this isn't possible. Hence my question to the pros: Are such constructs possible, if so what do I have to pay attention to (Of course I tried and failed before asking this question ;-))? What are the pitfalls? If this is not possible I'd like to know what kind of solutions you use in such situations: duplicate tables (which bear the risk of divergence)? thanks cheers, Lars ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Design question: are cross database ManyToMany relationships possible
I don’t think that we ever really needed to give much thought to that. Its automatic. Karl On 2011-08-08, at 12:19 AM, Lars Sonchocky-Helldorf wrote: Dear List, I've got a design question: Is it possible to manage cross database ManyToMany relationships with EOF? Googling the topic brought up: http://lists.apple.com/archives/webobjects-dev/2003/Feb/msg00395.html which gives me the faint hope that such things are possible. But then again almost all of the other search results gave me the impression that this isn't possible. Hence my question to the pros: Are such constructs possible, if so what do I have to pay attention to (Of course I tried and failed before asking this question ;-))? What are the pitfalls? If this is not possible I'd like to know what kind of solutions you use in such situations: duplicate tables (which bear the risk of divergence)? thanks cheers, Lars ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/kgretton%40mac.com This email sent to kgret...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Design question: are cross database ManyToMany relationships possible
On Aug 8, 2011, at 5:19 AM, Lars Sonchocky-Helldorf wrote: Dear List, I've got a design question: Is it possible to manage cross database ManyToMany relationships with EOF? I believe that at the point of cross-DB-anything, you are no longer talking about what WO/EOF can do, you are talking about what the database engine itself is capable of. Can you write a query that joins across two databases in a regular SQL client? In my experience with both Oracle and MSSQL it is possible to have cross-database relationships but you have to setup some things that then have other implications, especially if the DBs are on different physical servers. The easy answer is to just use cover methods that do the same things as EOF relationships, only using fetch specifications, but then that has implications when it comes to qualifying and sorting. Dave Googling the topic brought up: http://lists.apple.com/archives/webobjects-dev/2003/Feb/msg00395.html which gives me the faint hope that such things are possible. But then again almost all of the other search results gave me the impression that this isn't possible. Hence my question to the pros: Are such constructs possible, if so what do I have to pay attention to (Of course I tried and failed before asking this question ;-))? What are the pitfalls? If this is not possible I'd like to know what kind of solutions you use in such situations: duplicate tables (which bear the risk of divergence)? thanks cheers, Lars ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com This email sent to webobje...@avendasora.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Design question: are cross database ManyToMany relationships possible
Hi Lars, Like Karl said it should pretty much just work. As long as you do not flatten such relationships and also make sure your qualifiers on either side do not include predicates from the other. In short you just need to keep in mind that EOF will generate SQL that tries to join tables from different databases. -Cail On 07/08/2011, at 23.37, Karl wrote: I don’t think that we ever really needed to give much thought to that. Its automatic. Karl On 2011-08-08, at 12:19 AM, Lars Sonchocky-Helldorf wrote: Dear List, I've got a design question: Is it possible to manage cross database ManyToMany relationships with EOF? Googling the topic brought up: http://lists.apple.com/archives/webobjects-dev/2003/Feb/msg00395.html which gives me the faint hope that such things are possible. But then again almost all of the other search results gave me the impression that this isn't possible. Hence my question to the pros: Are such constructs possible, if so what do I have to pay attention to (Of course I tried and failed before asking this question ;-))? What are the pitfalls? If this is not possible I'd like to know what kind of solutions you use in such situations: duplicate tables (which bear the risk of divergence)? thanks cheers, Lars ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/kgretton%40mac.com This email sent to kgret...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/cail%40frontbase.com This email sent to c...@frontbase.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Design question: are cross database ManyToMany relationships possible
Am 07.08.2011 um 23:37 schrieb Karl: I don’t think that we ever really needed to give much thought to that. Its automatic. Well, so i thought too (in the beginning) but in my case it didn't work in the end. So I conclude, i must have done something what this automatic did not like. Any clues anyone? Karl cheers, Lars On 2011-08-08, at 12:19 AM, Lars Sonchocky-Helldorf wrote: Dear List, I've got a design question: Is it possible to manage cross database ManyToMany relationships with EOF? Googling the topic brought up: http://lists.apple.com/archives/webobjects-dev/2003/Feb/msg00395.html which gives me the faint hope that such things are possible. But then again almost all of the other search results gave me the impression that this isn't possible. Hence my question to the pros: Are such constructs possible, if so what do I have to pay attention to (Of course I tried and failed before asking this question ;-))? What are the pitfalls? If this is not possible I'd like to know what kind of solutions you use in such situations: duplicate tables (which bear the risk of divergence)? thanks cheers, Lars ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/kgretton%40mac.com This email sent to kgret...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Design question: are cross database ManyToMany relationships possible
Am 08.08.2011 um 00:19 schrieb Cail Borrell: Hi Lars, Like Karl said it should pretty much just work. As long as you do not flatten such relationships and also make sure your qualifiers on either side do not include predicates from the other. The Dbs are two MySQL DBs on different machines, even running different versions of MySQL 5.something. I did flatten the relationships. Maybe that was the cause why it didn't work. I'll try tomorrow at work. In short you just need to keep in mind that EOF will generate SQL that tries to join tables from different databases. -Cail cheers, Lars On 07/08/2011, at 23.37, Karl wrote: I don’t think that we ever really needed to give much thought to that. Its automatic. Karl On 2011-08-08, at 12:19 AM, Lars Sonchocky-Helldorf wrote: Dear List, I've got a design question: Is it possible to manage cross database ManyToMany relationships with EOF? Googling the topic brought up: http://lists.apple.com/archives/webobjects-dev/2003/Feb/msg00395.html which gives me the faint hope that such things are possible. But then again almost all of the other search results gave me the impression that this isn't possible. Hence my question to the pros: Are such constructs possible, if so what do I have to pay attention to (Of course I tried and failed before asking this question ;-))? What are the pitfalls? If this is not possible I'd like to know what kind of solutions you use in such situations: duplicate tables (which bear the risk of divergence)? thanks cheers, Lars ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/kgretton%40mac.com This email sent to kgret...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/cail%40frontbase.com This email sent to c...@frontbase.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/lars.sonchocky-helldorf%40hamburg.de This email sent to lars.sonchocky-helld...@hamburg.de ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com