Comments (7)
Hello
Thank you for publishing this library. I am not familiar with Perl at this time I download UMLS and load scripts into MySQL. after this command (cpanm UMLS::Interface --force) I get the error :
I guess this error is related to the user and password of MySQL. But I can not find the CuiFinder.pm for adding a fixed username and password in Line 721. would you please help me with this issue?
Thank you very much
Hi,
Thanks for interesting in this project. According to your figure of read time-out error, it seems that you failed to download the UMLS::Interface perl library from the Internet at the very beginning, thus causing failure of its installation. Maybe you should check your internet connection first. Then, if the above issue is solved, then you can try again to use cpanm UMLS::Interface --force to install the library in Windows Command program.
I will describe my process of solving this issue in the following:
Initially I used cpanm UMLS::Interface
to install it but failed with error mysql conecting issue. Based on my analysis, the library will try to use default MySQL user info to access the database (e.g. username=root, pasword=[EMPTY], db=umls) in its test scripts during the installation but failed when the user has different MySQL passwords and db names.
Then, I used cpanm UMLS::Interface --force
and though errors remain, it can be installed. So you can find the source code of UMLS::Interface in the directory of C:\Strawberry\perl\site\lib\UMLS\Interface
(suppossing you install Perl into the directory C:\Strawberry\perl
). So in this directory, you can find CuiFinder.pm
in above folder. The reason you can't find it is that you may not install it successfully due to failure of obtaining installation files online.
However, I did find it is not necessary to change th source codes of CuiFinder.pm
when you force install the UMLS::Interface.
I am also not a Perl expert. So next step you should make sure cpanm UMLS::Interface --force
should install (though errors still popup), and the directory C:\Strawberry\perl\site\lib\UMLS\Interface
can be found even you don't change its perl source code. That still works.
Thanks.
from umls-similarity.
Thank you very much for the details.
I finally downloaded umls::interface successfully. And install the umls-similarity too.
The python code executes without any error.
(I change the password in CuiFinder.pm too)
but did not return any result. I chose and tested many pairs of cui from the mrconso table. But I can not see the result. Only one empty array returned.
I will be very grateful if you tell me the problem In your opinion?
from umls-similarity.
Thank you very much for the details. I finally downloaded umls::interface successfully. And install the umls-similarity too. The python code executes without any error. (I change the password in CuiFinder.pm too) but did not return any result. I chose and tested many pairs of cui from the mrconso table. But I can not see the result. Only one empty array returned. I will be very grateful if you tell me the problem In your opinion?
Hi,
After you sucessfully installed the two Perl libaries, you should not change the source code of the CuiFinder.pl
file in the folder of C:\Strawberry\perl\site\lib\UMLS\Interface
. Then, please try again. Below is the figure that shows the result. Since you have installed them, the next step you should try:
- run
cpanm --uninstall UMLS::Interface
andcpanm --uninstall UMLS::Similarity
to remove any installation. - re-install the two libraries: run
cpanm UMLS::Interface --force
andcpanm UMLS::Similarity --force
(must include--force
flag) - now the example code should work. (By the way, please check if there are actual UMLS data in your MySQL database before.)
Thanks.
Results are below:
cuis_umls_sim.txt
from umls-similarity.
Hello
Please forgive me for these questions.
I repeated all the steps from the beginning, I work by 2017AA version of UMLS.
The error I see is shown in the figure below
I search for SRDEF table
in this link :
Semantic Network File Format MySQL Load Script
after execute instructions I get a new error:
SAB[MSH] ?!
Would you please tell me your opinion in this issue?
from umls-similarity.
Hello Please forgive me for these questions. I repeated all the steps from the beginning, I work by 2017AA version of UMLS. The error I see is shown in the figure below
I search for SRDEF table in this link : Semantic Network File Format MySQL Load Script after execute instructions I get a new error:
SAB[MSH] ?! Would you please tell me your opinion in this issue?
Hi,
The UMLS database must contain six tables: 1. MRREL 2. MRCONSO 3. MRSAB 4. MRDOC 5. MRDEF 6. MRSTY 7. SRDEF
All other tables in the databases will be ignored, and any of these tables missing would raise an error.
So I guess your MySQL database does not have MRSAB table.
Please refer to this link: https://metacpan.org/pod/UMLS::Interface#INSTALL
from umls-similarity.
Thank you for your patient.
I get the result!!!:))))
I reinstall the meta again. I think MSH is related to Mesh. and the problem is related to the resource list. in the first step of configuration, in this trial, I select "Exclude all level 0 except SNOMED", therefore MESH install too.
thank you again.
from umls-similarity.
Thank you very much for the details. I finally downloaded umls::interface successfully. And install the umls-similarity too. The python code executes without any error. (I change the password in CuiFinder.pm too) but did not return any result. I chose and tested many pairs of cui from the mrconso table. But I can not see the result. Only one empty array returned. I will be very grateful if you tell me the problem In your opinion?
Hi,
After you sucessfully installed the two Perl libaries, you should not change the source code of the
CuiFinder.pl
file in the folder ofC:\Strawberry\perl\site\lib\UMLS\Interface
. Then, please try again. Below is the figure that shows the result. Since you have installed them, the next step you should try:1. run `cpanm --uninstall UMLS::Interface` and `cpanm --uninstall UMLS::Similarity` to remove any installation. 2. re-install the two libraries: run `cpanm UMLS::Interface --force` and `cpanm UMLS::Similarity --force` (must include `--force` flag) 3. now the example code should work. (By the way, please check if there are actual UMLS data in your MySQL database before.)
Thanks.
Results are below: cuis_umls_sim.txt
Hi there,
I'm having a nearly identical issue. When I run the sample script an empty array is returned.
I have installed both Perl modules concerning the UMLS library and I also have a local instance of the UMLS that includes both the tables concerning the Metathesaurus and the Semantic Network. I also have the DBD:mysql and DI Perl modules installed in my system.
I can connect to the UMLS MySQL database just fine with my own code independently from the package. However, I'm not sure if the Perl package is setting up the connection properly. Do you have any recommendations?
In case it helps, I'm running the program in VSCode, with Python 3.11.4, MySQL 8.1, and the full UMLS 2023AA distribution.
I've tried different CUI pairs, different metrics, reinstalling Strawberry Perl, reinstalling the Perl modules, and reinstalling the umls-similarity package.
I've attached screenshots showing that I can connect to the database and showing the described behavior.
Thanks!
from umls-similarity.
Related Issues (2)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from umls-similarity.