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=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]
