How to Install Open. Maint on Ubuntu 1. MAINT is an open source platform for facility and property management of all scales and industries. It is which can be used for the management of infrastructure, assets, buildings, and other professional equipment. It also helps in streamlining the maintenance processes and allows to make decisions while allocating resources for the new projects. Pgadmin3 Installation DefinitionOpen. Maint is designed and configured with its powerful tools like its dashboards, inventory control, reports, and tracking and history records. Typically businesses operating in construction, manufacturing or transport services can integrate this seamless software into their systems and gear the day to day operations through it. It is customizable according to the needs of the organizations. It helps in the management of orders to the right team or supplier and offers planning, execution, and registration of intervention reports, preventive maintenance, mobile access, planning calendar, and others. It also includes financial management, logistics management, service history tracking, GIS and BIM support. The software was designed and launched by Tecnoteca SRL headquartered in Italy. In this article, we show how to install openmaint on Ubuntu 1. Prerequisites. We need the following software packages to be installed on our system for the successful setup of Open. Maint. The minimum and suggested requirements for open. MAINT software setup are mentioned below. Install Tomcat 7. First of all, we are going to install Apache tomcat version 7, alongside its additional packages on our Ubuntu server by using below command apt get install tomcat. Press y key and Enter to confirm the installation of Tomcat. Once installed, you can test if its working fine by opening the link below in your browser, with the default port 8. For questions, discussion and knowledge sharing pertaining to the SQL Query Language e. MS SQL, MySQL, Access Queries and Crystal Reports. Disclaimer This page is not a recommendation to remove SyncThru Admin 6. Samsung Electronics Co., Ltd. SyncThru. If youre using it on a local server, use localhost. If its all good, you will see a message like It works. Now, we lets set up the roles for tomcat manager webapp to enable us access the control panel in the future. Clear the contents of the file and paste the following text in there lt UTF 8. Take note of the username and password entry. Youll need it when accessing the manager webapp at http serverIP 8. IP 8. 08. 0host managerhtml. Install the Java Development Kit. To install JDK on Ubuntu 1. Open. JDK 8. apt get install default jdk. Press y to continue installing JDK on Ubuntu, this enables us to develop Java applications to run on our Tomcat server. Next, we will be installing Apache Ant, which is used to build Java applications, and a source control system, git, using the command below. Install Postgre. SQLNow, we need to install and setup Postgre. SQL, as the most of open. MAINT depends on it. Well first install postgresql and its additional packages by typing the following command apt get install postgresql postgresql postgresql contrib. This will create a new user on your PC with the name postgres. Set your password for this account using the command below and take note of it as youll need it later in the setup and also to log in to your postgres user account. After that, we will install a web administrator tool to manage Postgre. SQL database, and this can be installed using command apt get install pgadmin. Use the command below to find more modules i. Post. GIS, procedural languages, client interfaces, etc to install. Postgre. SQLDatabase server setup. Now we have successfully installed Postgre. SQL database server, lets connect to the user postgres and create a database which well use to setup open. MAINT soon. su postgres. When youre asked for a password, use the one you set in step 3 above. Now go ahead and set a password for the postgres database user. Replace newpassword with the password youll use for the database. ALTER USER postgres WITH PASSWORD newpassword Now lets create a database for open. MAINT. In our case, well use postgresqldb as our database name. To connect  to your database, enter psql postgresdb. Type q to disconnect from the database and type exit to logout from postgres back to your normal user account. Install JODBCJava is platform neutral, it is a simple process of just downloading the appropriate JAR file and dropping it into your classpath. Lets download the required version, which can download by using link to Postgre. SQL JDBC Driver. We will use below command to get the required JDBC driver. Next, using below command copy this to the tomcats lib directory. Orange Oracle Keygen Photoshop. Download and Install Open. Maint. The latest version of Open. Maint can be downloaded from their official web page. Once you have downloaded the package, then extract it, enter the directory, and copy the libraries in extrastomcat libs using below commands. Then copy openmaint version. Then we will copy cmdbuild shark server version. The. war files will extract, after which you can delete them by entering the following command rm r varlibtomcat. Now restore the database in the open. MAINT database folder to the database your earlier created. To do this Open the dash and type pgadmin. Enter. Click the Connect button and connect to your Postgre. SQL server by filling the required parameters. Under the postgres user account, expand the databases, right click on the database you created and select Restore. Now, choose any of the database files in the openmaint folder, select postgres under rolename, and click Restore. The process status will exit with 0 if the database has been restored. Open. Maint Web Installation Wizard. All the files are in place, now we will go through its web installation wizard, which can be carried out by opening the following URL followed by the IP address of our server and port 8. In our case, well use localhost. Edit the context. Shark and change the database name from cmdbuild to the name you gave to your database. You can use your favorite text editor or type gedit varlibtomcat. META INFcontext. Now edit the Shark. Shark. conf. Now, restart the Tomcat application server service tomcat. Now lets begin with the actual openmaint installation. In your browser, visit the following website http locahost 8. Lets configure the basic web configurations after opening the mentioned URL in your web browser as shown below. Next, we need to configure database settings and then test the connection, if it works good, then click on the Finish button at the bottom right corner and youll be directed to the login page. Access to Open. MAINT Dashboard. After successful Database connection testing, refresh your web page and you will the login page as shown below. You can use below credentials to log in to your Open. Maint Dashboard. Username admin Pass admin. Username demouser Pass demo. After giving the right credentials, you will see its management console where you can now manage your assets and inventories. Click Administration Module and go to Setup Workflow Engine and check the Enabled box and fill the Server URL field with the URL of shark e. Click on Save to commit the changes. Conclusion. Open. MAINT is a useful application for medium and large organizations to manage their mobile assets like machinery, engineering, furniture, etc. In real estate industry, it can be used to maintain the data of buildings, infrastructure, and maintenance etc. It can also be useful related to other maintenance activities related to planning and in the case of its failure and logistical and economic. It is all in one solution, configured with workflows, reports, and dashboards that can be activated gradually by the needs of each organization and available resources. Howto setup Database Server With postgresql and pgadmin. Sponsored Link. Postgre. SQL is a powerful, open source relational database system. It has more than 1. It runs on all major operating systems, including Linux, UNIX AIX, BSD, HP UX, SGI IRIX, Mac OS X, Solaris, Tru. Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures in multiple languages. It includes most SQL9. SQL9. 9 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for CC, Java,. Net, Perl, Python, Ruby, Tcl, ODBC, among others. Admin III is the most popular and feature rich Open Source administration and development platform for Postgre. SQL, the most advanced Open Source database in the world. The application may be used on Linux, Free. BSD, Open. SUSE, Solaris, Mac OSX and Windows platforms to manage Postgre. SQL 7. 3 and above running on any platform, as well as commercial and derived versions of Postgre. SQL such as Enterprise. DB, Mammoth Postgre. SQL, Bizgres and Greenplum database. Admin III is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all Postgre. SQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server side code editor, an SQLbatchshell job scheduling agent, support for the Slony I replication engine and much more. Server connection may be made using TCPIP or Unix Domain Sockets on nix platforms, and may be SSL encrypted for security. No additional drivers are required to communicate with the database server. Install Postgresql and pgadmin. Ubuntu. Postgre. SQL 8. Ubuntu 7. 1. 0 Gutsy Gibbonsudo apt get install postgresql 8. This will install the database serverclient, some extra utility scripts and the pg. Admin GUI application for working with the database. Configuring postgresql in Ubuntu. Now we need to reset the password for the postgres admin account for the serversudo su postgres c psql template. ALTER USER postgres WITH PASSWORD password template. That alters the password for within the database, now we need to do the same for the unix user postgres sudo passwd d postgressudo su postgres c passwd. Now enter the same password that you used previously. Admin and command line access as the postgres user to run the database server. But before you jump into pg. Admin we should set up the Postgre. SQL admin pack that enables better logging and monitoring within pg. Admin. Run the following at the command linewe need to open up the server so that we can access and use it remotely unless you only want to access the database on the local machine. To do this, first, we need to edit the postgresql. Now, to edit a couple of lines in the Connections and Authentication section. Change the linelistenaddresses localhosttolistenaddresses and also change the linepasswordencryption ontopasswordencryption on. Then save the file and close gedit. Now for the final step, we must define who can access the server. This is all done using the pghba. Comment out, or delete the current contents of the file, then add this text to the bottom of the file. DO NOT DISABLE If you change this first entry you will need to make sure that the database super user can access the database using some other method. Noninteractive access to all databases is required during automatic maintenance autovacuum, daily cronjob, replication, and similar tasks. Database administrative login by UNIX socketslocal all postgres ident sameuser TYPE DATABASE USER CIDR ADDRESS METHOD local is for Unix domain socket connections onlylocal all all md. IPv. 4 local connections host all all 1. IPv. 6 local connections host all all 11. Connections for all PCs on the subnet TYPE DATABASE USER IP ADDRESS IP MASK METHODhost all all ip address subnet mask md. IP address of the machine that you would like to access your server i. However, if you would like to enable access to a range of IP addresses, just substitute the last number for a zero and all machines within that range will be allowed access i. IP address 1. 38. Thats it, now all you have to do is restart the serversudo etcinit. Thats it you can start using postgresql in Ubuntu. Create a Database from command line. You can also use pgadmin. To create a database with a user that have full rights on the database, use the following commandsudo u postgres createuser D A P mynewusersudo u postgres createdb O mynewuser mydatabase. Sponsored Link. Related posts.