[gold-users] new install, goldd error

[Andrew Ring]

Hello Scott,

Looks like that was it.

While I could connect from the OS user account 'gold' to mysql; the 
mysql connection was using username 'root', not as mysql user 'gold'. 
Connecting once with "mysql -u gold" did something and now goldd starts.


No, the servers name is not gold.servername.

Thank you,
Andrew

On 02/01/2013 01:01 PM, Scott Jackson wrote:
> Andrew,
>
> Is your gold server really called gold.servername? Are you just
> obscuring it for security purposes?
>
> So, if you run mysql gold -h gold.servername -u gold
>
> does it work?
>
> Scott
>
> On Thu, Jan 31, 2013 at 3:26 PM, Andrew Ring <apring at umn.edu
> <mailto:apring at umn.edu>> wrote:
>
>     Hello,
>
>     I am installing Gold 2.2.0.5, and things were going smoothly until it
>     was time to run goldd.
>
>     [gold at gold gold]$ goldd
>     Starting Gold Pid (14622)
>
>     [gold at gold gold-2.2.0.5]$ DBI
>     connect('database=gold;host=gold.servername','gold',...) failed: Access
>     denied for user ''@'gold.servername' to database 'gold' at
>     /opt/gold/lib/Gold/Database.pm line 164
>
>
>     It appears that goldd is finding the appropriate username, but not
>     propagating it to the database connect code.
>
>     My /opt/gold/etc/goldd.conf
>     # Gold Server Config File
>
>     super.user = gold
>
>     server.host = gold.servername
>     # server.port = 7112
>
>     database.datasource = DBI:mysql:database=gold;host=gold.servername
>     database.user = gold
>     # database.password = NONE
>
>     response.chunksize = 100000
>     # currency.precision = 0
>
>     # security.authentication = true
>     # security.encryption = false
>
>     # account.autogen = true
>     # allocation.autogen = true
>     # machine.autogen = false
>     # machine.default = NONE
>     # project.autogen = false
>     # project.default = NONE
>     # user.autogen = false
>     # user.default = NONE
>
>     # Log4perl configuration
>     log4perl.logger = TRACE, Log, Screen
>     log4perl.appender.Log.Threshold = TRACE
>     log4perl.appender.Screen.Threshold = FATAL
>     #log4perl.logger.Message = TRACE, Screen
>     #log4perl.appender.Log = Log::Log4perl::Appender::File
>     log4perl.appender.Log = Log::Dispatch::FileRotate
>     log4perl.appender.Log.filename = /opt/gold/log/goldd.log
>     log4perl.appender.Log.mode = append
>     log4perl.appender.Log.size = 10000000
>     log4perl.appender.Log.max = 7
>     log4perl.appender.Log.layout = PatternLayout
>     log4perl.appender.Log.layout.ConversionPattern = %d{yyyy-MM-dd
>     HH:mm:ss.SSS} %-5p %M  %m%n
>     log4perl.appender.Screen = Log::Log4perl::Appender::Screen
>     log4perl.appender.Screen.layout = PatternLayout
>     log4perl.appender.Screen.layout.ConversionPattern = %d{yyyy-MM-dd
>     HH:mm:ss.SSS} %-5p %M [%F:%L]  %m%n
>
>
>     Thank you for your help,
>     Andrew Ring
>     _______________________________________________
>     gold-users mailing list
>     gold-users at supercluster.org <mailto:gold-users at supercluster.org>
>     http://www.supercluster.org/mailman/listinfo/gold-users
>
>
>
>
> _______________________________________________
> gold-users mailing list
> gold-users at supercluster.org
> http://www.supercluster.org/mailman/listinfo/gold-users

-- 
Andrew Ring
HPC Systems Administrator
University of Minnesota Twin Cities
Phone: 612-624-8860                 Fax: 612-624-8861
Mail:                               Office:
599 Walter Library                  543 Walter Library
117 Pleasant St S.E.                117 Pleasant St S.E.
Minneapolis, MN 55455               Minneapolis, MN 55455