Bom dia pessoal,
Passei dias tentando instalar o AD e sempre com problemas, certamente estou errando alguma coisa e repito o erro, pesquisei bastante e nada, então aqui estamos estreiando no fórum e agradecendo antecipadamente a ajuda de vocês. Vamos lá:
-Windows XP
-2GB memória
-Baixei do site ADEMPIERELBR a versão para Postgres do LBR 3.6.0, o customization.jar(baixi na pasta LIB do AD) e o ExpDat.dmp(baixei na pasta DAT do AD)
-Baixei e instalei o Java JDK 6.24
-Baixei e instalei o Postgres 8.3.14-1
-Baixei o PL/Java 14, depois descobrí que do AD 3.2 em diante não precisa mais…
-Ajustei as variáveis de ambiente ADEMPIERE_HOME, JAVA_HOME, o path para o java e para o Postgres
-No Postgres criei a role adempiere, depois criei o BD adempiere e coloquei adempiere como proprietário e codificação UTF8
-Rodei o RUN_SETUP.BAT sem problema, primeiro para BD localhost, depois aprendí a liberar endereços de conexão no Postgres e fiz tbem para remoto
*Aqui começam os problemas, ao rodar o RUN_DBRESTORE.BAT com o dump que baixei do site adempierelbr deu um monte de pau, msg de truncar campos para tamanho de 4 e por aí afora, vi que não ia dar certo
-Matei o BD e criei novamente, então utilizei o RUN_ImportAdempiere que criou toda a estrutura legal na base do create table, alter table e tal…
-Agora rodei o RUN_SERVER2.BAT para startar o bicho, daqui é que não consigo passar pois dá pau pra caramba, segue abaixo:
Setting myEnvironment …
Start Adempiere Apps Server C:\ADempiere (adempiere)
JBoss Bootstrap Environment
JBOSS_HOME: C:\Adempiere\jboss
JAVA: C:\Arquivos de programas\Java\bin\java
JAVA_OPTS: -server -Xms64M -Xmx512M -DADEMPIERE_HOME=C:\ADempiere -Dorg.ademp
iere.server.embedded=true -Dprogram.name=run.bat -server -Xms128m -Xmx512m -XX:M
axPermSize=128m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcI
nterval=3600000
CLASSPATH: C:\Arquivos de programas\Java\lib\tools.jar;C:\Adempiere\jboss\bin
run.jar
===============================================================================
10:41:49,046 INFO [Server] Starting JBoss (MX MicroKernel)…
10:41:49,046 INFO [Server] Release ID: JBoss [Trinity] 4.2.3.GA (build: SVNTag=
JBoss_4_2_3_GA date=200807181417)
10:41:49,062 INFO [Server] Home Dir: C:\Adempiere\jboss
10:41:49,062 INFO [Server] Home URL: file:/C:/Adempiere/jboss/
10:41:49,062 INFO [Server] Patch URL: null
10:41:49,062 INFO [Server] Server Name: adempiere
10:41:49,062 INFO [Server] Server Home Dir: C:\Adempiere\jboss\server\adempiere
10:41:49,062 INFO [Server] Server Home URL: file:/C:/Adempiere/jboss/server/ade
mpiere/
10:41:49,062 INFO [Server] Server Log Dir: C:\Adempiere\jboss\server\adempiere
log
10:41:49,062 INFO [Server] Server Temp Dir: C:\Adempiere\jboss\server\adempiere
\tmp
10:41:49,078 INFO [Server] Root Deployment Filename: jboss-service.xml
10:41:51,656 INFO [ServerInfo] Java version: 1.6.0_13,Sun Microsystems Inc.
10:41:51,656 INFO [ServerInfo] Java VM: Java HotSpot™ Server VM 11.3-b02,Sun
Microsystems Inc.
10:41:51,656 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
10:42:00,390 INFO [Server] Core system initialized
10:42:14,671 INFO [WebService] Using RMI server codebase: leonardo:8083/
10:42:14,687 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resour
ce:jboss-log4j.xml
10:42:17,015 INFO [TransactionManagerService] JBossTS Transaction Service (JTA
version) - JBoss Inc.
10:42:17,015 INFO [TransactionManagerService] Setting up property manager MBean
and JMX layer
10:42:17,687 INFO [TransactionManagerService] Starting recovery manager
10:42:18,062 INFO [TransactionManagerService] Recovery manager started
10:42:18,062 INFO [TransactionManagerService] Binding TransactionManager JNDI R
eference
10:42:30,937 INFO [EJB3Deployer] Starting java:comp multiplexer
10:42:34,609 INFO [Embedded] Catalina naming disabled
10:42:35,234 INFO [AprLifecycleListener] The Apache Tomcat Native library which
allows optimal performance in production environments was not found on the java
.library.path: C:\Arquivos de programas\Java\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WI
NDOWS\system32;C:\WINDOWS;C:\Arquivos de programas\PHP;C:\ARQUIVOS DE PROGRAMAS
\ARQUIVOS COMUNS\BORLAND SHARED\BDE;C:\ARQUIVOS DE PROGRAMAS\BORLAND\BDS\3.0\BI
N;C:\WINDOWS\SYSTEM32;C:\WINDOWS;C:\WINDOWS\SYSTEM32\WBEM;C:\WINDOWS;C:\WINDOWS
SYSTEM32\WBEM;C:\WINDOWS\SYSTEM32;C:\Arquivos de programas\TortoiseSVN\bin;C:\Ar
quivos de programas\Java\bin;C:\Arquivos de programas\Java\jre\bin;C:\Arquivos d
e programas\Java\jre\bin\client;C:\Arquivos de programas\PostgreSQL\8.3\bin;C:\D
ocuments and Settings\Leonardo\Meus documentos\Borland Studio Projects\Bpl
10:42:35,468 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-leonard
o%2F192.168.1.153-8080
10:42:37,984 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-8443
10:42:38,000 INFO [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-leonardo%2F1
92.168.1.153-8009
10:42:38,000 INFO [Catalina] Initialization processed in 3387 ms
10:42:38,000 INFO [StandardService] Starting service jboss.web
10:42:38,187 INFO [StandardEngine] Starting Servlet Engine: JBossWeb/2.0.1.GA
10:42:38,328 INFO [Catalina] Server startup in 324 ms
10:42:38,718 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=…/deploy/jboss-w
eb.deployer/ROOT.war/
10:42:42,531 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in …/deploy/jboss-ha-local-jdbc.rar
10:42:42,671 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in …/deploy/jboss-ha-xa-jdbc.rar
10:42:42,781 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in …/deploy/jboss-local-jdbc.rar
10:42:42,968 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in …/deploy/jboss-xa-jdbc.rar
10:42:43,078 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in …/deploy/mail-ra.rar
10:42:45,859 INFO [ConnectionFactoryBindingService] Bound ConnectionManager ‘jb
oss.jca:service=DataSourceBinding,name=DefaultDS’ to JNDI name ‘java:DefaultDS’
10:42:47,125 INFO [EARDeployer] Init J2EE application: file:/C:/Adempiere/jboss
/server/adempiere/deploy/adempiere.ear/
10:46:12,484 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jbo
ss.ejb3.stateless.StatelessContainer
10:46:12,515 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=ademp
iere.ear,jar=adempiereRoot.jar,name=adempiereServer,service=EJB3 with dependenci
es:
10:46:12,640 INFO [EJBContainer] STARTED EJB: org.compiere.session.ServerBean e
jbName: adempiereServer
10:46:12,890 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jbo
ss.ejb3.stateless.StatelessContainer
10:46:12,890 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=ademp
iere.ear,jar=adempiereRoot.jar,name=adempiereStatus,service=EJB3 with dependenci
es:
10:46:12,937 INFO [EJBContainer] STARTED EJB: org.compiere.session.StatusBean e
jbName: adempiereStatus
10:46:12,984 INFO [EJB3Deployer] Deployed: file:/C:/Adempiere/jboss/server/adem
piere/deploy/adempiere.ear/adempiereRoot.jar
10:46:13,000 INFO [TomcatDeployer] deploy, ctxPath=/adempiere, warUrl=…/tmp/d
eploy/tmp1230584712543611738adempiereApps-exp.war/
10:46:16,468 INFO [STDOUT] CLogFile[C:\ADempiere\log\2011-03-09_0.log,Level=ALL
]
10:46:16,484 ERROR [STDERR] *** 2011-03-09 10:46:16.484 Adempiere Log (ConsoleHa
ndler) ***
10:46:16.484 Adempiere.startup: ADempiere® 360LTS.010_2010-06-14 -Smart Suite
ERP,CRM and SCM- © 1999-2010 ADempiere®; Implementation: ${ADEMPIERE_VERSION
} 20110308-1650 - ${ADEMPIERE_VENDOR}
10:46:16,484 INFO [STDOUT] *** 2011-03-09 10:46:16.484 Adempiere Log (CLogConso
le) ***
10:46:16.484 Adempiere.startup: ADempiere® 360LTS.010_2010-06-14 -Smart Suite
ERP,CRM and SCM- © 1999-2010 ADempiere®; Implementation: ${ADEMPIERE_VERSION
} 20110308-1650 - ${ADEMPIERE_VENDOR}
10:46:16,531 ERROR [STDERR] 10:46:16.531 Ini.loadProperties: C:\ADempiere\Adempi
ere.properties #29
10:46:16,531 INFO [STDOUT] 10:46:16.531 Ini.loadProperties: C:\ADempiere\Adempi
ere.properties #29
10:46:21,359 ERROR [STDERR] [INFO] MLog clients using com.mchange.v2.log.Fallbac
kMLog logging.
10:46:22,078 ERROR [STDERR] [INFO] Initializing c3p0-0.9.1.2 [built 21-May-2007
15:04:56; debug? true; trace: 10]
10:46:22,734 ERROR [STDERR] [INFO] Initializing c3p0 pool… com.mchange.v2.c3p0
.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 2, acqui
reRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, br
eakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClass
Name -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConne
ctionTester, dataSourceName -> AdempiereDS, debugUnreturnedConnectionStackTraces
-> false, description -> null, driverClass -> org.postgresql.Driver, factoryCla
ssLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken ->
1hge17d8e16yxox31mi5bz5|92ed85, idleConnectionTestPeriod -> 1200, initialPoolSi
ze -> 10, jdbcUrl -> jdbc:postgresql://leonardo:5432/adempiere?encoding=UNICODE,
maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1200, max
IdleTimeExcessConnections -> 1200, maxPoolSize -> 150, maxStatements -> 0, maxSt
atementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, numThreadsA
waitingCheckoutDefaultUser -> 0, preferredTestQuery -> SELECT Version FROM AD_Sy
stem, properties -> {user=******, password=******}, propertyCycle -> 0, testConn
ectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectio
nTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
10:46:35,296 ERROR [STDERR] -----------> EMail.setFrom: you @ company.org: javax
.mail.internet.AddressException: Local address contains control or whitespace in
string you @ company.org'' 10:46:35,296 ERROR [STDERR] -----------> EMail.setFrom: you @ company.org: javax .mail.internet.AddressException: Local address contains control or whitespace in stringyou @ company.org’’
10:46:35,406 ERROR [STDERR] -----------> EMail.addTo: you @ company.org: javax.m
ail.internet.AddressException: Local address contains control or whitespace in s
tring you @ company.org'' 10:46:35,406 ERROR [STDERR] -----------> EMail.addTo: you @ company.org: javax.m ail.internet.AddressException: Local address contains control or whitespace in s tringyou @ company.org’’
10:46:35,421 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null
10:46:35,421 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null
10:46:35,421 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null
10:46:35,453 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null
10:46:35,468 ERROR [STDERR] -----------> MClient.sendEMail: Could NOT Send Email
: Server started: ? to you @ company.org: Invalid Data (System)
10:46:35,468 ERROR [STDERR] -----------> MClient.sendEMail: Could NOT Send Email
: Server started: ? to you @ company.org: Invalid Data (System)
10:46:35,875 INFO [TomcatDeployer] deploy, ctxPath=/admin, warUrl=…/tmp/deplo
y/tmp3157156727259832799adempiereRoot-exp.war/
10:46:36,468 ERROR [STDERR] ===========> Env.getContextAsDate: No value for: #Da
te
10:46:39,687 ERROR [STDERR] ===========> Env.getContextAsDate: No value for: #Da
te
10:46:49,156 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=…/tmp/deploy/tmp
7401189514847629046adempiereWebCM-exp.war/
10:46:49,734 INFO [TomcatDeployer] deploy, ctxPath=/wstore, warUrl=…/tmp/depl
oy/tmp882615913830352173adempiereWebStore-exp.war/
10:46:51,187 INFO [TomcatDeployer] deploy, ctxPath=/posterita, warUrl=…/tmp/d
eploy/tmp1745678764510137858posterita-exp.war/
10:46:51,359 INFO [WebappClassLoader] validateJarFile(C:\Adempiere\jboss\server
\adempiere.\tmp\deploy\tmp1745678764510137858posterita-exp.war\WEB-INF\lib\serv
let.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class:
javax/servlet/Servlet.class
10:46:51,781 ERROR [STDERR] log4j:ERROR A “org.jboss.logging.appender.FileAppend
er” object is not assignable to a “org.apache.log4j.Appender” variable.
10:46:51,781 ERROR [STDERR] log4j:ERROR The class “org.apache.log4j.Appender” wa
s loaded by
10:46:51,781 ERROR [STDERR] log4j:ERROR [WebappClassLoader
delegate: false
repositories:
/WEB-INF/classes/
----------> Parent Classloader:
java.net.FactoryURLClassLoader@1b1a986
] whereas object of type
10:46:51,781 ERROR [STDERR] log4j:ERROR "org.jboss.logging.appender.FileAppender
" was loaded by [org.jboss.system.server.NoAnnotationURLClassLoader@13caecd].
10:46:51,781 ERROR [STDERR] log4j:ERROR Could not instantiate appender named “FI
LE”.
10:46:51,968 INFO [STDOUT] 10:46:51,968 INFO [ResponseOverrideFilter] Filter i
nitialized. Response buffering is enabled
10:46:56,796 INFO [TomcatDeployer] deploy, ctxPath=/webui, warUrl=…/tmp/deplo
y/tmp1838356028820038499webui-exp.war/
10:47:04,609 INFO [EARDeployer] Started J2EE application: file:/C:/Adempiere/jb
oss/server/adempiere/deploy/adempiere.ear/
10:47:04,843 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-leonardo%2F
192.168.1.153-8080
10:47:04,906 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-8443
10:47:04,953 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-leonardo%2F192.1
68.1.153-8009
10:47:05,000 INFO [Server] JBoss (MX MicroKernel) [4.2.3.GA (build: SVNTag=JBos
s_4_2_3_GA date=200807181417)] Started in 5m:15s:922ms
10:47:48,812 ERROR [STDERR] -----------> EMail.setFrom: you @ company.org: javax
.mail.internet.AddressException: Local address contains control or whitespace in
string you @ company.org'' [11] 10:47:48,812 ERROR [STDERR] -----------> EMail.setFrom: you @ company.org: javax .mail.internet.AddressException: Local address contains control or whitespace in stringyou @ company.org’’ [11]
10:47:48,812 ERROR [STDERR] -----------> EMail.addTo: admin @ gardenworld.com: j
avax.mail.internet.AddressException: Local address contains control or whitespac
e in string admin @ gardenworld.com'' [11] 10:47:48,812 ERROR [STDERR] -----------> EMail.addTo: admin @ gardenworld.com: j avax.mail.internet.AddressException: Local address contains control or whitespac e in stringadmin @ gardenworld.com’’ [11]
10:47:48,812 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null [11
]
10:47:48,828 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null [11
]
10:47:48,828 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null [11
]
10:47:48,828 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null [11
]
10:47:49,296 ERROR [STDERR] -----------> MClient.sendEmailNow: Could NOT Send Em
ail: Inactivity Alert: Request 10000002 to admin @ gardenworld.com: Invalid Data
(GardenWorld) [11]
10:47:49,296 ERROR [STDERR] -----------> MClient.sendEmailNow: Could NOT Send Em
ail: Inactivity Alert: Request 10000002 to admin @ gardenworld.com: Invalid Data
(GardenWorld) [11]
*Tentei diversas vezes e mesmo problema, pensei ter errado algum detalhe na instalação e varrí a internet, li manuais e postagens, nada…
-Pensando que poderia ter errado algum passo baixei do adempiere.org a versão que instala tudo para vc, o super111, então arranquei tudo que era java e postgres da minha maquina e deixei por conta do super111, alias achei legal a musica do Red1. Acabei descobrindo que o postgres que ele instala não tem o executor de linha de comando PSQL, arranquei fora o postgres que o super111 instalou e instalei o mei, aí sim pude rodar os batches, no entanto deu o mesmo problema na hora de rodar o RUN_SERVER2.BAT
-Ahí partí para outra maquina para ter um comparativo, instalei o super111, sempre tendo que trocar o postgres no final, deu mesma coisa
-Nisso aí acabou o carnaval, não consegui rodar mas tenho certeza que ainda vai dar certo, além do que ainda tenho que aprender: usar o AD, aprender sua parametrização, criar campos e tabelas, carregar ele no Eclipse para fazer programação adicional, então muita coisa vai dar errado ainda e conto com a ajuda de vocês…
Muito obrigado e desculpem a extensão do post,
Leonardo