7 posts in this topic
migration advice needed for worker machine to xml or php
By Joost Miltenburg
We currently have this worker machine running, but I want to get rid of it. The worker runs a FM-script every 5 mins and exports some data, which is then uploaded to an ftp server and then processed by the website.
The script does several xml-exports. It starts by searching for certain products , then it exports the data to and xml file ( xml-result ). After that is does a go-to-related script-step ( matching all records ) to commercial descriptions of the products and then exports this data as an xml file. We go back to the found set of products and then repeat the proces for more related product data.
As said, all data is exported and the uploaded to an ftp-server.
Preferably I would like to keep the xml-result structure of the data as the website is already familiar with this structure.
How do I go about doing this migration. I was able to perform an xml-query and get my result. The thing is : how do I proceed with these goto-related records finding ?
Or should I just go with PHP ?
Much thanks in advance !
Now how can users change passwords?
Long story short.) I'm moving a complex solution from a local network to a hosted service. The solution uses (and needs to use) external authentication. In order to divorce the solution from the local network completely, we will no longer be using our active directory on the local network. Setting up security groups and users on the hosted server and configuring FM server to authenticate against it was very easy. Only one problem remains, How can users change their passwords?
This isn't really a Filemaker question as the question becomes, how can you let a user change their password on windows servers if they do not have desktop access(on the server)?
I have done a couple of google searches and found enough to know I could write some sort of custom solution (or likely adapt one that is already out there) but before going down that rabbit hole.... I thought I would ask the helpful people here.
Testing server for this site does not map to the ... URL
I'm getting a URL Prefix error when trying to connect to the database. I'm a newbie with FMStudio Pro.
I've attached screenshots to show the issue.
FIleMaker Pro 12 Advanced
FileMaker Server Advanced installed on windows server
Where to look to fix PHP
So, We have a unix admin working on our Mac OSX server. I specifically instructed them not to break our Filemaker 13 Apache install. Well it looks like they worked on the machine but broke one thing.
Does anyeone know where I should look to fix this?
Webserver servers files fine from the Filemaker HTTP Folders.
Filemaker WebDirect works fine.
PHP is working.
PHP is indicated as ON in FMSA Admin.
Admin pages at http://localhost:16001/admin-consolework fine.
Admin screen shows green on Webserver. Indicates PHP is enabled.
This is the only thing that is not working:
Previous PHP pages which has successfull connection to databases no longer connect to the database.
I assume that a reference to filemaker somehow got removed from one of the php config files, but I don't know where.
Can anyone give me an idea where to look?
Possible to implement privilege set security in table based login via PHP?
Hello FMP security experts!
Is it possible to lock down records "per user" in a database that is accessed via a PHP web interface that uses a table based login (as opposed to an "Account based" login)?
The database needs to allow for multiple users who can only access their own records. This is no problem with an account based solution where the concept: Get(AccountName) = RecordOwner is used within the privilege set to only allow the active user access to his/her own records. However, since this solution needs to scale to around 100 users, I considered using a table based login in order to ease account management for that many users.
The problem is that since the table based login uses a single "default" style login, let's call that login "webuser", if I use Get(AccountName), it's not actually reflective of the user actually logged in! I just can't seem to get my head wrapped around this. I tried using a field called "AccountName" in the User table so that AccountName = RecordOwner could still be used for the privilege set security setting, but since the records are always related to the AccountName of the user that created them, this equation (AccountName = RecordOwner) always rings true and allows for all records to be viewed by everyone logged in.
The unique factor in the Get(AccountName) security paradigm is that the active "Account Name" might not be the same as the Record Owner name which allows or disallows access. However, using a field in the User table creates a scenario where if that User and their records are related, they are always related. I haven't been able to come up with a way to say: if the user is "webuser", then make the current account = the actual active account. Then use this info to limit viewing within the privilege set.
Is this scenario even possible at all using PHP with table based logins? If not, I'll stop trying, lol! If it is, I need some help seeing how to do it.
One last question, even if it is possible to do this via table based logins, should I be using Account based logins anyways?
Thanks in advance for your help!