Is there a list of dependencies with their versions to use Estimate without problems?, I have Estimate v2.1.1 in Ubuntu 20.04, mysql 8.0.30, Tomcat/9.0.31. but I get errors like ADD:System error, EDIT:System error, etc. when I try to edit costBooks. I post https://sourceforge.net/p/estimate/discussion/cs/thread/22d50df742/ two weeks ago.
Hi, I was able to install Estimate v2.1.1 in Ubuntu 20.04, generate and initialize a database, login with default credentials, and was able to import dump database for testing.I get the system error when I try to set up costBooks, I get errors like ADD:System error, EDIT:System error, etc. I already tried to disable ONLY_FULL_GROUP_BY, any idea to solve this?, thanks in advance. $ mysql --version mysql Ver 8.0.30-0ubuntu0.20.04.2 for Linux on x86_64 ((Ubuntu)) $ cd /usr/share/tomcat9/lib $ java -cp...
This may be because JRE to your machine is older than the JDK used to collect the archive app. Kindly deploy the most modern model of JDK and retry.
This is exactly the same issue that I am facing while using this extra ordinary feature can someone guide me how can I use the other sources.
This is exactly the same issue that I am facing while using this extra ordinary feature can someone guide me how can I use the other sources.
I resolved the ones issues above and posted a new trouble. I mounted MYSQL and were given the launcher to work as LOCALHOST here... But now have the errors indicated within the other remark thread.
I resolved the ones issues above and posted a new trouble. I mounted MYSQL and were given the launcher to work as LOCALHOST... But now have the errors indicated within the other remark thread.
hi, i face some proplemd installing the software. my laptop works on win 10 64bit apachi tomcat v9 ( i tried other versions with the ame error) mysql server v5.7 ( i tried latest version with the same error) i think the proplem is with .war file but i can't solve it
The errors happen in 2.10 and 2.0.0. Maybe it is a database setup problem? I have a few entries in mysql.err: 2021-02-16T19:01:44.155789Z 3375136 [Note] Aborted connection 3375136 to db: 'estimate' user: 'estimate' host: 'web-dev3' (Got an error reading communication packets) I'm not sure if that means anything. Everything else works fine as far as I can tell. Let me know which database settings would be helpful to post. I cannot delete resources from the sample costbooks, It gives the same error....
Kindly try an older version (2.1.0) and see if the error goes away.
I have a fresh install of estimate v2.1.1 with FreeBSD 12.2, openjdk11, and Mysql 5.7.26. When I try to add a resource I get an error "ADD: system error" and catalina.out shows: checkAndInsert:Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY. addMaterialToAnalysis: Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY. Checking permissions for User: 1 Menu Item:20281 appLink: CostBookAction 12-Feb-2021 00:11:17.745 INFO [http-nio-8080-exec-8] com.wanhive.basic.utils.licensing.Application.writeLog...
Thank you! Get Outlook for iOShttps://aka.ms/o0ukef From: Wanhive wanhive@users.sourceforge.net Sent: Thursday, February 4, 2021 11:47:57 PM To: [estimate:discussion] general@discussion.estimate.p.re.sourceforge.net Subject: [estimate:discussion] Re: Can't test the connection to the DB nor initialize it Don't forget to disable the only_full_group_by mode in mysql. ESTIMATE will not generate a number of reports (will report database error) if this mode is enabled. https://sourceforge.net/p/estimate/discussion/cs/thread/232f98b4/#1890...
Don't forget to disable the only_full_group_by mode in mysql. ESTIMATE will not generate a number of reports (will report database error) if this mode is enabled. https://sourceforge.net/p/estimate/discussion/cs/thread/232f98b4/#1890
Got it working!!
is there any documentation on how to configure the database to run with this program?
Your Mysql database server is misconfigured/corrupted. Quoting from your log: Storage engine 'InnoDB' does not support system tables. [mysql.user]
so when i initialize the database this is what I get in the stdout log. Error log attached as well. 2021-02-03 13:00:13 Apache Commons Daemon procrun stdout initialized. Initializing basic parameters Application Started in: C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\estimate\ License validated succesfully Max number of Sessions configured to: 10 INITIALIZATION COMPLETE Active Sessions: 0 Active Sessions: 1 License Agreement Accepted LOADING LICENSE.... testConnection: SUCECSS...
Hello Hovlord69, That log shows nothing exceptional. The server seems to have started normally. Please review the log just after the database initialization failure occurs. The log should contain exception messages and stack traces for proper diagnosis.
I see a warning regarding threads from the estimate app. log is attached Any help would be appreciated.
Kindly use the debug information in the log generated by the tomcat server to diagnose and fix the issue. Database initialization can fail for several reasons.
I connect to the server but cant initialize the database. What have I entered wrong?
Hello, This may be because JRE on your machine is older than the JDK used to compile the archive. Kindly install the most current version of JDK and retry.
I'm in the same status as above, but my error is: " FAIL - Application at context path [/estimate-v2.1.1] could not be started", and the answer to your question above I placed a copy of estimate-v2.1.1.war in webapps folder of tomcat 9.0, added "C:/ESTICON" as System Variable and named it "ESTICON" what could I've done wrong?
Which file are you trying to deploy? Make sure that the archive you are trying to deploy is a WAR (the downloaded file should have a .war extension). ESTIMATE 2.1.1 is compatible with the Apache Tomcat version 9. Make sure that you have the most recent versions of Tomcat and MySQL.
I have Tomcat and MYSQL installed but when I try to start Estimate 2.1.1, I get this error.
My gosh so many users crying to install this! The is a pain to install but the software looks promising. In the age of .deb and .exe files, setting this up is a nightmare. Using this on linux is a worse experience. People who do not understan mysql and tomcat, this is very difficult to setup. The best tutorial would be to make youtube video for dummies! FYI stuck at the "database setting" stage and getting "Database Initialization Failed" srror. After spending a full day, I give up!!!!!! Somethign...
Hello Jeff, The error is being caused by the InvalidConnectionAttributeException due to some sort of Time Zone issue (EDT). This is a known bug in several MySQL drivers and JDBC. https://bugs.mysql.com/bug.php?id=85816 Setting the MySQL server time zone to UTC or something which Java 8 recognizes resolves the issue. NOTE: Kindly use the newly released WAR (version 2.1.1).
Hello Jeff, The error is being caused by the InvalidConnectionAttributeException due to some sort of Time Zone issue (EDT). This is a known bug in several MySQL drivers and JDBC. https://bugs.mysql.com/bug.php?id=85816 Setting the server time zone to UTC resolves the issue. NOTE: Kindly use the newly released WAR (version 2.1.1).
Hello Jeff, The error is being caused by the InvalidConnectionAttributeException due to some sort of Time Zone issue (EDT). This is a known bug in several MySQL drivers and JDBC. https://bugs.mysql.com/bug.php?id=85816 Setting the server time zone to UTC resolves the issue.
First of all, I would like to thank you for helping me try to get this going. But it is still not working. I have attached my catalina log files to see if you can figure it out. I did get an error that it couldn't create the database, so I created it manually.
Hello Jeff, Just finished testing the application on Ubuntu 20.04 LTS. Looks like the old mysql driver shipped with the ESTIMATE (it is version 5.1.33) is not supported by the current version of MySQL server. Replacing the MySQL driver with the most recent release resolved the issue. Thanks for bringing this issue to our notice. UPDATE: We have released ESTIMATE version 2.1.1 to fix this issue. The newer version is shipped with MySQL java connector 8.0.21 and has been optimized for Apache Tomcat...
Hello Jeff, Just finished testing the application on Ubuntu 20.04 LTS. Looks like the old mysql driver shipped with the ESTIMATE (it is version 5.1.33) is not supported by the current version of MySQL server. Replacing the MySQL driver with the most recent release resolved the issue. Thanks for bringing this issue to our notice.
Thanks for the input. I changed the username to root to make sure it had permissions and it gives me the same error. I think it may have something to do with the ssh tunneling. Just not sure what to change. I have tried the settings in the picture and I have tried the ip address of the actual server which is the same as my ssh server ip.
Hello Jeff, During database initialization, the application attempts to create (if don't exist) the database and the tables. This step will fail if the given database user doesn't have sufficient permissions. Make sure that the user credentials you provided has full access to the database (estimate in your case) at the given address (localhost in your case) and then try to initialize the database.
I am installing on Ubuntu 20.04 server. I tunneled using MobaSSHTunnel to get the setup started but I cannot get it to connect to my database. I have tried localhost:3306 and the actual server address of my server and it will not connect. Do I need to create a separate tunnel to get to the database server? If so, can someone tell me how to configure it? Any help is much appreciated.
The easy part: Switching from from Metric to Empirial system is trivial and only requires inclusion of the "Imperial units" in the list of units available for the Assemblies. Now the slightly tough part While preparing definitive estimates, calculations and conversions in metric system are quite simple and don't require any special logic. Low complexity means lower chance of errors and bugs. Not so easy in case of the Imperial system, e.g. inch-to-feet conversion. Solution The tough part can be dealt...
how does one change the Units to Imperial from metric ? i had to google what a CUM was lol thank you !
Sir My sql version is community 8.0.19.0
Hello, The Tomcat console error suggests that error was encountered while trying to connect with the MySQL database server on localhost. The database server has been rejecting new connection request on localhost from the user named root having the given password during handshake. Check that the database server is running on the given port (3306 in your case) Check that the root user has access to the database server with the given password on localhost (MySQL server treats localhost and 127.0.0.1...
Hello, The Tomcat console error suggests that error was encountered while trying to connect with the MySQL database server on localhost. The database server has been rejecting new connection request on localhost from the user named root having the given password during handshake. Check that the database server is running on the given port (3306) Check that the root user has access to the database server with the given password on localhost (MySQL server treats localhost and 127.0.0.1 as separate...
Hello, The Tomcat console error suggests that error was encountered while trying to connect with the MySQL database server on localhost. The database server has been rejecting new connection request on localhost from the user named root having the given password during handshake. Check that the database server is running on the given port (3306) Check that the root user has access to the database server with the given password on localhost (MySQL server treats localhost and 127.0.0.1 as separate...
Sir i have tried many ways its still not working !! I thing database i not able to connect please help
Sir i have tried many ways its still not working !! I thing database i not able to connect please help
This is the tomcat console error
my sql
Your observations are incorrect. There is no Admin user in ESTIMATE. In fact ESTIMATE uses a radically different access control strategy than the traditional "Role based" one. ESTIMATE allows configuration of user access to each individual function/feature of the application and default user created on start has full access to all application features/functions. Every new user is assigned abc as default password including the default user created at start, which can be changed by the user through...
Ok, this seems like a bizarre design choice. Seems users need full admin rights in order to change their own password. I'm evaluating Estimate as an alternative to a big, bulky, expensive estimating system that is causing users grief and causing the boss to pull his hair out at his inability to get the vendor to see any sort of sense. However, this is a deal breaker. And giving everyone the same password when creating new users? Asking for trouble. At least allow us to specify a password, it's surely...
Click on "Initialize database" and then "test connection"
EDIT: The database URL is illegal, it must start with jdbc:mysql:
The database URL is wrong.
Hi Can't connect to database please help
Hi can't connect databese mysql all correct but still can't connect to database please help
Hello, Are you starting tomcat from the terminal? Is it running as a service? Tomcat running as a service reads the environment variables differently than Tomcat started from terminal. On top of that, the program should have write permission to the directory pointed by ESTICON because it stores it's settings inside that directory. Just because such directory exists doesn't mean that it is writable from the POV of Tomcat (I don't think that Tomcat allows web applications to modify the webapps directory)....
Hi I've being getting a lot of trouble trying to install estimate. First, I haven't seen any step by step official guide on how to install it, documentation seems to come with the .war file instead of a easily available guide or Readme, and I don't think it's nice to browse into a forum to get an idea of how to install the thing. But after some hours trying different things I've managed to set up tomcat and run the .war and had to, finally, run the configure process from the localhost (again, seems...
Michael, This is a work in progress. In addition to user friendly packaging, the application needs a makeover because although it is extremely stable in its current form, it needs to keep up with the emerging trends, expectations and technologies. In short, we are coming up with something which will be user friendly, robust and futuristic. We will try to maintain the minimalistic approach, that is do one thing and do it right. Thanks for your patience.
has there been progress on making a fully configured basic setup a person can just install simply like inside a pre-packaged virtual machine download to run on the correct OS with everything done right? That is the most important thing here. and makes it worth money to someone like me. I'm happy to shell out a few hundred dollars at least.. more if its fairly simplified. up to $1,000 if the software is working and has some template options and email support. On Wed, Apr 3, 2019 at 2:39 AM Wanhive...
You need to: 1. Add an environment variable ESTICON (case sensitive) and set it's value as absolute path to a writable directory, ESTIMATE will use that directory to store it's configuration files. This can be done either via Operating System or via setenv.bat/setenv.sh file inside tomcat server's bin directory (you may need to create one if one doesn't already exist). 2. Alternatively, you can define ESTICON as JVM's property (please refer to tomcat's manual).
You need to: 1. Add an environment variable ESTICON (case sensitive) and set it's value as absolute path to a writable directory, ESTIMATE will use that directory to store it's configuration files. This can be done either via Operating System or via setenv.bat/setenv.sh file inside tomcat server's bin directory (you may need to create one if one doesn't already exist). Alternatively, you can define ESTICON as JVM's property (please refer to tomcat's manual).
Hello, Sorry for late response. You need to configure the application before using the default username and password.
Hi Amit, I stuck here. Tried with default username and password but couldnot login. Please help ? Thank you, Niranjan
Good morning Amit, Can you help me to solve the issue please? i couldnot configure though i made ESTICON folder on writable drive.
That is a valid suggestion. We will look into it.
OK i will try.. but really you need a better system to deploy.. Like a pre-made setup, already operating in a virtual machine that you can clone and let people download... so we can just install a virtual machine app and deploy in one go.
Hello Michael, This is not an issue with the web application but with the Apache Tomcat server. The application sees what Tomcat allows it to see. Usually if a program (Tomcat in your case) is not installed within the Program Files directory, Windows doesn't allow it to modify the files and directories in the C drive for some unknown reason. Please try another directory for ESTICON outside the C drive and see if that works. If you are running Tomcat as a service it may not be able to access the environment...
Hello Michael, This is not an issue with the web application but with the Apache Tomcat server. The application sees what Tomcat allows it to see. Usually if a program (Tomcat in your case) is not installed within the Program Files directory, Windows doesn't allow it to modify the files and directories in the C drive for some unknown reason. Please try another directory for ESTICON outside the C drive and see if that works. If you are running Tomcat as a service it may not be able to access the environment...
Hello Michael, Usually if a program (Tomcat in your case) is not installed within the Program Files directory, Windows doesn't allow it to modify the files and directories in the C drive for some unknown reason. Please try another directory for ESTICON outside the C drive and see if that works. If you are running Tomcat as a service it may not be able to access the environment variable in usual manner, please refer to Tomcat's documentation for alternatives (e.g. setenv.bat) ALTERNATIVE: ESTICON...
Yes, I resolved those issues above and posted a new issue. I installed MYSQL and got the launcher to work as LOCALHOST... but now have the errors indicated in the other comment thread. I will bring them here for organization. i set environment variable, am running TOMCAT 9 and MYSQL, and still get these two system settings i dont know how to alter.
I have set ESTICON variable in win10 and have the program launching but it wont get past pressing CONFIG button. Two errors.. Environment variable not set, and license path not set or writeable?>
Hello Michael, Please confirm the following: Do you have the most recent JDK installed on your system? Tomcat needs JDK to compile the jsp files. Have you deployed the binary package (the one having .war extension)?
Installed Tomcat9 and new JRE8... Attached screenshots. Just a whole list of errors.
Hello, Looks like the database connection manager is giving up after few failed attempts to connect with the mysql database server (default: 3 attempts). You can view the exception generated by the application in apache tomcat's log.
Hello, I have tried installing the estimate software and I keep running into a brick wall during the database setup. I have installed mySQL 64-bit. Test Connection error message: Failed (Connection error 'or' database not initialized) Initialize Database error message: Database Initialization Failed Used both URLs jdbc:mysql://127.0.0.1:3306 jdbc:mysql://localhost:3306 If there is a way to enable debugging do get a better response that would be great. Using root username and credentials for mysql...
Chris, Please share relevant screenshots, that will allow us to diagnose the problem. Do you see the following on the page after agreeing to the license T&C (both entries must carry a green tick icon)?
Chris, Please share relevant screenshots, that will allow us to diagnose the problem. Do you see the following on the page after agreeing to the license T&C?
Thanks, yes ESTICON is a folder I created and I have set read &write privileges for everybody.
Thanks for the reply. The file name is setenv.sh Tomcat is started via terminal text in the file is: ESTICON= “/Users/ESTICON” export ESTICON the file path is what i copied the file path in finder I ran the command 'chmod 777 setenv.sh' to make it executable still no progess thanks
Hello, The pathname may be case sensitive. Please make sure that /Users/ESTICON is a valid directory and is writable. ESTIMATE doesn't create the directory.
Thanks for the reply, Yes file name is setenv.sh and tomcat is started via terminal The file contains this: ESTICON= “/Users/ESTICON” export ESTICON I tried the two commands to make it executable still not working Thanks
After creating setenv.sh, please make sure that the "executable" permission flag is set on the file. for example(allows read/write/execute permission to all): chmod 777 setenv.sh or(owner: read/write/execute; group:read/execute; other: read) chmod 754 setenv.sh
Hello Chrish, Your checklist: 1. Is the file named setenv.sh (tomcat should be started via terminal, if tomcat is started as a service then it may have a different mechanism for loading the environment variables). 2. Does the environment variable ESTICON (case sensitive) point to a writable directory (alternatively, ESTICON can be set to be a JVM property). 3. Consult apache tomcat's documentation for the specific version on your machine.
Hi, I am working through the set up on osx el capitan and have got as far as succesfully deploying estimate on tomcat. I followed your instructions further up the thread about creating a file for environmental variables in the bin folder and copying my file path in to it, which was to a folder I called ESTICON but its still not working, maybe im missing something, so close but so far.
Hello, Sorry for the delayed response. Please refer to the discussions on the following thread: https://sourceforge.net/p/estimate/discussion/cs/thread/7a3c22eb/
Hi. I'm trying to run Estimate 2.1.0 on tomcat7, under Ubuntu 14.04 Server, I've installed it wth no proplems, I see the logon screen, but i cannot log in. The problem is there is no GUI on the machine running Tomcat & Estimate, so I cannot use any kind of RDP, SSH terminal only. Only command line, only hardcore. So, I can change any config files on the host machine, or can run config from web-browser under remote machine. So. What should I do in order to configure the database, user acces and so...
Hello Tameem, Please check the name of the war file you are deploying in tomcat. In your case it should be renamed to estimate.war Best Regards,
I got same issue, I double checked, the system variable has been created and pointed to an empty directory in D drive. But the configure terocess can't detect them (both marks are "x"). I am running it on win 7, using xampp (Tomcat 7.0)
Hi Amit, I am trying to install estimate aaplication. I have installed Tomcat and MySQL. Deployed .war file in tomcat webapp folder. When accessing file from localhost, i am facing an error (see attached file) Tomcat is running on 8181 port. Let me know if you have a solution for this issue. Regards, Tameem
Dan Repeat the same process like you did for database configuration, however this time complete the Application Configuration on the laptop computer and copy the generated settings (a properties file) to the raspberry pi machine. The input box of interest is named "Number of license", it controls the number of allowed sessions. InstallationId is immaterial in the community edition.
Just wanna say thank you for all the hints/help. I chosed option 2. It's working now on the pi. Now I can try your software. Thank you very much so far. Edit: Next "problem". I can't change the "Number of Active Users: 0/1". I'm trying to change the file configuration.properties especially installationId= Where can I find the "installationId"? The "configuration.properties" is from my laptop. I think I have to change the app ID to my raspberry app Id. I was looking at some files from the webapps/estimate...
Just wanna say thank you for all the hints/help. I chosed option 2. It's working now on the pi. Now I can try your software. Thank you very much so far. Edit: Next "problem". I can't change the "Number of Active Users: 0/1". I'm trying to change the file configuration.properties especially installationId= Where can I find the "installationId"? The "configuration.properties" is from my laptop. I think I have to change the app ID to my raspberry app Id. I was looking at some files from the webapps/estimate...
Just wanna say thank you for all the hints/help. I chosed option 2. It's working now on the pi. Now I can try your software. Thank you very much so far.
Dan, For that purpose you will need to put your developer hat on. 1. If you don't want to install MySQL on your laptop machine then please take a peek inside WEB-INF/classes/ directory of the WAR archive, there you will find two files named schema and data. The schema file provides the database schema and can be executed directly without modification, while the data file uses $ character as delimiter which will need to be replaced with ; character to turn the file into a legal sql file. Execute them...
Dan, For that purpose you will need to put your developer hat on. 1. If you don't want to install MySQL on your laptop machine then please take a peek inside WEB-INF/classes/ directory of the WAR archive, there you will find two files named schema and data. The schema file provides the database schema and can be executed directly without modification, while the data file uses $ character as delimiter which will need to be replaced with ; character to turn the file into a legal sql file. Execute them...
Dan, For that purpose you will need to put your developer hat on. 1. If you don't want to install MySQL on your laptop machine then please take a peek inside WEB-INF/classes/ directory of the WAR archive, there you will find two files named schema and data. The schema file provides the database schema and can be executed directly without modification, while the data file uses $ character as delimiter which will need to be replaced with ; character to turn the file into a legal sql file. Execute them...
Understood ... finally. I tried it on the Laptop Arch which is without mysql. Configure-button is visible. So, server ip isn't possible. To set it up from the laptop aka 192.168.1...:8080 (raspberry ip) Any chance to configure the database in a command/terminal? I haven't a desktop-gui on the raspberry pi. Thank your very much!