diego bowen schrieb: > Yes I do for them in the database (dbUsers table) > > [webad...@www1 ~]$ mysql -h webdb2.com -u swamp_admin -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 1004353 > Server version: 5.0.45-log MySQL Community Server (GPL) > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> \q > Bye
The users swamp_admin and swamp_user are not mysql users (with which you can login to mysql) but entries in the table dbUsers of the swamp database that get used by swamp to authenticate. Did you follow the description at: http://swamp.sourceforge.net/index.php?seite=doc2html&docpage=html-installguide/x74.html The part: mysql -u swamp -p swamp < swamp-security.sql; imports the default users. Did you install from rpm or manually? There should be at least that line in the logfile: [DEBUG] Trying to authenticate user: swamp_user Greetings > [webad...@www1 ~]$ mysql -h webdb2.com -u swamp_user -pswamp > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 1004355 > Server version: 5.0.45-log MySQL Community Server (GPL) > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> \q > Bye > [webad...@www1 ~]$ mysql -h webdb2.com -u mrswamp -pswamp > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 1004356 > Server version: 5.0.45-log MySQL Community Server (GPL) > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> \q > > > Here is how my catalina output looks...I bounced tomcat: > > > -bash-3.00$ sudo ./startup.sh; tail -f ../logs/catalina.out > Using CATALINA_BASE: /usr/local/tomcat > Using CATALINA_HOME: /usr/local/tomcat > Using CATALINA_TMPDIR: /usr/local/tomcat/temp > Using JRE_HOME: /usr/local/java > 11.06 09:05:07 [DEBUG] Scheduled Task TimeTriggers ran @: Thu Jun 11 > 09:05:07 PDT 2009 and triggered 0 of 0 SendEventActions > Jun 11, 2009 9:05:07 AM org.apache.turbine.services.schedule.JobEntry > calcRunTime > INFO: Next runtime for task NotifyScheduler is Thu Jun 11 09:10:07 PDT 2009 > 11.06 09:05:07 [DEBUG] Scheduled job sendnotifies() task: > NotifyScheduler ran @: Thu Jun 11 09:05:07 PDT 2009 > Jun 11, 2009 9:10:07 AM org.apache.turbine.services.schedule.JobEntry > calcRunTime > INFO: Next runtime for task NotifyScheduler is Thu Jun 11 09:15:07 PDT 2009 > 11.06 09:10:07 [DEBUG] Scheduled job sendnotifies() task: > NotifyScheduler ran @: Thu Jun 11 09:10:07 PDT 2009 > Jun 11, 2009 9:15:07 AM org.apache.turbine.services.schedule.JobEntry > calcRunTime > INFO: Next runtime for task NotifyScheduler is Thu Jun 11 09:20:07 PDT 2009 > 11.06 09:15:07 [DEBUG] Scheduled job sendnotifies() task: > NotifyScheduler ran @: Thu Jun 11 09:15:07 PDT 2009 > Jun 11, 2009 9:15:36 AM org.apache.coyote.http11.Http11Protocol init > INFO: Initializing Coyote HTTP/1.1 on http-8080 > Jun 11, 2009 9:15:36 AM org.apache.catalina.startup.Catalina load > INFO: Initialization processed in 441 ms > Jun 11, 2009 9:15:36 AM org.apache.catalina.core.StandardService start > INFO: Starting service Tomcat-Standalone > Jun 11, 2009 9:15:36 AM org.apache.catalina.core.StandardEngine start > INFO: Starting Servlet Engine: Apache Tomcat/5.5.7 > Jun 11, 2009 9:15:36 AM org.apache.catalina.core.StandardHost start > INFO: XML validation disabled > Jun 11, 2009 9:15:37 AM org.apache.turbine.Turbine configure > INFO: Configured log4j from > /usr/local/tomcat/webapps/webswamp/WEB-INF/conf/Log4j.properties > Jun 11, 2009 9:15:37 AM org.apache.turbine.Turbine configure > INFO: Loaded configuration (Properties) from > /WEB-INF/conf/TurbineResources.properties > (/usr/local/tomcat/webapps/webswamp/WEB-INF/conf/TurbineResources.properties) > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: ComponentService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: FactoryService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: PoolService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: RunDataService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: ServletService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: AssemblerBrokerService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: MimeTypeService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: GlobalCacheService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: SchedulerService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: UniqueIdService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: UploadService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: SecurityService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: PullService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: TemplateService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: VelocityService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > initMapping > INFO: Added Mapping for Service: WebSWAMP > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > doInitService > INFO: Start Initializing service (early): ComponentService > Jun 11, 2009 9:15:37 AM > org.apache.turbine.services.component.TurbineComponentService init > WARNING: The ComponentService is deprecated! > Jun 11, 2009 9:15:37 AM > org.apache.turbine.services.component.TurbineComponentService init > INFO: Added torque as a component > 11.06 09:15:37 [INFO ] loading component: name=torque > class=org.apache.torque.Torque > config=/usr/local/tomcat/webapps/webswamp/WEB-INF/conf/Torque.properties > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > doInitService > INFO: Finish Initializing service (early): ComponentService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > doInitService > INFO: Start Initializing service (early): SchedulerService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.schedule.JobEntry > calcRunTime > INFO: Next runtime for task NotifyScheduler is Thu Jun 11 09:20:37 PDT 2009 > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.schedule.JobEntry > calcRunTime > INFO: Next runtime for task TimeTriggers is Thu Jun 11 09:45:37 PDT 2009 > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.schedule.JobEntry > calcRunTime > INFO: Next runtime for task Statistics is Fri Jun 12 00:10:00 PDT 2009 > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.schedule.JobEntry > calcRunTime > INFO: Next runtime for task NotifyReminderScheduler is Fri Jun 12 > 07:00:00 PDT 2009 > Jun 11, 2009 9:15:37 AM > org.apache.turbine.services.schedule.TurbineSchedulerService restart > INFO: Starting job scheduler > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > doInitService > INFO: Finish Initializing service (early): SchedulerService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > doInitService > INFO: Start Initializing service (early): PullService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Start Initializing service (late): PoolService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Start Initializing service (late): FactoryService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Finish Initializing service (late): FactoryService > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Finish Initializing service (late): PoolService > Jun 11, 2009 9:15:37 AM > org.apache.turbine.services.pull.TurbinePullService initPullService > INFO: Pull Model tools will be refreshed on a per request basis. > Jun 11, 2009 9:15:37 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Start Initializing service (late): VelocityService > Jun 11, 2009 9:15:38 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Start Initializing service (late): TemplateService > Jun 11, 2009 9:15:38 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Start Initializing service (late): AssemblerBrokerService > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.assemblerbroker.TurbineAssemblerBrokerService > registerFactories > INFO: Registering 1 action factories. > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.assemblerbroker.TurbineAssemblerBrokerService > registerFactories > INFO: Registering 1 screen factories. > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.assemblerbroker.TurbineAssemblerBrokerService > registerFactories > INFO: Registering 1 navigation factories. > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.assemblerbroker.TurbineAssemblerBrokerService > registerFactories > INFO: Registering 1 layout factories. > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.assemblerbroker.TurbineAssemblerBrokerService > registerFactories > INFO: Registering 1 page factories. > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.assemblerbroker.TurbineAssemblerBrokerService > registerFactories > INFO: Registering 1 scheduledjob factories. > Jun 11, 2009 9:15:38 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Finish Initializing service (late): AssemblerBrokerService > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.template.TurbineTemplateService initMapper > INFO: Using org.apache.turbine.services.template.mapper.DirectMapper to > map page elements > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.template.TurbineTemplateService initMapper > INFO: Using org.apache.turbine.services.template.mapper.ClassMapper to > map screen elements > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.template.TurbineTemplateService initMapper > INFO: Using org.apache.turbine.services.template.mapper.ClassMapper to > map layout elements > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.template.TurbineTemplateService initMapper > INFO: Using org.apache.turbine.services.template.mapper.ClassMapper to > map navigation elements > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.template.TurbineTemplateService initMapper > INFO: Using > org.apache.turbine.services.template.mapper.LayoutTemplateMapper to map > layout.template elements > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.template.TurbineTemplateService initMapper > INFO: Using > org.apache.turbine.services.template.mapper.ScreenTemplateMapper to map > screen.template elements > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.template.TurbineTemplateService initMapper > INFO: Using > org.apache.turbine.services.template.mapper.DirectTemplateMapper to map > navigation.template elements > Jun 11, 2009 9:15:38 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Finish Initializing service (late): TemplateService > Jun 11, 2009 9:15:38 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Finish Initializing service (late): VelocityService > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.pull.TurbinePullService getTools > INFO: Tool de.suse.swamp.webswamp.SwampTemplateLink to add to the > context as '$link' > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.pull.TurbinePullService getTools > INFO: Tool org.apache.turbine.util.template.HtmlPageAttributes to add to > the context as '$page' > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.pull.TurbinePullService getTools > INFO: Tool org.apache.turbine.services.pull.tools.ContentTool to add to > the context as '$content' > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.pull.TurbinePullService getTools > INFO: Tool org.apache.turbine.services.pull.util.DateFormatter to add to > the context as '$dateFormatter' > Jun 11, 2009 9:15:38 AM > org.apache.turbine.services.pull.TurbinePullService getTools > INFO: Tool de.suse.swamp.webswamp.SwampUIManager to add to the context > as '$ui' > Jun 11, 2009 9:15:38 AM org.apache.turbine.services.BaseServiceBroker > doInitService > INFO: Finish Initializing service (early): PullService > Jun 11, 2009 9:15:38 AM org.apache.turbine.services.BaseServiceBroker > doInitService > INFO: Start Initializing service (early): VelocityService > Jun 11, 2009 9:15:38 AM org.apache.turbine.services.BaseServiceBroker > doInitService > INFO: Finish Initializing service (early): VelocityService > Jun 11, 2009 9:15:38 AM org.apache.turbine.services.BaseServiceBroker > doInitService > INFO: Start Initializing service (early): WebSWAMP > 11.06 09:15:38 [DEBUG] Set swamp.home to: > /usr/local/tomcat/webapps/webswamp/WEB-INF > 11.06 09:15:38 [DEBUG] Set swamp.conf to: conf/defaults > swamp.home set to /usr/local/tomcat/webapps/webswamp/WEB-INF > Loading property file > /usr/local/tomcat/webapps/webswamp/WEB-INF/conf/defaults > 11.06 09:15:38 [INFO ] Have found a SWAMP Workflow > Resource:/usr/local/tomcat/webapps/webswamp/WEB-INF/conf/workflows/ExampleSub > 11.06 09:15:38 [INFO ] Reading workflow: ExampleSub version: 0.1 > 11.06 09:15:38 [INFO ] Adding i18n de.suse.swamp.i18n.Core to cache > 11.06 09:15:38 [DEBUG] Loading wfTemplate: Example0.2 because of dependency. > 11.06 09:15:38 [INFO ] Reading workflow: Example version: 0.2 > 11.06 09:15:38 [DEBUG] Initiated new groovy shell. > 11.06 09:15:38 [DEBUG] Using SWAMPDBUserManager for authenticating > 11.06 09:15:39 [DEBUG] Workflow ExampleSub-0.1 read successfuly > 11.06 09:15:39 [INFO ] Have found a SWAMP Workflow > Resource:/usr/local/tomcat/webapps/webswamp/WEB-INF/conf/workflows/Example > 11.06 09:15:39 [INFO ] Reading workflow: Example version: 0.1 > 11.06 09:15:39 [DEBUG] Workflow Example-0.1 read successfuly > 11.06 09:15:39 [DEBUG] Workflow Example-0.2 read successfuly > 11.06 09:15:39 [INFO ] Have found a SWAMP Workflow > Resource:/usr/local/tomcat/webapps/webswamp/WEB-INF/conf/workflows/Meeting > 11.06 09:15:39 [INFO ] Reading workflow: Meeting version: 1.0 > 11.06 09:15:39 [DEBUG] Workflow Meeting-1.0 read successfuly > 11.06 09:15:39 [INFO ] Have found a SWAMP Workflow > Resource:/usr/local/tomcat/webapps/webswamp/WEB-INF/conf/workflows/minimal_test > 11.06 09:15:39 [INFO ] Reading workflow: minimal_test version: 0.1 > 11.06 09:15:39 [DEBUG] Workflow minimal_test-0.1 read successfuly > 11.06 09:15:39 [DEBUG] Successfully added Example-0.2 to TemplateList > 11.06 09:15:39 [DEBUG] Successfully added ExampleSub-0.1 to TemplateList > 11.06 09:15:39 [DEBUG] Successfully added Example-0.1 to TemplateList > 11.06 09:15:39 [DEBUG] Successfully added Meeting-1.0 to TemplateList > 11.06 09:15:39 [DEBUG] Successfully added minimal_test-0.1 to TemplateList > 11.06 09:15:39 [DEBUG] Set WebSWAMP.secureAppLink to: > https://www2.cms.eonline.com/webswamp > 11.06 09:15:39 [DEBUG] Set WebSWAMP.appLink to: > http://www2.cms.eonline.com:8080/webswamp > 11.06 09:15:39 [DEBUG] Set WebSWAMP.relativeAppLink to: /webswamp > Jun 11, 2009 9:15:39 AM org.apache.turbine.services.BaseServiceBroker > doInitService > INFO: Finish Initializing service (early): WebSWAMP > Jun 11, 2009 9:15:39 AM org.apache.turbine.services.BaseServiceBroker > initServices > INFO: Finished initializing all services! > Jun 11, 2009 9:15:39 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Start Initializing service (late): RunDataService > Jun 11, 2009 9:15:39 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Finish Initializing service (late): RunDataService > Jun 11, 2009 9:15:39 AM org.apache.turbine.Turbine init > INFO: Turbine: init() Ready to Rumble! > Jun 11, 2009 9:15:40 AM org.apache.coyote.http11.Http11Protocol start > INFO: Starting Coyote HTTP/1.1 on http-8080 > Jun 11, 2009 9:15:40 AM org.apache.catalina.startup.Catalina start > INFO: Server startup in 3813 ms > > > > > Then hit the following URL: > > http://www2.cms.com:8080/webswamp/swamp > > > With no success and only the following appearing in the log: > > Jun 11, 2009 9:16:12 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Start Initializing service (late): UploadService > Jun 11, 2009 9:16:12 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Finish Initializing service (late): UploadService > Jun 11, 2009 9:16:12 AM org.apache.turbine.Turbine init > INFO: Turbine: first Request successful > Jun 11, 2009 9:16:12 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Start Initializing service (late): SecurityService > Jun 11, 2009 9:16:12 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Finish Initializing service (late): SecurityService > Jun 11, 2009 9:16:12 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Start Initializing service (late): ServletService > Jun 11, 2009 9:16:12 AM org.apache.turbine.services.BaseServiceBroker > getService > INFO: Finish Initializing service (late): ServletService > 11.06 09:16:13 [INFO ] Adding i18n de.suse.swamp.webswamp.i18n.Webswamp > to cache > Jun 11, 2009 9:20:37 AM org.apache.turbine.services.schedule.JobEntry > calcRunTime > INFO: Next runtime for task NotifyScheduler is Thu Jun 11 09:25:37 PDT 2009 > 11.06 09:20:37 [DEBUG] Scheduled job sendnotifies() task: > NotifyScheduler ran @: Thu Jun 11 09:20:37 PDT 2009 > > > > Thanks any help would be greatly appreciated. > > > --- On *Thu, 6/11/09, Thomas Schmidt /<[email protected]>/* wrote: > > > From: Thomas Schmidt <[email protected]> > Subject: Re: [swamp-devel] Unable to login as "swamp_user" or > "swamp_admin" after successful install > To: [email protected] > Date: Thursday, June 11, 2009, 4:14 AM > > Diego Bowen wrote: > > Hello I successfully installed swamp and bring up the login page: > > http://localhost:8080/webswamp/swamp, however i'm unable to login. > > Nothing even appears in the logs showing that it even attempted > > such....please help!! :) > > Do you have the entries for these users in your database (dbUsers > table)? > MySQL setup: > > http://swamp.sourceforge.net/index.php?seite=doc2html&docpage=html-installguide/x74.html > > <http://swamp.sourceforge.net/index.php?seite=doc2html&docpage=html-installguide/x74.html> > Login attempts should get logged in catalina.out. What does the page > display when you try to login? > > Greetings > > -- > Thomas Schmidt (tschmidt [at] suse.de) > SUSE Linux Products GmbH :: Research & Development :: Tools > "Linux is een Bedriefssysteem för Reekners. Dat is een Oort > vun Unix, un Linus Torvalds hett sick dat infallen laaten." > > > ------------------------------------------------------------------------------ > Crystal Reports - New Free Runtime and 30 Day Trial > Check out the new simplified licensing option that enables unlimited > royalty-free distribution of the report engine for externally facing > server and web deployment. > http://p.sf.net/sfu/businessobjects > _______________________________________________ > swamp-devel mailing list > [email protected] > </mc/[email protected]> > https://lists.sourceforge.net/lists/listinfo/swamp-devel > http://swamp.sf.net > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > Crystal Reports - New Free Runtime and 30 Day Trial > Check out the new simplified licensing option that enables unlimited > royalty-free distribution of the report engine for externally facing > server and web deployment. > http://p.sf.net/sfu/businessobjects > > > ------------------------------------------------------------------------ > > _______________________________________________ > swamp-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/swamp-devel > http://swamp.sf.net -- Thomas Schmidt (tschmidt [at] suse.de) SUSE Linux Products GmbH :: Research & Development :: Tools "Don't Panic", Douglas Adams (1952 - 11.05.2001) ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ swamp-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/swamp-devel http://swamp.sf.net
