Details
-
Type:
extRequest
-
Status: Closed
-
Priority:
Major
-
Resolution: Done
-
Fix Version/s: 2021
-
Component/s: FIWARE-TECH-HELP
-
Labels:None
-
Sender Email:
-
HD-Chapter:Apps
-
HD-Enabler:SpagoBI
Description
- I cannot use mongodb with password in a data sets
- any of my charts are loading
- when i try to use a document from cvs or query i get the error of " Unable to load data from dataset mongo_orders Please check dataset & widget config"
Activity
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
5h 59m | 1 | Davide Zerbetto | 21/Nov/17 12:08 PM | |||||
|
1s | 1 | Davide Zerbetto | 21/Nov/17 12:08 PM | |||||
|
7d 3h 20m | 1 | Davide Zerbetto | 28/Nov/17 3:28 PM |
| Fix Version/s | 2021 [ 12600 ] |
| HD-Enabler | Knowage [ 11200 ] | SpagoBI [ 10856 ] |
| HD-Chapter | Apps [ 10836 ] |
| Comment |
[ Comment by jira-help-desk@jira.fiware.org : Spam detection software, running on the system "fiware-forge-01", has identified this incoming email as possible spam. The original message has been attached to this so you can view it (if it isn't spam) or label similar future email. If you have any questions, see the administrator of that system for details. Content preview: [ https://jira.fiware.org/browse/HELP-12960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] FW External User updated [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [...] Content analysis details: (6.1 points, 4.5 required) pts rule name description ---- ---------------------- -------------------------------------------------- 1.7 URIBL_BLACK Contains an URL listed in the URIBL blacklist [URIs: latedeliver.com] 2.5 URIBL_DBL_SPAM Contains a spam URL listed in the DBL blocklist [URIs: latedeliver.com] 0.0 FSL_HELO_NON_FQDN_1 FSL_HELO_NON_FQDN_1 3.8 HELO_LOCALHOST HELO_LOCALHOST -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] ] |
| Comment |
[ Comment by jira-help-desk@jira.fiware.org : Spam detection software, running on the system "fiware-forge-01", has identified this incoming email as possible spam. The original message has been attached to this so you can view it (if it isn't spam) or label similar future email. If you have any questions, see the administrator of that system for details. Content preview: [ https://jira.fiware.org/browse/HELP-12960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] FW External User updated (HELP-13082) [SPAM] Website Job Application > > > Key: https://jira.fiware.org/browse/HELP-12960 > Project: Help-Desk > Issue Type: extRequest > Reporter: FW External User > Attachments: [FIWARE-JIRA] (HELP-13082) [Fiware-general-help] [SPAM] Website Job Application > > > Spam detection software, running on the system "fiware-forge-01", has > identified this incoming email as possible spam. The original message > has been attached to this so you can view it (if it isn't spam) or label > similar future email. If you have any questions, see > the administrator of that system for details. > Content preview: [ https://jira.fiware.org/browse/HELP-13082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel > ] FW External User updated HELP-13082: > [Fiware-general-help] [SPAM] Website > Job Application > > > Key: HELP-13082 > URL: https://jira.fiware.org/browse/HELP-13082 > > Project: Help-Desk > Issue Type: extRequest > Components: SPAM > Reporter: > FW External User > Attachments: [FIWARE-JIRA] (HELP-12876) [Fiware-general-help] > [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application, [FIWARE-JIRA] > (HELP-12877) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] > Website Job Application, [FIWARE-JIRA] (HELP-12878) [Fiware-general-help] > [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application, [FIWARE-JIRA] > (HELP-12879) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] > Website Job Application, [FIWARE-JIRA] (HELP-12880) [Fiware-general-help] > [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application, [FIWARE-JIRA] > (HELP-12881) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] > Website Job Application, [FIWARE-JIRA] (HELP-12882) [Fiware-general-help] > [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application, [FIWARE-JIRA] > (HELP-12883) [Fiware-general-help] [SPAM] [...] Content analysis details: (6.9 points, 4.5 required) pts rule name description ---- ---------------------- -------------------------------------------------- 0.0 FSL_HELO_NON_FQDN_1 FSL_HELO_NON_FQDN_1 3.8 HELO_LOCALHOST HELO_LOCALHOST 1.7 URIBL_BLACK Contains an URL listed in the URIBL blacklist [URIs: latedeliver.com] 2.5 URIBL_DBL_SPAM Contains a spam URL listed in the DBL blocklist [URIs: latedeliver.com] -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] 0.8 RDNS_NONE Delivered to internal network by a host with no rDNS ] |
| Attachment |
[FIWARE-JIRA] ( |
| Attachment | [FIWARE-JIRA] (HELP-12960) [Coach-Impact].FruitApp.Knowage.MongoIssues [ 61982 ] |
| Attachment | [FIWARE-JIRA] (HELP-12960) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 60867 ] |
| Summary | [Coach-Impact].FruitApp.KnowAge.MongoIssues | [Coach-Impact].FruitApp.Knowage.MongoIssues |
| Resolution | Done [ 10000 ] | |
| Status | Answered [ 10104 ] | Closed [ 6 ] |
| Link | This issue relates to APP-1623 [ APP-1623 ] |
Comment by eslem@fruitsapp.com :
Hi,
the version is the 3.4.10, what you mean querying? i have queries with the rest and works only if i don't have them as persisted, with mongoDB i only can use it if i don't have authentification in the databse.
Regards.
Eslem Alzate.
-
The issue has been emailed:
- Time sent: 23/Nov/17 11:31 AM
- To: eslem@fruitsapp.com
- with subject: RE: [Coach-Impact].FruitApp.KnowAge.MongoIssues
Hi
could you please send us log files?
We suspect it depends on MongoDB version. Which MongoDB version are you using? are you querying the Orion Context Broker storage?
Regards
Davide
Comment by eslem@fruitsapp.com :
Hi,
Still not working, now i get the error: For input string: "27017/FruitsApp" (i think this error comes from the datasource because the url is $34.248.196.11:27017/FruitsApp:27017/FruitsApp ) the query is exactly the same as a replicated server that i have but without password and this one is working.
If you want the access the knowage server is in the address http://52.16.21.114:8080/knowage/, <http://52.16.21.114:8080/knowage/,> the same users as in the demo.
Regards.
Eslem Alzate.
-
The issue has been emailed:
- Time sent: 22/Nov/17 6:25 AM
- To: eslem@fruitsapp.com
- with subject: RE: [Coach-Impact].FruitApp.KnowAge.MongoIssues
Hi
let's concentrate with MongoDB access in this issue (we will discuss about other topis in other issues).
Did you try the solution I suggested? Any update about MongoDB access?
Best regards
Davide
| Attachment | knowage-log_DPQkVdXk5kufqvHeyxZI.zip [ 60030 ] |
Comment by eslem@fruitsapp.com :
Hi,
no, i said that now i can not use any dataset in the documents. i get the same error even with orion ( before this didn't happen ) or any other data set.
I've attached the logs just in case, the knowage server is a completely new installation.
Regards.
Eslem Alzate.
-
The issue has been emailed:
- Time sent: 21/Nov/17 1:23 PM
- To: eslem@fruitsapp.com
- with subject: RE: [FIWARE-JIRA] RE: [Coach-Impact].FruitApp.KnowAge.MongoIssues
Hi
when you say:
"About the 2, yes i've just updated the knowage server and now any of my datasets are not working."
do you mean that updating to Knowage 6.1.1 resolved the issue and that now all charts are displayed properly?
Best regards
Davide
Comment by eslem@fruitsapp.com :
Hi,
thank you i will try that,
About the 2, yes i've just updated the knowage server and now any of my datasets are not working.
Regards.
-
| Status | In Progress [ 3 ] | Answered [ 10104 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
The issue has been emailed:
- Time sent: 21/Nov/17 12:08 PM
- To: eslem@fruitsapp.com
- Cc: davide.zerbetto@eng.it
- with subject: RE: [Coach-Impact].FruitApp.KnowAge.MongoIssues
- attachment(s): MongoDataProxy.class
Hi
in this message I'm going to reply to the question about MongoDB; for the other items that are:
_
1. any of my charts are loading
2. when i try to use a document from cvs or query i get the error of " Unable to load data from dataset mongo_orders Please check dataset & widget config"
_
for the issue no. 1, please open a thread on stackoverflow describing the environment, how to reproduce the error and (if possible) details about the error from log files, put "fiware" and "knowage" tags; for the issue no. 2, I saw an email to Fiware-tech-help with subject "IMPACT", is the same as the issue above?
Regarding MongoDB, please proceed as follows
1. stop knowage server;
2. replace attached .class in all occurrences
of file knowage-utils-6.x.x.jar:
KNOWAGE_SERVER_HOME/webapps/knowage/WEB-INF/lib/knowage-utils-6.x.x.jar
KNOWAGE_SERVER_HOME/webapps/knowagecockpitengine/WEB-INF/lib/knowage-utils-6.x.x.jar
KNOWAGE_SERVER_HOME/webapps/knowageqbeengine/WEB-INF/lib/knowage-utils-6.x.x.jar
....
in all knowage applications; file must be replaced within the package it.eng.spagobi.tools.dataset.common.dataproxy;
3. start knowage server and retry.
Please let me know if it works.
Best regards
Davide
| Attachment | MongoDataProxy.class [ 60027 ] |
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Francesco Arigliano [ arigliano ] | Davide Zerbetto [ davide.zerbetto ] |
The issue has been emailed:
Hi
I created a work item for Knowage:
https://jira.fiware.org/browse/APP-1623
(I think you cannot see it). That work item is for developing access to MongoDB with credentials. This will be developed next month, we will try to provide you update packages asap.
I close this issue.
Best regards
Davide