$db['default']['hostname'] as database name (!)

[Jonathan Hayward]

I am working to set up a 0.9.2 server with a dedicated database under
MySQL on another server, and am running into difficulties with the
hostname being misread to be the database name as well. When I use the
FQDN of the MySQL server as the hostname, I get:

Couldn't create database: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near '.[domain].net' at line 1 (this may not be a
problem if you've already created the database).

If I delete '.[domain].net', then the error changes:

Couldn't create database: Access denied for user 'poll_user'@'%' to
database '[hostname]' (this may not be a problem if you've already
created the database).

I've presently used a workaround my system administrator offered,
namely a DNS alias where the name of the database points to the
server, and then it works. But this looks like a bug.

--
Jonathan Hayward, christos.jon...@gmail.com
An Orthodox Christian author: theology, literature, et cetera.
My award-winning collection is available for free reading online:
I invite you to visit my website at http://JonathansCorner.com/

[Jeffrey McManus]

Jonathan,

Thanks for the feedback.

This sounds like an issue with the installer, not the main
application, is that correct?

Jeffrey

[Jonathan Hayward]

It could well be. It occurred while using the installer, not the main application.

[Jeffrey McManus]

Gotcha. I've logged this as a bug here:

http://code.google.com/p/tinypug/issues/detail?id=84

I was just about to crack open the installer for the 0.9.3 release, so
I should be able to get a look at this soon (possibly today).

Jeffrey


On Fri, Jun 26, 2009 at 10:28 AM, Jonathan

[Jonathan Hayward]

Thanks!