CREATE DATABASE  IF NOT EXISTS `bitnami_redmine` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `bitnami_redmine`;
-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: bitnami_redmine
-- ------------------------------------------------------
-- Server version	5.7.32-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `board_id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `subject` varchar(255) NOT NULL DEFAULT '',
  `content` text,
  `author_id` int(11) DEFAULT NULL,
  `replies_count` int(11) NOT NULL DEFAULT '0',
  `last_reply_id` int(11) DEFAULT NULL,
  `created_on` datetime NOT NULL,
  `updated_on` datetime NOT NULL,
  `locked` tinyint(1) DEFAULT '0',
  `sticky` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `messages_board_id` (`board_id`),
  KEY `messages_parent_id` (`parent_id`),
  KEY `index_messages_on_last_reply_id` (`last_reply_id`),
  KEY `index_messages_on_author_id` (`author_id`),
  KEY `index_messages_on_created_on` (`created_on`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `messages`
--

LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
INSERT INTO `messages` VALUES (1,1,NULL,'New forum','Hello,\r\nIf you have questions about the OpenOpcUaCoreServer project please post here.\r\n\r\nBest Regards\r\nMichel Condemine\r\nOpenOpcUa Project Leader\r\n',1,0,NULL,'2014-03-22 02:25:35','2014-03-22 02:25:35',0,0),(2,1,NULL,'LDS missing? OpcUa_Channel_ResponseAvailable: Request failed! (0x800A0000)','When I run my OpenopcUa-Client application for more than 5 minutes \r\nI get this errorcodes several times, for almost each callback for my MonitoredItems\r\n(about all two seconds)\r\n\r\n...\r\n\r\nOpenOpcUa:5752> OpcUa_Channel_ResponseAvailable: Request failed! (0x800A0000)\r\n\r\n...\r\n\r\nI use Windows7 and do not have installed a LDS! Is this the reason for the problem?\r\nWhen I stop my Client, the OpenOpcUsServer has lots and lots of this output:\r\nThey seem to be kept until the Client is stopped!\r\n\r\n...\r\n\r\n|4376| 12:24:47.512Z OpcUa_SecureListener_BeginSendResponse: fail with 0x808A0000\r\n\r\n|4376| 12:24:47.512Z OpcUa_Listener_BeginSendResponse failed (0x808A0000)\r\n\r\n|4376| 12:24:47.612Z OpcUa_SecureListener_BeginSendResponse: fail with 0x808A0000\r\n\r\n|4376| 12:24:47.612Z OpcUa_Listener_BeginSendResponse failed (0x808A0000)\r\n\r\n...\r\n\r\nAt startup ofthe OpenOpcuaServer I get this errorcodes:\r\n\r\n|5724| 12:31:20.147Z Your XML configuration file : .\\Opc.Ua.SimulationNodeSet2.xml has been parsed\r\n\r\n|5724| 12:31:20.147Z SetEvent.. StartSimulation\r\n\r\n|5724| 12:31:20.147Z Your XML configuration file : .\\OpenOpcUa.Simulation.xml has been parsed\r\n\r\n|5724| 12:31:20.147Z Start Post-Parsing initialization\r\n\r\n|5724| 12:31:20.147Z Start Updating inverse references\r\n\r\n|5724| 12:31:20.157Z Start Updating UAVariablesBuiltinType\r\n\r\n|5724| 12:31:20.157Z UpdateBuiltinType>You specify an incorrect NodeId: ns=0;i=887 BrowseName=EngineeringUnits\r\n\r\n|5724| 12:31:20.157Z Configuration inconsistency.Error during Built-In type update Please check you XMLs files\r\n\r\n|5724| 12:31:20.157Z Start Updating UAVariablesEncodeableObject\r\n\r\n|5724| 12:31:20.157Z Warning FindBuiltinType ns=0;i=887 failed 0x803e0000\r\n\r\n|5724| 12:31:20.177Z End Post-Parsing initialization\r\n\r\n|5724| 12:31:20.187Z Your certificate validate your server\r\n\r\nfrom: 01/08/2013 16:23:34.000\r\n\r\n\r\nto: 06/07/2018 16:23:34.000\r\n\r\n\r\n|5724| 12:31:20.187Z Could not add server certificate to the LDS store.\r\n\r\n|5724| 12:31:20.187Z Server listening at urn:NB-21.RST-AUTOMATION.local:OpenOpcUa:4CEUAServer.\r\n\r\n|5724| 12:31:20.187Z Press Q or q  and Enter to exit.\r\n\r\n|1016| 12:31:20.257Z Server Endpoint open. It\'s now listening at opc.tcp://NB-21.RST-AUTOMATION.local:16664/4CEUAServer with Binary Serializer\r\n\r\n|6832| 12:31:21.243Z OpcUa_Socket_HandleEvent: OPCUA_SOCKET_EXCEPT_EVENT: 0\r\n\r\n|6832| 12:31:21.243Z OpcUa_Channel_OnNotify: Underlying connection raised unexpected error event!\r\n\r\n|1016| 12:31:21.245Z Could not connect to server.\r\n\r\n|1016| 12:31:21.247Z DiscoverEndpoints>Channel connect to LDS failed 0x80050000\r\n\r\n|1016| 12:31:21.252Z OpcUa_SecureConnection_Disconnect: Connection in invalid state!\r\n\r\n|1016| 12:31:21.254Z DiscoverEndpoints failed uStatus=0x80050000\r\n\r\n++++\r\nThe problem seems to be this (see above)\r\n\r\n|6832| 12:31:21.243Z OpcUa_Socket_HandleEvent: OPCUA_SOCKET_EXCEPT_EVENT: 0\r\n\r\n|6832| 12:31:21.243Z OpcUa_Channel_OnNotify: Underlying connection raised unexpected error event!\r\n\r\n|1016| 12:31:21.245Z Could not connect to server.\r\n\r\n+++\r\nWill the installation of a LDS fix this problem?\r\n\r\nwith regards,\r\n  F.Haferkorn\r\n\r\n\r\n\r\n',2,0,NULL,'2014-04-01 15:00:29','2014-04-01 15:00:29',0,0),(3,1,NULL,'Informations','Bonjour, j\'aimerai savoir comment compiler ce serveur ? et quelle capacité a t\'il?\r\nmerci d\'avance',197,1,4,'2014-06-06 16:53:12','2014-06-06 17:07:53',0,0),(4,1,3,'RE: Informations','Bonjour,\r\nLe serveur peut être généré sous Windows et sous Linux.\r\nSous Windows, vous pourrez le générer en utilisant Visual Studio 2008 (OpenOpcUa 1.0.2.2)\r\nIl s\'articule autour d\'une solution OpenOpcUa_V1.sln et de quatre projets\r\n# OpenOpcUaCoreServer.vcproj \r\n# OpenOpcUaSharedLib.vcproj  \r\n# OpenOpcUaStackV1.vcproj  \r\n# XMLSAXParser.vcproj  \r\n\r\ndonc pour compiler, charger le la solution puis générer dans l\'ordre suivant :\r\n1- XMLSAXParser\r\n2- OpenOpcUaStackV1\r\n3- OpenOpcUaSharedLib\r\n4- OpenOpcUaCoreServer\r\n\r\nCordialement\r\nMichel',1,0,NULL,'2014-06-06 17:07:53','2014-06-06 17:07:53',0,0),(5,1,NULL,'Error executing OpenOpcUaCoreServer in Windows after successful build','I build the project in VS 2013 successfully, but when I go to the command line to run the output with the sample configuration (by running \"OpenOpcUaCoreServer.exe Config \" the following error pops up:\r\n\"The ordinal 3509 could not be located in the dynamic link library OpenOpcUaStackV1d.dll\".\r\n\r\n\r\nLinux works fine.\r\n\r\nTHanks\r\nCos',92,0,NULL,'2015-03-25 03:33:03','2015-03-25 03:33:03',0,0),(6,4,NULL,'OpenOpcUa','www.openopcua.org',1,0,NULL,'2016-07-01 11:02:13','2016-07-01 11:02:13',0,0),(7,4,NULL,'VIP cooperl','Après avoir testé la cooperlbox avec le VIP cooperl. \r\n\r\nJe n\'ai aucune réponse du VIP Cooperl pour le node NS=0;I=2048.\r\n\r\nIl semble que la connexion soit fermée à l\'initiative du serveur opc.\r\n\r\nTrame demande :\r\n< ---- N° sequence ----><--Taille--><---Node--><Code action ><Type>\r\n<0x00><0x00><0x00><0x01><0x00><0x0b>NS=0;I=2048      R       <0x0D>\r\n\r\n\r\nPouvez vous me confirmer que le VPI Cooperl répond à cette trame de demande ?\r\n\r\nbonne journée',269,1,9,'2016-07-18 18:37:05','2016-11-03 17:40:38',0,0),(8,1,NULL,'Segmentation fault','Bonjour,\r\n\r\nJ\'ai une erreur lors de l\'execution de la demo sur debian.\r\n\r\nCi joint une capture de l\'erreur. \r\n\r\nMErci bien et Bonne journee',277,0,NULL,'2016-08-03 12:47:04','2016-08-03 12:47:04',0,0),(9,4,7,'RE: VIP cooperl','oops voila un ancien message que j\'avais raté. \r\nLe sujet est clos maintenant. Nous avons fait des progrès.\r\n\r\nEnjoy\r\nMichel',1,0,NULL,'2016-11-03 17:40:38','2016-11-03 17:40:38',0,0),(10,6,NULL,'A quoi correspond le nom d\'un node ?','Le nom d\'un node est une notion assez vague qui ne signifie pas grand-chose. Est-ce que l\'on parle du DisplayName, du BrowseName, du nodeId ou d\'autres chose ?\r\nLa question est ouverte et j\'attends vos réponses. Cela me permettra de clarifier la situation et d\'aborder les dangers associés à une mauvaise interprétation.\r\n\r\nCordialement \r\nMichel',1,0,NULL,'2017-07-19 22:43:04','2017-07-19 22:43:04',0,0);
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-02-19 17:26:31