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