Ok. Check if the jdbc driver (mysql-connector-java-3.1.12-bin) is included in your base2 distribution, if missing then base 2 cannot talk to your database.
Dominic -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pablo Lemos Ochandio Sent: 20 March 2006 13:56 To: basedb-users@lists.sourceforge.net Subject: Re: [base] A problem with intidb in BASE2.0RC1 Yes. I try with root password and base2user password and in two cases give me the same message error. The base2user have those privileges and i make available the connection of this user to another machine. I have a doubt. JAVA has a jdbc to mysql installed or i have to download and install one? Thanks dominic oyeniran escribió: > Ok what is the netsensor password in this section of your code: > [EMAIL PROTECTED] bin]# ./initdb.sh netsensor. > Is it your mysql root password? > > I think you should run initdb with the password (i.e. in your case password) > stated in your config file. > > The base2user should have all the privileges specified by this code in the > installation instruction: > GRANT ALL ON base2.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Pablo Lemos > Ochandio > Sent: 20 March 2006 13:35 > To: basedb-users@lists.sourceforge.net > Subject: Re: [base] A problem with intidb in BASE2.0RC1 > > Hi dominic!! > > i change the line into my base.config but it crash again: > > [0%] Building > database.................................................................... > 15:22:18,527 > WARN BasicResourcePool:1222 - > [EMAIL PROTECTED] -- > Acquisition Attempt Failed!!! Clearing pending acquires. While trying to > acquire a needed new resource, we failed to succeed more than the > maximum number of allowed acquisition attempts (30). > 15:22:19,002 WARN BasicResourcePool:1222 - > [EMAIL PROTECTED] -- > Acquisition Attempt Failed!!! Clearing pending acquires. While trying to > acquire a needed new resource, we failed to succeed more than the > maximum number of allowed acquisition attempts (30). > .................................................................15:23:25,01 > 2 > WARN BasicResourcePool:1222 - > [EMAIL PROTECTED] -- > Acquisition Attempt Failed!!! Clearing pending acquires. While trying to > acquire a needed new resource, we failed to succeed more than the > maximum number of allowed acquisition attempts (30). > > [30%] Building database failed: Cannot open connection > > i dont know why... i have phpmyadmin runs in the same machine and works. > I have a CMS that use MySQL in the same machine too > > > > dominic oyeniran escribió: > >> Pablo, >> Change the url to: >> db.url = jdbc:mysql://localhost:3306/base2 >> and then do issue the initdb command. >> >> Dominic >> >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Pablo Lemos >> Ochandio >> Sent: 20 March 2006 12:39 >> To: basedb-users@lists.sourceforge.net >> Subject: Re: [base] A problem with intidb in BASE2.0RC1 >> >> Hi dominic >> >> The database is on the same machine and is listening at 3306. >> >> i copy the www directory of base package to /var/www/html/base2 so my >> db.url is: localhost/base2. Is all right? >> >> Thanks >> >> dominic oyeniran escribió: >> >> >>> Hi Pablo, >>> Is the database installed on the same machine as the webserver. Check the >>> >>> >> db >> >> >>> url here: >>> --------------db.url = jdbc:mysql://localhost/base2 >>> Put the correct url and then the port number MYSQL is listening to. In >>> >>> >> most >> >> >>> cases it is: 3306. >>> >>> Hope this helps. >>> >>> Regards, >>> Dominic >>> >>> -----Original Message----- >>> From: [EMAIL PROTECTED] >>> [mailto:[EMAIL PROTECTED] On Behalf Of Pablo >>> > Lemos > >>> Ochandio >>> Sent: 20 March 2006 12:15 >>> To: basedb-users@lists.sourceforge.net >>> Subject: Re: [base] A problem with intidb in BASE2.0RC1 >>> >>> Hi dominic!! >>> >>> My base.config is: >>> >>> # $Id: base.config.in,v 1.2 2004/11/30 12:48:41 nicklas Exp $ >>> # >>> # BioArray Software Environment (BASE) - http://base.thep.lu.se/ >>> # Copyright (C) 2002-2004 Lao Saal, Carl Troein, >>> # Johan Vallon-Christersson, Jari Häkkinen, Nicklas Nordborg >>> # >>> # This file is part of BASE. >>> # >>> # BASE is free software; you can redistribute it and/or >>> # modify it under the terms of the GNU General Public License >>> # as published by the Free Software Foundation; either version 2 >>> # of the License, or (at your option) any later version. >>> # >>> # BASE is distributed in the hope that it will be useful, >>> # but WITHOUT ANY WARRANTY; without even the implied warranty of >>> # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the >>> # GNU General Public License for more details. >>> # >>> # You should have received a copy of the GNU General Public License >>> # along with this program; if not, write to the Free Software >>> # Foundation, Inc., 59 Temple Place - Suite 330, >>> # Boston, MA 02111-1307, USA. >>> # ---------------------------------------- >>> >>> # ======================= >>> # Database driver section >>> # ======================= >>> >>> # ----- >>> # MySQL >>> # ----- >>> db.dialect = org.hibernate.dialect.MySQLInnoDBDialect >>> db.driver = com.mysql.jdbc.Driver >>> db.url = jdbc:mysql://localhost/base2 >>> db.dynamic.catalog = base2dynamic >>> db.queries = /mysql-queries.xml >>> export.max.items = 20000 >>> >>> # -------- >>> # Postgres >>> # -------- >>> #db.dialect = org.hibernate.dialect.PostgreSQLDialect >>> #db.driver = org.postgresql.Driver >>> #db.url = jdbc:postgresql:base2 >>> #db.dynamic.catalog = base2 >>> #db.dynamic.schema = dynamic >>> #db.queries = /postgres-queries.xml >>> #export.max.items = 0 >>> >>> # ------------- >>> # Common to all >>> # ------------- >>> db.username = base2user >>> db.password = password >>> db.extended-properties = /extended-properties.xml >>> db.raw-data-types = /raw-data-types.xml >>> db.batch-size = 50 >>> >>> >>> # ====================== >>> # Authentication section >>> # ====================== >>> >>> # ---------------- >>> # POP3 mail server >>> # ---------------- >>> #auth.driver = >>> > net.sf.basedb.core.authentication.POP3Authenticator > >>> #auth.init = mail.example.com >>> #auth.synchronize = 0 >>> #auth.cachepasswords = 0 >>> #auth.daystocache = 0 >>> >>> >>> # ========================== >>> # Internal job queue section >>> # ========================== >>> # If the internal job queue should be enabled or not >>> jobqueue.internal.enabled = true >>> #jobqueue.internal.maxthreadpriority = 4 >>> >>> # Number of seconds between checks to the job queue >>> jobqueue.internal.checkinterval = 30 >>> >>> # NOTE! A quick job may use threads from any of the "slower" pools >>> # if there is place for another thread >>> # Number of threads to reserved for jobs that takes < 1 minute to execute >>> jobqueue.internal.shortest.threads = 1 >>> #jobqueue.internal.shortest.threadpriority = 4 >>> >>> # Number of threads to reserved for jobs that takes < 10 minutes to >>> >>> >> execute >> >> >>> jobqueue.internal.short.threads = 1 >>> #jobqueue.internal.short.threadpriority = 4 >>> >>> # Number of threads to reserved for jobs that takes < 1 hour to execute >>> jobqueue.internal.medium.threads = 2 >>> #jobqueue.internal.medium.threadpriority = 3 >>> >>> # Number of threads to reserved for jobs that takes > 1 hour to execute >>> jobqueue.internal.long.threads = 4 >>> #jobqueue.internal.medium.threadpriority = 3 >>> >>> # ========================= >>> # Secondary storage section >>> # ========================= >>> # The classname of the driver; leave empty to disable secondary storage >>> # secondary.storage.driver = >>> >>> >> net.sf.basedb.core.InternalStorageController >> >> >>> # Initialisation options to the seconday storage controller >>> # The internal implementation wants a path to the secondary directory >>> # secondary.storage.init = /usr/local/base2/secondary >>> >>> # The interval (in seconds) between checks for new files to move >>> # secondary.storage.interval = 3600 >>> >>> # =============== >>> # General section >>> # =============== >>> >>> # The path to the directory where uploaded files are stored >>> userfiles = /usr/local/base/files >>> >>> # Number of minutes to keep permission information for the logged >>> # in user in memory before it is reloaded from the database. >>> permission.timeout = 10 >>> >>> # Number of minutes to keep SessionControl object in the cache >>> # after the last use >>> cache.timeout = 20 >>> >>> >>> i have tryed to not change any of the settings to check if the initbd >>> work. I create a base2user as the documentation say... >>> >>> I dont know if the problem are to connect to MySQL server or privileges >>> of the user. My base2user have privileges to: create, update, delete, >>> drop, alter, insert >>> >>> Thanks >>> >>> >>> dominic oyeniran escribió: >>> >>> >>> >>>> Hi >>>> >>>> I reckon its something to do with the database setup parameters in your >>>> >>>> >>>> >>> base >>> >>> >>> >>>> config file. Can u check it again or post it here and I can have a look >>>> >>>> >> at >> >> >>>> it? >>>> >>>> Regards, >>>> Dominic >>>> >>>> -----Original Message----- >>>> From: [EMAIL PROTECTED] >>>> [mailto:[EMAIL PROTECTED] On Behalf Of Pablo >>>> >>>> >> Lemos >> >> >>>> Ochandio >>>> Sent: 20 March 2006 10:57 >>>> To: basedb-users@lists.sourceforge.net >>>> Subject: [base] A problem with intidb in BASE2.0RC1 >>>> >>>> Hi!! >>>> >>>> Im not sure if this is the right way to communicate a problem with the >>>> installation of BASE2.0RC1 but im desesperate. >>>> Im the Sysadmin of Instituto Valenciano de Investigaciones Agrarias >>>> (IVIA) at Spain. The Genomic Departament request to me if i can to >>>> install the BASE2 package at the Web server. Im trying to install it but >>>> > > >>>> when i launch the initdb script it crash at give the next message error: >>>> >>>> [EMAIL PROTECTED] bin]# ./initdb.sh netsensor >>>> [0%] Building >>>> >>>> >>>> >>>> > database.................................................................... > >> >> >>> >>> >>> >>>> .11:30:35,173 >>>> WARN BasicResourcePool:1222 - >>>> [EMAIL PROTECTED] -- >>>> Acquisition Attempt Failed!!! Clearing pending acquires. While trying to >>>> > > >>>> acquire a needed new resource, we failed to succeed more than the >>>> maximum number of allowed acquisition attempts (30). >>>> .11:30:36,147 WARN BasicResourcePool:1222 - >>>> [EMAIL PROTECTED] -- >>>> Acquisition Attempt Failed!!! Clearing pending acquires. While trying to >>>> > > >>>> acquire a needed new resource, we failed to succeed more than the >>>> maximum number of allowed acquisition attempts (30). >>>> ........................................................11:31:33,739 >>>> WARN BasicResourcePool:1222 - >>>> [EMAIL PROTECTED] -- >>>> Acquisition Attempt Failed!!! Clearing pending acquires. While trying to >>>> > > >>>> acquire a needed new resource, we failed to succeed more than the >>>> maximum number of allowed acquisition attempts (30). >>>> >>>> [30%] Building database failed: Cannot open connection >>>> >>>> >>>> net.sf.basedb.core.BaseException: Cannot open connection >>>> at >>>> net.sf.basedb.core.HibernateUtil.newSession(HibernateUtil.java:760) >>>> at >>>> net.sf.basedb.core.HibernateUtil.isEmptyDatabase(HibernateUtil.java:439) >>>> at >>>> >>>> >>>> >>>> > net.sf.basedb.core.HibernateUtil.createStaticTables(HibernateUtil.java:403) > >> >> >>> >>> >>> >>>> at net.sf.basedb.core.Install.createTables(Install.java:108) >>>> at net.sf.basedb.install.InitDB.main(InitDB.java:57) >>>> Caused by: org.hibernate.exception.GenericJDBCException: Cannot open >>>> connection >>>> at >>>> >>>> >>>> >>>> > org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLSta > >> >> >>> >>> >>> >>>> teConverter.java:91) >>>> >>>> at >>>> >>>> >>>> >>>> > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79) > >> >> >>> >>> >>> >>>> at >>>> >>>> >>>> >>>> > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java > >> >> >>> >>> >>> >>>> :43) >>>> >>>> at >>>> >>>> >>>> >>>> > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java > >> >> >>> >>> >>> >>>> :29) >>>> >>>> at >>>> >>>> >>>> >>>> > org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:3 > >> >> >>> >>> >>> >>>> 63) >>>> >>>> at >>>> >>>> >>>> >>>> > org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:12 > >> >> >>> >>> >>> >>>> 2) >>>> >>>> at >>>> >>>> >>>> >>>> > org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.ja > >> >> >>> >>> >>> >>>> va:40) >>>> >>>> at $Proxy0.setTransactionIsolation(Unknown Source) >>>> at >>>> net.sf.basedb.core.HibernateUtil.newSession(HibernateUtil.java:755) >>>> ... 4 more >>>> Caused by: java.sql.SQLException: Connections could not be acquired from >>>> > > >>>> the underlying database! >>>> at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104) >>>> at >>>> >>>> >>>> >>>> > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C > >> >> >>> >>> >>> >>>> 3P0PooledConnectionPool.java:236) >>>> >>>> at >>>> >>>> >>>> >>>> > com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource. > >> >> >>> >>> >>> >>>> java:94) >>>> >>>> at >>>> >>>> >>>> >>>> > org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0Connection > >> >> >>> >>> >>> >>>> Provider.java:35) >>>> >>>> at >>>> >>>> >>>> >>>> > org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:3 > >> >> >>> >>> >>> >>>> 60) >>>> >>>> ... 8 more >>>> Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A >>>> > > >>>> ResourcePool could not acquire a resource from its primary factory or >>>> source. >>>> at >>>> >>>> >>>> >>>> > com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool > >> >> >>> >>> >>> >>>> .java:970) >>>> >>>> at >>>> >>>> >>>> >>>> > com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResource > >> >> >>> >>> >>> >>>> Pool.java:208) >>>> >>>> at >>>> >>>> >>>> >>>> > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C > >> >> >>> >>> >>> >>>> 3P0PooledConnectionPool.java:232) >>>> >>>> ... 11 more >>>> >>>> I have tested all the steps in the documentation since the initdb >>>> script. (I test MySQL database (ok), apache installation (ok), java >>>> installation and home variable (ok), ant installation (ok) and BASE >>>> configuration (ok)). >>>> >>>> Please, Can you help me? >>>> >>>> PS: I create a user base2user by the following way: >>>> >>>> GRANT ALL ON base2.* TO 'base2user'@'%' IDENTIFIED BY 'password'; >>>> GRANT ALL ON base2dynamic.* TO 'base2user'@'%'; >>>> >>>> >>>> with the wildcard '%' i can to connect to the MySQL server in different >>>> machine with command: >>>> mysql -h<IP_MACHINE_REMOTE> -ubase2user -p >>>> >>>> Thanks a lot >>>> >>>> >>>> >>>> ------------------------------------------------------- >>>> This SF.Net email is sponsored by xPML, a groundbreaking scripting >>>> >>>> >>>> >>> language >>> >>> >>> >>>> that extends applications into web and mobile media. Attend the live >>>> >>>> >>>> >>> webcast >>> >>> >>> >>>> and join the prime developer group breaking into this new coding >>>> >>>> >>>> >>> territory! >>> >>> >>> >>>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 >>>> _______________________________________________ >>>> The BASE general discussion mailing list >>>> basedb-users@lists.sourceforge.net >>>> unsubscribe: send a mail with subject "unsubscribe" to >>>> [EMAIL PROTECTED] >>>> >>>> >>>> >>>> >>>> >>> ------------------------------------------------------- >>> This SF.Net email is sponsored by xPML, a groundbreaking scripting >>> >>> >> language >> >> >>> that extends applications into web and mobile media. Attend the live >>> >>> >> webcast >> >> >>> and join the prime developer group breaking into this new coding >>> >>> >> territory! >> >> >>> http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642 >>> _______________________________________________ >>> The BASE general discussion mailing list >>> basedb-users@lists.sourceforge.net >>> unsubscribe: send a mail with subject "unsubscribe" to >>> [EMAIL PROTECTED] >>> >>> >>> >>> >> >> >> ------------------------------------------------------- >> This SF.Net email is sponsored by xPML, a groundbreaking scripting >> > language > >> that extends applications into web and mobile media. Attend the live >> > webcast > >> and join the prime developer group breaking into this new coding >> > territory! > >> http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642 >> _______________________________________________ >> The BASE general discussion mailing list >> basedb-users@lists.sourceforge.net >> unsubscribe: send a mail with subject "unsubscribe" to >> [EMAIL PROTECTED] >> >> >> > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting language > that extends applications into web and mobile media. Attend the live webcast > and join the prime developer group breaking into this new coding territory! > http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642 > _______________________________________________ > The BASE general discussion mailing list > basedb-users@lists.sourceforge.net > unsubscribe: send a mail with subject "unsubscribe" to > [EMAIL PROTECTED] > > ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
