Hi, Since the possibility of registering as a service was removed in 4D v12, how do you nowadays run 4D databases on OS X?
http://doc.4d.com/4Dv15R5/4D/15-R5/Registering-a-Database-as-a-Service.300-2948941.en.html I mean, you can start the database with e.g. an admin account via VNC and leave them running, but if the server is rebooted, they won’t start automatically. Also if you do a logout the started server process will be shutdown. With regards, Timo Kuisma Crossfade > [email protected] kirjoitti 5.6.2012 kello 21.01: > > Send 4D_Tech mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.4d.com/mailman/listinfo/4d_tech > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of 4D_Tech digest..." > > > Today's Topics: > > 1. Re: Limit 4D Write Plugin Access in Client Server (David Nasralla) > 2. Re: Web Server on Client (Julio Carneiro) > 3. Re: Limit 4D Write Plugin Access in Client Server (Scott Gelvin) > 4. [ANN] AreaList Pro v9.3 (Philippe Ganter) > 5. V13 Server error (Bob McKeever) > 6. COPY DOCUMENT Fails on Windows (Walt Seattle) > 7. Looking for 4D Contract Coding Opportunities (George Huhn) > 8. Re: V13 Server error (4d Tech List) > 9. Re: COPY DOCUMENT Fails on Windows (Charles Miller) > > > ---------------------------------------------------------------------- > > Message: 1 > Subject: Re: Limit 4D Write Plugin Access in Client Server > Date: Mon, 4 Jun 2012 22:17:59 -0600 > From: David Nasralla <[email protected]> > To: 4D iNug Technical <[email protected]> > Message-ID: > <CAHTQw=g9nzgztaqv5fsex6m3mcayxfhq1ommw4nux-qwcks...@mail.gmail.com> > > Hey John, > > What happens if you: > - Set up a second user account that is NOT in the "Correspondence" group. > - Flip every user to that account with the CHANGE CURRENT > USER("Not_Letter_Writer";"pw") > - Flip them to the other account if they have access > - Test "Current User" to verify you have them flipped. > > dave > > On Mon, Jun 4, 2012 at 10:57 AM, John Foster <[email protected]> wrote: >> Hi All, >> >> In v12.3 (windows): >> >> I have a site with about 40 plus users. Only 20 or so need to use 4D Write. >> So we only purchased a 20 block license this time. >> >> We have always had our own custom password login system that bypasses 4D. So >> I need to continue using our custom login and still limit who has access to >> 4D Write. >> >> I added a new Group called "Correspondence" and set plugin access to "4D >> Write" >> >> I added a new user called "Letter_Writer" and also set a password (not sure >> if it's needed?) and set it as a member of "Correspondence" group. >> >> I added a new boolean field to our internal user table that sets whether a >> user has access to letter writing. >> >> So... >> >> I have a routine called "Login", which handles access and returns the >> "UserID". >> >> I added a new routine which searches for the user record to see if this >> "UserID" has access to letter writing. >> >> If it comes back true (should allow access) then I set the command as >> follows: >> >> CHANGE CURRENT USER("Letter_Writer";"pw") >> >> However, when I log in with a user who shouldn't have access to 4D Write >> they still do. >> >> So I must not have set it up right? >> >> What am I missing? >> >> Thanks, >> John... >> >> -------------------------------------------------------------- >> >> John Foster >> Eternity Software >> 425-486-1622 >> >> 爃ttp://www.eternity-software.com >> >> This e-mail contains confidential & proprietary information intended for the >> use of the original addressee. 營f you are not the addressee you are hereby >> notified that any dissemination or other action in reliance upon this >> communication could result in legal liability to you and your Organization. >> >> -------------------------------------------------------------- >> >> >> >> >> >> >> ********************************************************************** >> 4D v13 is available now - with more than 200 new features to make >> your applications richer and faster >> http://www.4d.com/products/new.html >> >> 4D Internet Users Group (4D iNUG) >> FAQ: 爃ttp://lists.4d.com/faqnug.html >> Archive: 爃ttp://lists.4d.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: 爉ailto:[email protected] >> ********************************************************************** > > > > -- > David Nasralla > Clean Air Engineering > > > ------------------------------ > > Message: 2 > Subject: Re: Web Server on Client > Date: Tue, 5 Jun 2012 09:14:55 -0300 > From: Julio Carneiro <[email protected]> > To: 4D iNug Technical <[email protected]> > Message-ID: <[email protected]> > > Bill, > >> From what I gathered from David's post, his problems relate to a custom >> Webfolder. > > I never touch that in my installs, I always use whatever default 4D gives to > me there (WebFolder). I've never seem that being wiped out or anything. > AFAIK, 4D remote does not touch that folder, and you have to update the files > in there yourself. And I cannot see a good reason for using a custom > webfolder. > > My post was related to 4D Remote Web Server settings (port, ssl, web > services). > Kevin posted a roadmap to update 4D Remove (Client) web settings everytime > one deploys a new version of a 4D app to Server. > > What I observed is that those settings are saved into the structure. Then, > instead of following his roadmap upon deployment, I suggested that you do > those steps using your structure source. That'll preserve those settings > inside your source and will also be preserved on new compiles. Thus avoiding > the need to repeat the process on deployment. Do it on your structure source > once and your done. > > (maybe that affects webfolder location too, but I never tried that, as I > mentioned above) > > hth > julio > > On 06-04-2012, at 7:20 PM, Bill Weale wrote: > >> Hi Julio-- >> >> Do you happen to know if this issue has anything in common with David Adam's >> posting from last December? I'm about to update a v11 system, which uses 4D >> Remote in a DMZ for webserving, to v12 and I'd like to make it as smooth as >> possible. My first/test attempt indicated the client webserver couldn't find >> the root folder (using the same settings as the v11 version) but I didn't >> get into that as there were a couple of other issues. >> >> http://article.gmane.org/gmane.comp.lang.inug-4d.tech/116182/match=4d+v12+web >> >> Thanks, >> >> Bill >> >> >> On Jun 4, 2012, at 5:20 PM, Julio Carneiro wrote: >> >>> Kevin, >>> >>> There is a trick to avoid that. >>> >>> If you launch you source with Server and then repeat steps 1-4 with 4D >>> Remote, all the changes to 4D prefs to configure your Client Web Server >>> setup are now saved to your source structure. >>> Those setting will stay there if you compile, re-deploy. >>> >>> Besides that, you can always change the database configuration settings on >>> the fly, using specific Set Database Parameter options, to configure 4D >>> Remote we server settings. >>> >>> hth >>> julio >>> >>> On 06-04-2012, at 1:54 PM, Kevin Abraham wrote: >>> >>>> Magnus, >>>> >>>> Do you have both a license to run a Web Server on the 4D Server and 4D >>>> Remote??? >>>> >>>> We had this exact error in v11 with both the server and remote on windows >>>> along with other weird web server behavior (Get HTTP Body and Get Web Form >>>> Variables stopped working, etc.). We opened a tech support case in the US >>>> but they were unable to reproduce the problem and thus no official fix. >>>> Luckily we found a work around (See below). Our permanent fix was to >>>> upgrade to v12 making certain that we were provided with the correct >>>> licenses that time. >>>> >>>> We believed the problem was caused by being provided the wrong Web >>>> Licenses when we first upgraded to v11 (4D sent us the one for 4D Server >>>> instead of Remote and we installed it without noticing the naming >>>> difference). Thus when we got the correct License for Remote and installed >>>> it (even removing the incorrect server license), we experienced all types >>>> of weird web license errors including the specific one you list below. >>>> >>>> The work around we found needed to be done every time the structure file >>>> is updated or relaunched as follows: >>>> >>>> 1) If you are getting the error below. shut down 4D Remote and Restart 4D >>>> Remote logging in as Designer but DO NOT start the web server. >>>> >>>> 2) Launch the 4D prefs page (need to be Designer to do this and presumably >>>> you already have the command to open the page in a method connected to a >>>> menu item or something like that). >>>> >>>> 3) Click OK even if all of the prefs, port, etc. are already what you want. >>>> >>>> 4) Restart 4D Remote with whatever logon you use to start the Web Server >>>> and start the Web Server. >>>> >>>> We had to do the above on any update to the structure file or relaunch of >>>> 4D Server but if you have the same problem we did then hopefully this will >>>> work. >>>> >>>> Hope this helps! >>>> >>>> Kevin Abraham >>>> Digital Retirement Solutions >>>> [email protected] >> >> >> ********************************************************************** >> 4D v13 is available now - with more than 200 new features to make >> your applications richer and faster >> http://www.4d.com/products/new.html >> >> 4D Internet Users Group (4D iNUG) >> FAQ: http://lists.4d.com/faqnug.html >> Archive: http://lists.4d.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:[email protected] >> ********************************************************************** > > > > ------------------------------ > > Message: 3 > Subject: Re: Limit 4D Write Plugin Access in Client Server > Date: Tue, 5 Jun 2012 08:54:47 -0600 > From: Scott Gelvin <[email protected]> > To: 4D iNug Technical <[email protected]> > Message-ID: <[email protected]> > > John, > > Are normal users logging in as Designer or some other Default User? > > Scott Gelvin > Footprints, Inc. > 4D specialists since 1987 > > > On Mon, Jun 4, 2012 at 10:57 AM, John Foster <[email protected]> wrote: >> Hi All, >> >> In v12.3 (windows): >> >> I have a site with about 40 plus users. Only 20 or so need to use 4D Write. >> So we only purchased a 20 block license this time. >> >> We have always had our own custom password login system that bypasses 4D. So >> I need to continue using our custom login and still limit who has access to >> 4D Write. >> >> I added a new Group called "Correspondence" and set plugin access to "4D >> Write" >> >> I added a new user called "Letter_Writer" and also set a password (not sure >> if it's needed?) and set it as a member of "Correspondence" group. >> >> I added a new boolean field to our internal user table that sets whether a >> user has access to letter writing. >> >> So... >> >> I have a routine called "Login", which handles access and returns the >> "UserID". >> >> I added a new routine which searches for the user record to see if this >> "UserID" has access to letter writing. >> >> If it comes back true (should allow access) then I set the command as >> follows: >> >> CHANGE CURRENT USER("Letter_Writer";"pw") >> >> However, when I log in with a user who shouldn't have access to 4D Write >> they still do. >> >> So I must not have set it up right? >> >> What am I missing? >> >> Thanks, >> John... > > > ------------------------------ > > Message: 4 > Subject: [ANN] AreaList Pro v9.3 > Date: Tue, 5 Jun 2012 16:32:11 +0200 > From: Philippe Ganter <[email protected]> > To: 4D iNug Technical <[email protected]> > Message-ID: <[email protected]> > > Dear developers, > > AreaList Pro 9.3 is now available at http://www.e-node.net/alp > > AreaList Pro provides all the features you need to create sophisticated and > user interface rich list controls with 4D v11 SQL, 4D v12 and 4D v13. > > Version 9.3 is the most major release since version 9.0 (a full rewrite > offering backward compatibility with 8.x versions and many new features). > > The manual and examples have been redesigned to help mastering the powerful > AreaList Pro version 9 API. > > AreaList Pro version 9.3 is also compatible with version 8 API. > > New in version 9.3: > *Cell fill coloring > *Record numbers of selected rows/set selection using record numbers > *Row selection preservation when sorting 4D's selection of rows > *Area redraw property > *Clipping mode settings on Windows: other 4D objects can be positioned over > the AreaList Pro area > *Calculate column width from all rows > *Load record after selection change using GOTO SELECTED RECORD > *Create a set from AreaList Pro current selection > *Sending custom events to 4D > *Disable row selection (de-selection of other rows) when a click occurs in an > already selected row and no modifier keys are held down > *Roll over current column property (where the mouse is positioned) > *Roll over current grid cell property (where the mouse is positioned) > *Immediate children count in Hierarchical list display > *Row numbers of immediate children in Hierarchical list display > > License system enhancements: > *New "Merged" license. > This license is designed for compiled/merged applications (single user only). > *Text file registering. > Alternately to AL_Register, you can place a plain text file into your 4D > Licenses folder. > *The Demo mode alert dialog now includes a button to get the license > information (4D serial or Machine ID), and then put it into the clipboard > and/or a text file. > > Manual: > *Redesigned manual structure > *Redesigned Tutorial section > *Extended Troubleshooting and FAQ section > *New Working with Colors section > > Examples and Demonstration databases: > *All examples have been enhanced and documented > *Example 12 was modified in the Examples database to display a multi-level > hierarchical list > *The Demo database now includes an interface to manage cell offsets, borders, > fill colors, etc. (AreaList > Configuration Options then Format > Cell > Settings) > *Modified Drag and Drop examples to stress the need to handle the event from > the drop destination area. > *Added Example 15 to illustrate the use of all cells coordinates properties > > And many fixes, see the 9.3 release notes. > > AreaList Pro version 9.3 is compatible with 4th Dimension v11, v12 and v13 > for both Macintosh and Windows. It requires MacOS X 10.5 or higher and > Windows XP SP2 or better. > > AreaList Pro version 9.3 is a free upgrade from v9.0: existing v9.x licenses > will activate version 9.3. > > Best regards, > -- > Philippe Ganter > e-Node > http://www.e-node.net > > ------------------------------ > > Message: 5 > Subject: V13 Server error > Date: Tue, 05 Jun 2012 09:47:00 -0700 > From: Bob McKeever <[email protected]> > To: 4D iNug Technical <[email protected]> > Message-ID: <[email protected]> > > OK, this is odd. > > 4D V13 Server, all Macs 10.7. 5 clients attached. > > Suddenly, each received a message: "End Point Reached", and then the clients > quit. > > 4D Server shows all 5 still connected, but no activity. Any attempt to log in > shows the connect on server, but the client does not proceed as normal. > > Shutting down the server and restarting 'fixed' the problem, but WTF? > _________________________________________ > Bob McKeever http://www.mswl.com > McKeever's Software Wizardry > Maple Ridge, B.C. > [email protected] > > > > > > ------------------------------ > > Message: 6 > Subject: COPY DOCUMENT Fails on Windows > Date: Tue, 5 Jun 2012 10:45:06 -0700 > From: Walt Seattle <[email protected]> > To: 4D iNug Technical <[email protected]> > Message-ID: <[email protected]> > > Folks, > > I have a customer (all Windows) where the following line fails for only one > of their machines. > > 4D version 12.3 > > COPY DOCUMENT(<>PDF_SourceTest_t;<>PDF_TestFile_t) > > 4D gives the error: > > The pathname is invalid. > > File not found. (File: C:\Documents and Settings\All Users\Application > Data\"MyStructureName"\4dpdftemp\_TestFiles\testPDF.txt) > > Error -43 File not found. > > If we place a file named testPDF.txt at the above file directory location, we > get a different error: > > Unable to proceed > > The file already exists. (File: C:\Documents and Settings\All > Users\Application Data\"MyStructureName"\4dpdftemp\_TestFiles\testPDF.txt) > > Error -48 The file already exists. > Error 605 Unable to proceed. > > As I mentioned, this routine works fine on other Windows workstations, just > not on one of them. This machine is a new Win7 machine, while the others are > all WinXP. > > Any clues? > > Thanks, > Walt Nelson (Seattle) > New stuff coming! > www.4dclassroom.com > [email protected] > > > > ------------------------------ > > Message: 7 > Subject: Looking for 4D Contract Coding Opportunities > Date: Tue, 05 Jun 2012 13:44:46 -0400 > From: George Huhn <[email protected]> > To: 4D iNug Technical <[email protected]> > Message-ID: <[email protected]> > > I have just released the latest version of my vertical market application > Bubble Chart Pro�, and I am looking for new 4D contract coding opportunities. > > I have been coding in 4D since version 6. I have deep expertise in writing > custom graphics in both Canvas and SVG. For example, the Bubble Chart Pro� > charts are rendered entirely in SVG using 4D抯 SVG component, and include a > full set of drawing tools, full display preferences, and interactive objects > (double-clicks, clicks, and bubble dragging). > > All of the output forms use native 4D array list boxes and include in-cell > data editing, custom column formatting, and unlimited data change roll-backs. > You can download a demo version at my website: > > http://www.bubblechartpro.com > > In addition to standard 4D database application programming, I also have > written a variety of heuristic and stochastic optimizers in native 4D > including genetic, simulated annealing, ant, brute force, and linear > programming optimizers. I have also written code for performing complex Monte > Carlo simulations. > > If any of my experience and background might be useful for enhancing your 4D > application, please contact me outside of the iNug. > > Thanks, > > George > > -- > George F. Huhn, M.S.E, > President, Data Machines, Inc. > Blog: http://blog.datamachines.com > Follow us at http://twitter.com/DataMachinesCom > 302-529-1193 > Data Machines, Inc., 12 Penns Way, New Castle, Delaware, 19720 USA > > > > ------------------------------ > > Message: 8 > Subject: Re: V13 Server error > Date: Tue, 05 Jun 2012 13:52:05 -0400 > From: 4d Tech List <[email protected]> > To: 4D iNug Technical <[email protected]> > Message-ID: <[email protected]> > > Hi Bob, > > Its a bug, I fixed it on my machines doing this. > > > I changed the idle time out "SET DATABASE PARAMETER(Idle Connections > Timeout;0)" to zero, and haven't had a error or crash in a week ! > > http://kb.4d.com/assetid=76200 > > Hope that might hep you out. > > Ken Reinecke > Pro Audio Inc > Grandville, Michigan > > (616) 538-8585 > Fax (616) 538-6023 > [email protected] > www.ProAudioMI.com > > On Jun 5, 2012, at 12:47 PM, Bob McKeever wrote: > >> OK, this is odd. >> >> 4D V13 Server, all Macs 10.7. 5 clients attached. >> >> Suddenly, each received a message: "End Point Reached", and then the clients >> quit. >> >> 4D Server shows all 5 still connected, but no activity. Any attempt to log >> in shows the connect on server, but the client does not proceed as normal. >> >> Shutting down the server and restarting 'fixed' the problem, but WTF? >> _________________________________________ >> Bob McKeever http://www.mswl.com >> McKeever's Software Wizardry >> Maple Ridge, B.C. >> [email protected] >> >> >> >> >> ********************************************************************** >> 4D v13 is available now - with more than 200 new features to make >> your applications richer and faster >> http://www.4d.com/products/new.html >> >> 4D Internet Users Group (4D iNUG) >> FAQ: http://lists.4d.com/faqnug.html >> Archive: http://lists.4d.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:[email protected] >> ********************************************************************** > > > > ------------------------------ > > Message: 9 > Subject: Re: COPY DOCUMENT Fails on Windows > Date: Tue, 5 Jun 2012 14:02:32 -0400 > From: Charles Miller <[email protected]> > To: 4D iNug Technical <[email protected]> > Message-ID: > <CADKSfq6FJ8iM2Ef271Wgn5uK7yUMTwPpEi5gCTwJrPjS=zi...@mail.gmail.com> > > I have had these problems on windows as well. It seems that at times 4D > directory list does not see a file that was recently created. It is almost > as if the OS db containing file name location info has not been updated. I > fixed this somewhat by creating a loop to check for files existence before > trying to copy > > Hope this helps > > Chuck > > On Tue, Jun 5, 2012 at 1:45 PM, Walt Seattle <[email protected]> wrote: > >> I have a customer (all Windows) where the following line fails for only >> one of their machines. >> >> 4D version 12.3 >> >> COPY DOCUMENT(<>PDF_SourceTest_t;<>PDF_TestFile_t) >> >> 4D gives the error: >> >> The pathname is invalid. >> >> File not found. (File: C:\Documents and Settings\All Users\Application >> Data\"MyStructureName"\4dpdftemp\_TestFiles\testPDF.txt) >> >> Error -43 File not found. >> > > > > -- > ----------------------------------------------------------------------------------------- > Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 > Informed Solutions, Inc. > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D, Sybase & SQL Sever connectivity > http://www.informed-solutions.com > ----------------------------------------------------------------------------------------- > This message and any attached documents contain information which may be > confidential, subject to privilege or exempt from disclosure under > applicable law. These materials are intended only for the use of the > intended recipient. If you are not the intended recipient of this > transmission, you are hereby notified that any distribution, disclosure, > printing, copying, storage, modification or the taking of any action in > reliance upon this transmission is strictly prohibited. Delivery of this > message to any person other than the intended recipient shall not > compromise or waive such confidentiality, privilege or exemption > from disclosure as to this communication. > > > ------------------------------ > > > ********************************************************************** > 4D v13 is available now - with more than 200 new features to make > your applications richer and faster > http://www.4d.com/products/new.html > > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** > > End of 4D_Tech Digest, Vol 61, Issue 9 > ************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
