Re: localhost/hostname in datasource
Hi, I think it is a possible authority issue. >From mysql database allow the user to access, like > grant all privileges on myDatabase.* to [EMAIL PROTECTED] Another possible thing, (not sure) is that the port number for mysql is 3306. try .. jdbc:mysql://127.0.0.1:3306/myDatabase... rgds, - Original Message - From: "Stefan Burkard" <[EMAIL PROTECTED]> To: Sent: Wednesday, June 07, 2006 3:17 PM Subject: localhost/hostname in datasource > hi cocoon-users > > I have a mysql-datasource defined in cocoon.xconf (like the example below). > > jdbc:mysql://127.0.0.1/myDatabase > myUsername > myPassword > > what's strange now, is that I get an exception on startup that my > data-access-user has no permission for the host [fully qualified hostname]. > > why does my database-url with localhost resolve to the hostname? this > way I would have to grant access in mysql for the fully qualified > hostname... > > thanks and regards > stefan > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: localhost/hostname in datasource
Hi Stefan, Seems to be a database permissions issue. Before configuring in cocoon, please make sure you can access your database using a jdbc client application ie: SQuirrel SQL or from the mysql admin tool. Best Regards, Antonio Gallardo. [1] http://squirrel-sql.sourceforge.net/ Stefan Burkard escribió: hi cocoon-users I have a mysql-datasource defined in cocoon.xconf (like the example below). jdbc:mysql://127.0.0.1/myDatabase myUsername myPassword what's strange now, is that I get an exception on startup that my data-access-user has no permission for the host [fully qualified hostname]. why does my database-url with localhost resolve to the hostname? this way I would have to grant access in mysql for the fully qualified hostname... thanks and regards stefan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
localhost/hostname in datasource
hi cocoon-users I have a mysql-datasource defined in cocoon.xconf (like the example below). jdbc:mysql://127.0.0.1/myDatabase myUsername myPassword what's strange now, is that I get an exception on startup that my data-access-user has no permission for the host [fully qualified hostname]. why does my database-url with localhost resolve to the hostname? this way I would have to grant access in mysql for the fully qualified hostname... thanks and regards stefan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
