Multiple instances of 4D Server v17
Does anyone have experience of this type of situation? I have 3 copies of 4D Server v17 running on a Mac serving say database1, database2 & database3. I have a 2 user license for 4D server so can connect client1 to database1 and client2 to database1. When I try to connect client1 to database2 I get the message "The maximum number of concurrent users for your license has been reached.” even though database2 has no clients already connected. With older versions of 4D Server you could connect 2 users to each instance of 4D Server, no matter how many instances were active. Under v17 it seems the number of users allowed is counted across all instances of 4D Server running on that Mac server. Am I reading this correctly, or have I configured something wrongly? Has the user licensing scheme tightened up significantly with newer versions like v17? Any insights would be greatly appreciated. Michael Jarosz -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Import mysql dump into 4D v15, build database structure & import data
Hi Narinder I have found that the SQL EXECUTE SCRIPT command will import records into a pre-existing database structure. So INSERT INTO `nmiep_action_logs` (`id`, `message_language_key`, `message`, `log_date`, `extension`, `user_id`, `item_id`, `ip_address`) VALUES (1, 'PLG_ACTIONLOG_JOOMLA_USER_LOGGED_IN', '{\"action\":\"login\",\"userid\":\"707\",\"username\":\"admin\",\"accountlink\":\"index.php?option=com_users&task=user.edit&id=707\",\"app\":\"PLG_ACTIONLOG_JOOMLA_APPLICATION_ADMINISTRATOR\"}', '2019-06-12 11:23:03', 'com_users', 707, 0, 'COM_ACTIONLOGS_DISABLED'), will import 1 record into the nmiep_action_logs table with 8 fields. However it will ignore this code in the sql dump/import file CREATE TABLE `nmiep_action_logs` ( `id` int(10) UNSIGNED NOT NULL, `message_language_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `log_date` datetime NOT NULL DEFAULT '-00-00 00:00:00', `extension` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_id` int(11) NOT NULL DEFAULT '0', `item_id` int(11) NOT NULL DEFAULT '0', `ip_address` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0.0.0.0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; Do I need to write a database structure creation routine to parse this? Or has anyone written one already? Or do newer versions of 4D interpret this and create the database table and fields? Thanks Michael -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Import mysql dump into 4D v15, build database structure & import data
In 4D v15 there is an SQL EXPORT DATABASE command which exports the database as an SQL dump file. Is there an equivalent function to import an SQL dump file, create the database structure in 4D, and import the data into it? ie the equivalent of the import function in phpmyadmin? Or does anybody have some code to do this which they'd be willing to share? Michael Jarosz -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: STARTTLS - send secure email 4D v15.5
Hello Keisuke Thank you for your clarification. You imply that the only way to request a secure TLS connection is by using "0" and hope that the server requests a switch to SSL. How is it possible to tell that the email was sent securely? Is it possible to ensure that the email is ONLY sent if the connection is secure? And not sent if a secure connection is not available. Thanks Michael -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.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:4d_tech-unsubscr...@lists.4d.com **
RE: STARTTLS - send secure email 4D v15.5
Hello Mike Many thanks for your code. I wonder, have you ever used it with: $error:=SMTP_Send ($smtp_id;1) // to force use of ssl? It's when I do this that I get the timeout error and no send. Michael Jarosz -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.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:4d_tech-unsubscr...@lists.4d.com **
STARTTLS - send secure email 4D v15.5
Has anybody successfully used 4D to send secure emails via STARTTLS & a Microsoft Exchange/Office365 mailbox? I am trying to do this using 4D 15.5 and this code from the docs, but if I pass 1 in the SMTP_Send parameter I get error "10064 - no response has been received within the timeout period", and the email is not sent. $error:=SMTP_Auth ($SMTP_ID;$Username;$Password;2) // 2 for LOGIN mode // SMTP_Auth(smtp_ID;username;password;auth mode) $error:=IT_SetPort (2;587) //standard SMTP mode (non SSL?), port 587 for Exchange $error:=SMTP_Send ($SMTP_ID;0) // 0 or omitted = Do not use SSL but switchover allowed, 1 = Use SSL, 2 = Never use SSL (switchover not allowed) Any tips/recommendations gratefully received if you have successfully navigated this road before. Michael Jarosz -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.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:4d_tech-unsubscr...@lists.4d.com **
Re: Restricting a query
Many thanks Chip This is a really simple solution and works like a dream! Regards Michael Jarosz -- View this message in context: http://4d.1045681.n5.nabble.com/Restricting-a-query-tp5753437p5753463.html Sent from the 4D Tech mailing list archive at Nabble.com. ** 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:4d_tech-unsubscr...@lists.4d.com **
Restricting a query
I have a table which contains records for 10 different clients. I'd like to give a client the ability to search the table for only his records and not be able to see any of the other clients' records. Is it possible to do this using the standard 4D Query editor by always applying an additional search criteria eg clientID=xxx? Or do I need to build my own custom query editor? I'm using 4D 15.4. I'd be interested to hear how others have approached this... Many thanks Michael Jarosz -- View this message in context: http://4d.1045681.n5.nabble.com/Restricting-a-query-tp5753437.html Sent from the 4D Tech mailing list archive at Nabble.com. ** 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:4d_tech-unsubscr...@lists.4d.com **
Which 4D version is a data/structure file?
Is there an easy way of identifying which version of 4D was used to create a data or structure file? I am thinking here of when you receive a demo 4D database and you want to know which version of 4D to use to open it with. This could be any version between 2004 and v16, and I want to avoid converting it to a higher version, at least initially. Many thanks Michael Jarosz -- View this message in context: http://4d.1045681.n5.nabble.com/Which-4D-version-is-a-data-structure-file-tp5752537.html Sent from the 4D Tech mailing list archive at Nabble.com. ** 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:4d_tech-unsubscr...@lists.4d.com **
4D hosting & NHS Information Governance
We are building a 4D app that will collect data from patients in the UK and send it to their Doctor. We therefore need to handle the data safely and securely and fully comply with NHS Information Governance guidelines. I wondered if anyone has gone down this road before and could give me some guidance on the policies and precautions they put in place? In particular we are looking for a 4D hosting solution based in the UK which fully complies with NHS IG guidelines including ISO 27000 compliance and connection to the N3 network. Many thanks Michael Jarosz -- View this message in context: http://4d.1045681.n5.nabble.com/4D-hosting-NHS-Information-Governance-tp5751039.html Sent from the 4D Tech mailing list archive at Nabble.com. ** 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:4d_tech-unsubscr...@lists.4d.com **