The variables (dbhost,dbname,dbuser,dbpass) all worked fine to import gene info, gene2accession and the assocdb-data. However, this is the error message:
Starting to import /mnt/pipelinedata/blast2go/idmapping.tb to b...@127.0.0.1 with user root Problem connecting to database b2g on 127.0.0.1 as root with password starts with go2******: com.mysql.jdbc.Driver Database or network connection (timeout) error for: 127.0.0.1 Database or network connection (timeout) error for: 127.0.0.1 Import gi-uniprot mapping: Could not connect to DB Could not connect to DB Import of gi-uniprot mapping finished
I already changed my.cnf:
more /etc/my.cnf
[mysqld] bind-address=127.0.0.1 datadir=/mnt/pipelinebigdata/mysql/ socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0
I noticed that the SQL scripts invokes the rights for the b2g database for user blast2go with passport blast4it. Although I was working with the root credentials (they should have all privileges) i tried it with blast2go user and blast4it pass. No luck, also when i granted all rights for this user by:
GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY 'blast4it';
> The variables (dbhost,dbname,dbuser,dbpass) all worked fine to import gene > info, gene2accession and the assocdb-data. However, this is the error > message:
> Starting to import /mnt/pipelinedata/blast2go/idmapping.tb to > b...@127.0.0.1 with user root > Problem connecting to database b2g on 127.0.0.1 as root with password > starts with go2******: com.mysql.jdbc.Driver > Database or network connection (timeout) error for: 127.0.0.1 > Database or network connection (timeout) error for: 127.0.0.1 > Import gi-uniprot mapping: Could not connect to DB > Could not connect to DB > Import of gi-uniprot mapping finished
Discussion subject changed to "Blast2GO GoogleGroup Re: blast2go pipeline - only importing the idmapping.tb fails with same mysql settings" by Stefan Götz
> I noticed that the SQL scripts invokes the rights for the b2g database for
> user blast2go with passport blast4it.
> Although I was working with the root credentials (they should have all
> privileges) i tried it with blast2go user and blast4it pass.
> No luck, also when i granted all rights for this user by:
> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY 'blast4it';
> On Thursday, August 23, 2012 9:55:50 AM UTC+2, EJ Blom wrote:
>> Dear Blast2go-users,
>> Very strange, I am able to import all necessary files into the database
>> but the last step fail when the idmapping.tb needs to be imported.
>> The variables (dbhost,dbname,dbuser,dbpass) all worked fine to import
>> gene info, gene2accession and the assocdb-data. However, this is the error
>> message:
>> Starting to import /mnt/pipelinedata/blast2go/**idmapping.tb to
>> b...@127.0.0.1 with user root
>> Problem connecting to database b2g on 127.0.0.1 as root with password
>> starts with go2******: com.mysql.jdbc.Driver
>> Database or network connection (timeout) error for: 127.0.0.1
>> Database or network connection (timeout) error for: 127.0.0.1
>> Import gi-uniprot mapping: Could not connect to DB
>> Could not connect to DB
>> Import of gi-uniprot mapping finished
>> --
> You received this message because you are subscribed to the Google Groups
> "Blast2GO" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/blast2go/-/RxNOTGkMImUJ.
> To post to this group, send email to blast2go@googlegroups.com.
> To unsubscribe from this group, send email to
> blast2go+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/blast2go?hl=en.
> On 23 August 2012 14:12, EJ Blom <ejb...@gmail.com <javascript:>> wrote:
>> I noticed that the SQL scripts invokes the rights for the b2g database >> for user blast2go with passport blast4it.
>> Although I was working with the root credentials (they should have all >> privileges) i tried it with blast2go user and blast4it pass.
>> No luck, also when i granted all rights for this user by:
>> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY 'blast4it';
>> On Thursday, August 23, 2012 9:55:50 AM UTC+2, EJ Blom wrote:
>>> Dear Blast2go-users,
>>> Very strange, I am able to import all necessary files into the database >>> but the last step fail when the idmapping.tb needs to be imported.
>>> The variables (dbhost,dbname,dbuser,dbpass) all worked fine to import >>> gene info, gene2accession and the assocdb-data. However, this is the error >>> message:
>>> Starting to import /mnt/pipelinedata/blast2go/**idmapping.tb to >>> b...@127.0.0.1 <javascript:> with user root
>>> Problem connecting to database b2g on 127.0.0.1 as root with password >>> starts with go2******: com.mysql.jdbc.Driver
>>> Database or network connection (timeout) error for: 127.0.0.1
>>> Database or network connection (timeout) error for: 127.0.0.1
>>> Import gi-uniprot mapping: Could not connect to DB
>>> Could not connect to DB
>>> Import of gi-uniprot mapping finished
>>> -- >> You received this message because you are subscribed to the Google Groups >> "Blast2GO" group.
>> To view this discussion on the web visit >> https://groups.google.com/d/msg/blast2go/-/RxNOTGkMImUJ.
>> To post to this group, send email to blas...@googlegroups.com<javascript:>
>> .
>> To unsubscribe from this group, send email to >> blast2go+u...@googlegroups.com <javascript:>.
>> For more options, visit this group at >> http://groups.google.com/group/blast2go?hl=en.
> I noticed that the SQL scripts invokes the rights for the b2g database for
> user blast2go with passport blast4it.
> Although I was working with the root credentials (they should have all
> privileges) i tried it with blast2go user and blast4it pass.
> No luck, also when i granted all rights for this user by:
> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY 'blast4it';
> On Thursday, August 23, 2012 9:55:50 AM UTC+2, EJ Blom wrote:
>> Dear Blast2go-users,
>> Very strange, I am able to import all necessary files into the database
>> but the last step fail when the idmapping.tb needs to be imported.
>> The variables (dbhost,dbname,dbuser,dbpass) all worked fine to import
>> gene info, gene2accession and the assocdb-data. However, this is the error
>> message:
>> Starting to import /mnt/pipelinedata/blast2go/**idmapping.tb to
>> b...@127.0.0.1 with user root
>> Problem connecting to database b2g on 127.0.0.1 as root with password
>> starts with go2******: com.mysql.jdbc.Driver
>> Database or network connection (timeout) error for: 127.0.0.1
>> Database or network connection (timeout) error for: 127.0.0.1
>> Import gi-uniprot mapping: Could not connect to DB
>> Could not connect to DB
>> Import of gi-uniprot mapping finished
>> --
> You received this message because you are subscribed to the Google Groups
> "Blast2GO" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/blast2go/-/RxNOTGkMImUJ.
> To post to this group, send email to blast2go@googlegroups.com.
> To unsubscribe from this group, send email to
> blast2go+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/blast2go?hl=en.
On Thursday, August 23, 2012 4:50:25 PM UTC+2, Stefan Götz wrote:
> Hi, > do not forget the "flush privileges;" afterwards to update the privileges. > Regards, > Stefan
> On 23 August 2012 14:12, EJ Blom <ejb...@gmail.com <javascript:>> wrote:
>> I noticed that the SQL scripts invokes the rights for the b2g database >> for user blast2go with passport blast4it.
>> Although I was working with the root credentials (they should have all >> privileges) i tried it with blast2go user and blast4it pass.
>> No luck, also when i granted all rights for this user by:
>> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY 'blast4it';
>> On Thursday, August 23, 2012 9:55:50 AM UTC+2, EJ Blom wrote:
>>> Dear Blast2go-users,
>>> Very strange, I am able to import all necessary files into the database >>> but the last step fail when the idmapping.tb needs to be imported.
>>> The variables (dbhost,dbname,dbuser,dbpass) all worked fine to import >>> gene info, gene2accession and the assocdb-data. However, this is the error >>> message:
>>> Starting to import /mnt/pipelinedata/blast2go/**idmapping.tb to >>> b...@127.0.0.1 <javascript:> with user root
>>> Problem connecting to database b2g on 127.0.0.1 as root with password >>> starts with go2******: com.mysql.jdbc.Driver
>>> Database or network connection (timeout) error for: 127.0.0.1
>>> Database or network connection (timeout) error for: 127.0.0.1
>>> Import gi-uniprot mapping: Could not connect to DB
>>> Could not connect to DB
>>> Import of gi-uniprot mapping finished
>>> -- >> You received this message because you are subscribed to the Google Groups >> "Blast2GO" group.
>> To view this discussion on the web visit >> https://groups.google.com/d/msg/blast2go/-/RxNOTGkMImUJ.
>> To post to this group, send email to blas...@googlegroups.com<javascript:>
>> .
>> To unsubscribe from this group, send email to >> blast2go+u...@googlegroups.com <javascript:>.
>> For more options, visit this group at >> http://groups.google.com/group/blast2go?hl=en.
On Thursday, August 23, 2012 7:37:21 PM UTC+2, EJ Blom wrote:
> Hi
> I flushed the privileges, makes no difference .. :-(
> Regards
> EJ
> On Thursday, August 23, 2012 4:50:25 PM UTC+2, Stefan Götz wrote:
>> Hi, >> do not forget the "flush privileges;" afterwards to update >> the privileges. >> Regards, >> Stefan
>> On 23 August 2012 14:12, EJ Blom <ejb...@gmail.com> wrote:
>>> I noticed that the SQL scripts invokes the rights for the b2g database >>> for user blast2go with passport blast4it.
>>> Although I was working with the root credentials (they should have all >>> privileges) i tried it with blast2go user and blast4it pass.
>>> No luck, also when i granted all rights for this user by:
>>> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY >>> 'blast4it';
>>> On Thursday, August 23, 2012 9:55:50 AM UTC+2, EJ Blom wrote:
>>>> Dear Blast2go-users,
>>>> Very strange, I am able to import all necessary files into the database >>>> but the last step fail when the idmapping.tb needs to be imported.
>>>> The variables (dbhost,dbname,dbuser,dbpass) all worked fine to import >>>> gene info, gene2accession and the assocdb-data. However, this is the error >>>> message:
>>>> Starting to import /mnt/pipelinedata/blast2go/**idmapping.tb to >>>> b...@127.0.0.1 with user root
>>>> Problem connecting to database b2g on 127.0.0.1 as root with password >>>> starts with go2******: com.mysql.jdbc.Driver
>>>> Database or network connection (timeout) error for: 127.0.0.1
>>>> Database or network connection (timeout) error for: 127.0.0.1
>>>> Import gi-uniprot mapping: Could not connect to DB
>>>> Could not connect to DB
>>>> Import of gi-uniprot mapping finished
>>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Blast2GO" group.
>>> To view this discussion on the web visit >>> https://groups.google.com/d/msg/blast2go/-/RxNOTGkMImUJ.
>>> To post to this group, send email to blas...@googlegroups.com.
>>> To unsubscribe from this group, send email to >>> blast2go+u...@googlegroups.com.
>>> For more options, visit this group at >>> http://groups.google.com/group/blast2go?hl=en.
> Perhaps a Java problem? I am using the newest version (7).
> On Thursday, August 23, 2012 7:37:21 PM UTC+2, EJ Blom wrote:
>> Hi
>> I flushed the privileges, makes no difference .. :-(
>> Regards
>> EJ
>> On Thursday, August 23, 2012 4:50:25 PM UTC+2, Stefan Götz wrote:
>>> Hi,
>>> do not forget the "flush privileges;" afterwards to update
>>> the privileges.
>>> Regards,
>>> Stefan
>>> On 23 August 2012 14:12, EJ Blom <ejb...@gmail.com> wrote:
>>>> I noticed that the SQL scripts invokes the rights for the b2g database
>>>> for user blast2go with passport blast4it.
>>>> Although I was working with the root credentials (they should have all
>>>> privileges) i tried it with blast2go user and blast4it pass.
>>>> No luck, also when i granted all rights for this user by:
>>>> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY
>>>> 'blast4it';
>>>> On Thursday, August 23, 2012 9:55:50 AM UTC+2, EJ Blom wrote:
>>>>> Dear Blast2go-users,
>>>>> Very strange, I am able to import all necessary files into the
>>>>> database but the last step fail when the idmapping.tb needs to be imported.
>>>>> The variables (dbhost,dbname,dbuser,dbpass) all worked fine to import
>>>>> gene info, gene2accession and the assocdb-data. However, this is the error
>>>>> message:
>>>>> Starting to import /mnt/pipelinedata/blast2go/**idm**apping.tb to
>>>>> b...@127.0.0.1 with user root
>>>>> Problem connecting to database b2g on 127.0.0.1 as root with password
>>>>> starts with go2******: com.mysql.jdbc.Driver
>>>>> Database or network connection (timeout) error for: 127.0.0.1
>>>>> Database or network connection (timeout) error for: 127.0.0.1
>>>>> Import gi-uniprot mapping: Could not connect to DB
>>>>> Could not connect to DB
>>>>> Import of gi-uniprot mapping finished
> To post to this group, send email to blast2go@googlegroups.com.
> To unsubscribe from this group, send email to
> blast2go+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/blast2go?hl=en.
Yes thanks for checking, the go2*** was the pass for root login (the one that should always work) and the blast4it is the one that is specific for the blast2go user.
On Friday, August 24, 2012 7:50:19 PM UTC+2, Stefan Götz wrote:
> ... just if you did not notice: in one of your mails you use as password > for the import go2******
> but the grant command says blast4it ....
> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY 'blast4it';
> On 24 August 2012 19:46, EJ Blom <ejb...@gmail.com <javascript:>> wrote:
>> Perhaps a Java problem? I am using the newest version (7).
>> On Thursday, August 23, 2012 7:37:21 PM UTC+2, EJ Blom wrote:
>>> Hi
>>> I flushed the privileges, makes no difference .. :-(
>>> Regards
>>> EJ
>>> On Thursday, August 23, 2012 4:50:25 PM UTC+2, Stefan Götz wrote:
>>>> Hi, >>>> do not forget the "flush privileges;" afterwards to update >>>> the privileges. >>>> Regards, >>>> Stefan
>>>> On 23 August 2012 14:12, EJ Blom <ejb...@gmail.com> wrote:
>>>>> I noticed that the SQL scripts invokes the rights for the b2g database >>>>> for user blast2go with passport blast4it.
>>>>> Although I was working with the root credentials (they should have all >>>>> privileges) i tried it with blast2go user and blast4it pass.
>>>>> No luck, also when i granted all rights for this user by:
>>>>> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY >>>>> 'blast4it';
>>>>> On Thursday, August 23, 2012 9:55:50 AM UTC+2, EJ Blom wrote:
>>>>>> Dear Blast2go-users,
>>>>>> Very strange, I am able to import all necessary files into the >>>>>> database but the last step fail when the idmapping.tb needs to be imported.
>>>>>> The variables (dbhost,dbname,dbuser,dbpass) all worked fine to import >>>>>> gene info, gene2accession and the assocdb-data. However, this is the error >>>>>> message:
>>>>>> Starting to import /mnt/pipelinedata/blast2go/**idm**apping.tb to >>>>>> b...@127.0.0.1 with user root
>>>>>> Problem connecting to database b2g on 127.0.0.1 as root with password >>>>>> starts with go2******: com.mysql.jdbc.Driver
>>>>>> Database or network connection (timeout) error for: 127.0.0.1
>>>>>> Database or network connection (timeout) error for: 127.0.0.1
>>>>>> Import gi-uniprot mapping: Could not connect to DB
>>>>>> Could not connect to DB
>>>>>> Import of gi-uniprot mapping finished
>> To post to this group, send email to blas...@googlegroups.com<javascript:>
>> .
>> To unsubscribe from this group, send email to >> blast2go+u...@googlegroups.com <javascript:>.
>> For more options, visit this group at >> http://groups.google.com/group/blast2go?hl=en.
I just installed the database files on the RDS Mysql instance on Amazon, everything worked fine (only had to change TYPE=MyISAM to ENGINE=MyISAM).
however, the error is still there. I am now going to try another older Java version.
On Friday, August 24, 2012 2:00:00 PM UTC-4, EJ Blom wrote:
> Yes thanks for checking, the go2*** was the pass for root login (the one > that should always work) and the blast4it is the one that is specific for > the blast2go user.
> EJ
> On Friday, August 24, 2012 7:50:19 PM UTC+2, Stefan Götz wrote:
>> ... just if you did not notice: in one of your mails you use as password >> for the import go2******
>> but the grant command says blast4it ....
>> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY 'blast4it';
>> On 24 August 2012 19:46, EJ Blom <ejb...@gmail.com> wrote:
>>> Perhaps a Java problem? I am using the newest version (7).
>>> On Thursday, August 23, 2012 7:37:21 PM UTC+2, EJ Blom wrote:
>>>> Hi
>>>> I flushed the privileges, makes no difference .. :-(
>>>> Regards
>>>> EJ
>>>> On Thursday, August 23, 2012 4:50:25 PM UTC+2, Stefan Götz wrote:
>>>>> Hi, >>>>> do not forget the "flush privileges;" afterwards to update >>>>> the privileges. >>>>> Regards, >>>>> Stefan
>>>>> On 23 August 2012 14:12, EJ Blom <ejb...@gmail.com> wrote:
>>>>>> I noticed that the SQL scripts invokes the rights for the b2g >>>>>> database for user blast2go with passport blast4it.
>>>>>> Although I was working with the root credentials (they should have >>>>>> all privileges) i tried it with blast2go user and blast4it pass.
>>>>>> No luck, also when i granted all rights for this user by:
>>>>>> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY >>>>>> 'blast4it';
>>>>>> On Thursday, August 23, 2012 9:55:50 AM UTC+2, EJ Blom wrote:
>>>>>>> Dear Blast2go-users,
>>>>>>> Very strange, I am able to import all necessary files into the >>>>>>> database but the last step fail when the idmapping.tb needs to be imported.
>>>>>>> The variables (dbhost,dbname,dbuser,dbpass) all worked fine to >>>>>>> import gene info, gene2accession and the assocdb-data. However, this is the >>>>>>> error message:
>>>>>>> Starting to import /mnt/pipelinedata/blast2go/**idm**apping.tb to >>>>>>> b...@127.0.0.1 with user root
>>>>>>> Problem connecting to database b2g on 127.0.0.1 as root with >>>>>>> password starts with go2******: com.mysql.jdbc.Driver
>>>>>>> Database or network connection (timeout) error for: 127.0.0.1
>>>>>>> Database or network connection (timeout) error for: 127.0.0.1
>>>>>>> Import gi-uniprot mapping: Could not connect to DB
>>>>>>> Could not connect to DB
>>>>>>> Import of gi-uniprot mapping finished
>>> To post to this group, send email to blas...@googlegroups.com.
>>> To unsubscribe from this group, send email to >>> blast2go+u...@googlegroups.com.
>>> For more options, visit this group at >>> http://groups.google.com/group/blast2go?hl=en.
On Friday, August 24, 2012 2:00:00 PM UTC-4, EJ Blom wrote:
> Yes thanks for checking, the go2*** was the pass for root login (the one > that should always work) and the blast4it is the one that is specific for > the blast2go user.
> EJ
> On Friday, August 24, 2012 7:50:19 PM UTC+2, Stefan Götz wrote:
>> ... just if you did not notice: in one of your mails you use as password >> for the import go2******
>> but the grant command says blast4it ....
>> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY 'blast4it';
>> On 24 August 2012 19:46, EJ Blom <ejb...@gmail.com> wrote:
>>> Perhaps a Java problem? I am using the newest version (7).
>>> On Thursday, August 23, 2012 7:37:21 PM UTC+2, EJ Blom wrote:
>>>> Hi
>>>> I flushed the privileges, makes no difference .. :-(
>>>> Regards
>>>> EJ
>>>> On Thursday, August 23, 2012 4:50:25 PM UTC+2, Stefan Götz wrote:
>>>>> Hi, >>>>> do not forget the "flush privileges;" afterwards to update >>>>> the privileges. >>>>> Regards, >>>>> Stefan
>>>>> On 23 August 2012 14:12, EJ Blom <ejb...@gmail.com> wrote:
>>>>>> I noticed that the SQL scripts invokes the rights for the b2g >>>>>> database for user blast2go with passport blast4it.
>>>>>> Although I was working with the root credentials (they should have >>>>>> all privileges) i tried it with blast2go user and blast4it pass.
>>>>>> No luck, also when i granted all rights for this user by:
>>>>>> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY >>>>>> 'blast4it';
>>>>>> On Thursday, August 23, 2012 9:55:50 AM UTC+2, EJ Blom wrote:
>>>>>>> Dear Blast2go-users,
>>>>>>> Very strange, I am able to import all necessary files into the >>>>>>> database but the last step fail when the idmapping.tb needs to be imported.
>>>>>>> The variables (dbhost,dbname,dbuser,dbpass) all worked fine to >>>>>>> import gene info, gene2accession and the assocdb-data. However, this is the >>>>>>> error message:
>>>>>>> Starting to import /mnt/pipelinedata/blast2go/**idm**apping.tb to >>>>>>> b...@127.0.0.1 with user root
>>>>>>> Problem connecting to database b2g on 127.0.0.1 as root with >>>>>>> password starts with go2******: com.mysql.jdbc.Driver
>>>>>>> Database or network connection (timeout) error for: 127.0.0.1
>>>>>>> Database or network connection (timeout) error for: 127.0.0.1
>>>>>>> Import gi-uniprot mapping: Could not connect to DB
>>>>>>> Could not connect to DB
>>>>>>> Import of gi-uniprot mapping finished
>>> To post to this group, send email to blas...@googlegroups.com.
>>> To unsubscribe from this group, send email to >>> blast2go+u...@googlegroups.com.
>>> For more options, visit this group at >>> http://groups.google.com/group/blast2go?hl=en.
OK Found the problem after days of searching. When I copied/typed over the last java import, I made a spelling error:
mysql-connectorjava-3.0.11-stable-bin.jar should be mysql-connector-java-3.0.11-stable-bin.jar (notice the dash).
A few lessons that could be learned (imho). The following error message would not give me the hint that a jar file was incorrectly linked:
Problem connecting to database b2g on 127.0.0.1 as root with password starts with go2******: com.mysql.jdbc.Driver
Database or network connection (timeout) error for: 127.0.0.1
Database or network connection (timeout) error for: 127.0.0.1
Import gi-uniprot mapping: Could not connect to DB
Could not connect to DB
Import of gi-uniprot mapping finished
Instead, I would very very helpful if the actual error message (class not found or something like that) was also produced. I would have solved this in 5 min.
However, I shouldn't be making the typing error in the first place. In my defense, I had to extract this particular line from a PDF file and copy paste didn't work for some strange reason. Perhaps the line could be added to the install script that covers also the import of the other 3 data files.
Let's wait and see how it works, at least I have a working RDS on the cloud, that's a plus :-)
On Friday, August 24, 2012 2:00:00 PM UTC-4, EJ Blom wrote:
> Yes thanks for checking, the go2*** was the pass for root login (the one > that should always work) and the blast4it is the one that is specific for > the blast2go user.
> EJ
> On Friday, August 24, 2012 7:50:19 PM UTC+2, Stefan Götz wrote:
>> ... just if you did not notice: in one of your mails you use as password >> for the import go2******
>> but the grant command says blast4it ....
>> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY 'blast4it';
>> On 24 August 2012 19:46, EJ Blom <ejb...@gmail.com> wrote:
>>> Perhaps a Java problem? I am using the newest version (7).
>>> On Thursday, August 23, 2012 7:37:21 PM UTC+2, EJ Blom wrote:
>>>> Hi
>>>> I flushed the privileges, makes no difference .. :-(
>>>> Regards
>>>> EJ
>>>> On Thursday, August 23, 2012 4:50:25 PM UTC+2, Stefan Götz wrote:
>>>>> Hi, >>>>> do not forget the "flush privileges;" afterwards to update >>>>> the privileges. >>>>> Regards, >>>>> Stefan
>>>>> On 23 August 2012 14:12, EJ Blom <ejb...@gmail.com> wrote:
>>>>>> I noticed that the SQL scripts invokes the rights for the b2g >>>>>> database for user blast2go with passport blast4it.
>>>>>> Although I was working with the root credentials (they should have >>>>>> all privileges) i tried it with blast2go user and blast4it pass.
>>>>>> No luck, also when i granted all rights for this user by:
>>>>>> GRANT ALL PRIVILEGES ON b2g.* TO blast2go @'%' IDENTIFIED BY >>>>>> 'blast4it';
>>>>>> On Thursday, August 23, 2012 9:55:50 AM UTC+2, EJ Blom wrote:
>>>>>>> Dear Blast2go-users,
>>>>>>> Very strange, I am able to import all necessary files into the >>>>>>> database but the last step fail when the idmapping.tb needs to be imported.
>>>>>>> The variables (dbhost,dbname,dbuser,dbpass) all worked fine to >>>>>>> import gene info, gene2accession and the assocdb-data. However, this is the >>>>>>> error message:
>>>>>>> Starting to import /mnt/pipelinedata/blast2go/**idm**apping.tb to >>>>>>> b...@127.0.0.1 with user root
>>>>>>> Problem connecting to database b2g on 127.0.0.1 as root with >>>>>>> password starts with go2******: com.mysql.jdbc.Driver
>>>>>>> Database or network connection (timeout) error for: 127.0.0.1
>>>>>>> Database or network connection (timeout) error for: 127.0.0.1
>>>>>>> Import gi-uniprot mapping: Could not connect to DB
>>>>>>> Could not connect to DB
>>>>>>> Import of gi-uniprot mapping finished
>>> To post to this group, send email to blas...@googlegroups.com.
>>> To unsubscribe from this group, send email to >>> blast2go+u...@googlegroups.com.
>>> For more options, visit this group at >>> http://groups.google.com/group/blast2go?hl=en.
Recently we could not start the B2G program at all. It shows "Java(TM) Web Start Launcher has stopped working". We can not "check online for a solution" as suggested. Your help is greatly appreciated.
