Re: Centralized DSN Switch Script (MySQL)

Replies are listed 'Best First'.
Re: Re: Centralized DSN Switch Script (MySQL) by Purdy (Hermit) on Nov 02, 2001 at 02:26 UTC
sites-dev - the full path would be something like "/home/sites-dev/site3/web/cgi-bin/script.pl" - that would be a script that runs on the development server. A production server script would be in the path "/home/sites/site3/web/cgi-bin/script.pl". It looks like the DSN is coming through fine (I commented out that 'my ($dsn)' line and in the script that required this central script, printed out $dsn. I'm sure there are other configuration questions, too, but don't know where to start. Thanks!	[reply]
Re: Re: Re: Centralized DSN Switch Script (MySQL) by lucs (Sexton) on Nov 02, 2001 at 03:05 UTC
Okay. Thought it might have been a typo :-) So, your tests show that in the development environment, `$dsn` expands to `DBI:mysql:database=foo;port=3308` (which is what you seem to want), yet the wrong database is being updated. If that is correct, I don't know what's wrong; the perl up to here is fine. Sorry.	[reply] [d/l] [select]
Re: Re: Re: Re: Centralized DSN Switch Script (MySQL) by Purdy (Hermit) on Nov 02, 2001 at 03:09 UTC
At least I'm not alone then in my bogglement. ;) I was thinking that maybe it has something to do in the DBD/DBI layer. Oh man, I'm gonna lose some more hair over this one... Thanks, lucs	[reply]