Activity for Wanhive
-
Wanhive posted a comment on discussion Community Support
Kindly try an older version (2.1.0) and see if the error goes away.
-
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
-
Your Mysql database server is misconfigured/corrupted. Quoting from your log: Storage engine 'InnoDB' does not support system tables. [mysql.user]
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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...
-
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...
-
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...
-
EDIT: The database URL is illegal, it must start with jdbc:mysql:
-
The database URL is wrong.
-
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)....
-
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.
-
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.
-
That is a valid suggestion. We will look into it.
-
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...
-
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)?
-
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.
-
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?
-
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.
-
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.
-
Hello, Sorry for the delayed response. Please refer to the discussions on the following thread: https://sourceforge.net/p/estimate/discussion/cs/thread/7a3c22eb/
-
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,
-
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.
-
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...
-
Dan, The 1 in 0/1 is the number of allowed user sessions (how many users can access/use the application concurrently) it defaults to 1, which makes sense because at least one person must be allowed to use with the application. It can be increased during Application Configuration process to "say 15" which will allow 15 persons to log into the application and use it concurrently (you can have as many registered users as you like however only 15 users will be allowed to log into the application at a...
-
Dan, The 1 in 0/1 is the number of allowed user sessions (how many users can access/use the application concurrently) it defaults to 1, which makes sense because at least one person must be allowed to use with the application. It can be increased during Application Configuration process to "say 15" which will allow 15 persons to log into the application and use it concurrently (you can have as many registered users as you like however only 15 users will be allowed to logn into the application at...
-
Hello Dan, That is not supposed to work. "Configure" option is available only to a user who accesses the application via localhost or 127.0.0.1 or ::1 this makes sure that only a person having direct (or remote desktop) access to the physical machine is able to configure the application.
-
Please go through the discussion here: https://sourceforge.net/p/estimate/discussion/cs/thread/13f08fcd/ Any quantity or measurement other than length, breadth, height, weight goes into the number column. Only the most commonly used measurements (length, breadth, height, weight) have their separate columns. You can download and import the sample data (available for download; reinitialize your database before importing the sample data) to get accustomed to ESTIMATE's methodology. Please don't use...
-
Please go through the discussion here: https://sourceforge.net/p/estimate/discussion/cs/thread/13f08fcd/ You can download and import the sample data (available for download; reinitialize your database before importing the sample data) to get accustomed to ESTIMATE's methodology.
-
The items listed are not "Costbooks" but the directories which contain costbooks (just like a folder contains several files). Please refer to sections 3.3 and 4.1.6.1 of the user guide.
-
ESTIMATE requires MySQL to use InnoDB as it's storage engine (for managing the foreign key constraints and for transactions support). Looks like something bad happened to your dababase server, may be a corrupted log file or a misconfiguration.
-
Hello, "Test connection" might succeed however initialization may fail if the application cannot create database and tables (requires root access or equivalent).
-
We have not tested ESTIMATE for compatibility with MariaDB. Their JDBC drivers may or may not be 100% compatible and ESTIMATE includes MySQL driver only.
-
Hello Louis, We use the YUI Compressor (link provided at the bottom of this message). However the javascript file will work just fine even if it is not compressed/obfuscated. The purpose of compressing the files was to save some bandwidth and browser memory. http://yui.github.io/yuicompressor/
-
Hello Louis, The types have been hard coded in the javascript file named materialAction.js The compressed version of the file is available inside script/items/material (this one is the one loaded by the application) The uncompressed version of the file is available inside script/uncompressed/items/material You may modify the options inside the javascript file and add the modified file directly to the war package to replace the original one.
-
Current stable release supports the newer MySQL versions. However, ESTIMATE doesn't currently support the only_full_group_by mode available in the new MySQL versions. Please disable it: https://stackoverflow.com/questions/23921117/disable-only-full-group-by
-
Hello Peter, ESTIMATE doesn't currently support the only_full_group_by mode available in the new MySQL versions. Please disable it: https://stackoverflow.com/questions/23921117/disable-only-full-group-by Best Regards,
-
ESTICON is the name of the environment variable which points to a writable directory where ESTIMATE stores all it's configuration files.
-
Please carefully refer to sections 3.3 and 6.1 of the user documentation. You must be skipping some of the steps. Please refer to the attached screenshots.
-
Please disable the SQL mode 'only_full_group_by' in the MySQL server. This mode is not currently supported.
-
Please carefully refer to sections 3.3 and 6.1 of the user documentation. You jmust be skipping some of the steps. Please refer to the attached screenshots.
-
Please check the Number of licenses field.
-
Please make sure that the Mysql database server is running on the given URL:port (localhost and 3306 as per your configuration) and correct root password has been provided (blank as per your configuration).
-
Do you read anything unusual in the log? Did you make any changes in the default package? I can see Netbeans IDE in the screenshot. If the database is configured properly then ELEMENT should allow you to log in with Username: user Password: abc
-
You haven't configured your database. Go to the configuration page, select Database Settings. Follow the instructions provided in the user guide.
-
You must configure the application and set the "Number of licenses" which will be equal to the maximum number of sessions allowed by the application. For example if the number of licenses is set to 2, then at max two users can use the application concurrently.
-
Several users/evaluators have complained against the quality of the available documentation. We are going to improve the quality of documentation in the upcoming release. Thanks for your patience and support.
-
Hello, Following posts might be useful: https://sourceforge.net/p/estimate/discussion/cs/thread/861e7b0b/#0a67 https://sourceforge.net/p/estimate/discussion/cs/thread/71dc4460/#52c5 https://sourceforge.net/p/estimate/discussion/cs/thread/1da5c1ab/#371c Amit
-
In response to your report I executed following steps: A. Downloaded Tomcat 7 (Tomcat's version doesn't matter that much) and started it B. Downloaded the war file (2.1.0) from the sourceforge and deployed it inside Tomcat I had downloaded in step A C. Stopped Mysql service D. Tested Connection (screenshot attached), off course stacktrace been printed on the tomcat's console and log however error code 500 is not returned to the browser and a proper error message is displayed. The root cause is NoClassDefFoundError...
-
In response to your report I executed following steps: A. Downloaded Tomcat 7 (Tomcat's version doesn't matter that much) and started it B. Downloaded the war file (2.1.0) from the sourceforge and deployed it inside Tomcat I had downloaded in step A C. Stopped Mysql service D. Tested Connection (screenshot attached), off course stacktrace been printed on the tomcat's console and log however error code 500 is not returned to the browser and a proper error message is displayed. The root cause is NoClassDefFoundError...
-
I guess your upgradation to Tomcat 9 is not what fixed the problem. Most probably you installed Tomcat 9 inside your C:\Program Files directory which allowed the program to access all directories on the C drive. Amit
-
Hello, Please follow these steps in strict order: A. Create an empty writable directory (name doesn't matter), prefferably not on the C drive because windows 10 is bit finicky about it and might silently drop the write access to tomcat based on where have you placed your tomcat in the file system. B. Define environment variable ESTICON and set it's value as the full path to the directory you created in step A. C. Restart the tomcat server (may be needed on some machines), that should bring in the...
-
ESTICON can either be set as "environment variable" or as "system property" and must point to a writable directory. The installation issue you have been facing is primarily related to improper Tomcat setup rather than ESTIMATE. Please go through Tomcat's documentation on how to set "Environment Variable" and "System Property". It is highly likely that we are going to keep the current installation/configuration methodology (we may introduce alternatives which work well with Tomcat) in the next release...
-
ESTICON can either be set as "environment variable" or as "system property" and must point to a writable directory. The installation issue you have been facing is primarily related to improper Tomcat setup rather than ESTIMATE. Please go through Tomcat's documentation on how to set "Environment Variable" and "System Property". It is highly likely that we are going to keep the current installation/configuration methodology (we may introduce alternatives which work well with Tomcat) in the next release...
-
ESTICON can either be set as "environment variable" or as "system property" and must point to a writable directory. The installation issue you have been facing is primarily related to improper Tomcat setup rather than ESTIMATE. Please go through Tomcat's documentation on how to set "Environment Variable" and "System Property". It is highly likely that we are going to keep the current installation/configuration methodology (we may introduce alternatives which work well with Tomcat) in the next release...
-
ESTIMATE provides CostBooks for preparation of "Analysis of Rates", Costbooks allow the estimators to assign material and volumes to the Assemblies, however a single costbook can contain only a single "Analysis of Rate" for an Assembly. Please refer to section 3.3 of the user guide. However, from the looks of it you might need to customize ESTIMATE further to fit into your needs.
-
Section 3.1.2 and 3.1.3 of the user guide might provide you the information you are seeking.
-
Please refer to section 3.1.2 of the User guide. It explains "How to create a Category".
-
ESTIMATE version 2.1.0 has been released, primarily to fix the bugs reported by the end users via the forum or direct email. Next release of ESTIMATE will be a complete makeover.
-
David, The software is mostly stable with few minor bugs here and there which will be fixed in the next minor release (expect in September). However the current code base has become old by the current standards and a major release should be expected somewhere within 3-5 months from now. Best Regards, Amit
-
None at the moment.
-
Bob, This issue is not specifically related to ESTIMATE. Tomcat server may not be...
-
Your query may have been answered here https://sourceforge.net/p/estimate/discussion/cs/thread/861e7b0b/#0a67...
-
ESTIMATE requires Apache Tomcat, the package is not self-contained and that is why...
-
Hello, I believe that your query has been answered here: https://sourceforge.net...
-
Could you find a link saying Configure on the login page? If not then you must open...
-
Hello Mike, Download and extract the source package and import the extracted files...
-
Please use following credentials for Logging In first time (Provided you have initialized...
-
Dependencies: A. Apache Tomcat 7/8 or equivalent B. Mysql Database Server C. Java...
-
You can find Installation Instructions on "Community Support" sub-forum.
-
Can you access the remote machine using a remote desktop client? However there is...
-
Hello Stephen, If you are installing on Recent version of Windows then please do...
-
We don't intend to change it for a simple reason. We will have to update several...
-
@Saulenas Language support is one of our priorities. Thanks for bringing the issue...
-
There are no user groups in ESTIMATE. The default user starts with full access rights...
-
There are no user groups in ESTIMATE. The default user starts with full access rights...
-
@ Saulenas did you manage to dig out the root cause of the problem? ESTIMATE doesn't...
-
This is not a problem with the connector. The result disappears because javascript...
-
This is not a problem with the connector. The result disappears because javascript...
-
I have found the root of the problem. Javascript is not processing the responseXML...
-
I have found the root of the problem. Javascript is not processing the responseXML...
1 >
