Does the socket file exists?
What's in your /etc/my.cnf (or my.cnf.d/some other config file) under
[mysqld]?
[mysqld]
socket=/path/to/datadir/mysql/mysql.sock
If a socket value doesn't exist, either create one, or create a link
between the actual socket file and /var/run/mysqld/mysqld.sock
BTW - either you have a typo in your mail, or your socket is
misconfigured - never saw mysqld.soc (without 'k' at end) as the name of
the socket, although it's certainly legal.
Other option is that the mysql server is not running - did you start the
daemon?
On 05/21/2016 01:45 PM, Husen R wrote:
Re: [slurm-dev] How to setup slurm database accounting feature
I checked slurmctld.log, I got this error message. how to solve this ?
[2016-05-21T17:37:40.589] error: mysql_real_connect failed: 2002 Can't
connect to local MySQL server through socket '/var/run/mysqld/mysqld.soc$
[2016-05-21T17:37:40.589] fatal: You haven't inited this storage yet.
Thank you in advance
oe
Regards,
Husen
On Sat, May 21, 2016 at 3:16 PM, Husen R <[email protected]
<mailto:[email protected]>> wrote:
dear all,
I tried to configure slurm accounting feature using database.
I already read the instruction available in this page
http://slurm.schedmd.com/accounting.html, but the accounting
feature still not working.
I got this error message when I try to execute sacct command :
sacct: error: Problem talking to the database: Connection refused
the following is my slurm.conf:
----------------------------------------------------------------------------------Slurm.conf----------------------------------------------------------------
#
# Sample /etc/slurm.conf for mcr.llnl.gov <http://mcr.llnl.gov>
#
ControlMachine=head-node
ControlAddr=head-node
#BackupController=mcrj
#BackupAddr=emcrj
#
AuthType=auth/munge
CheckpointType=checkpoint/blcr
#Epilog=/usr/local/slurm/etc/epilog
FastSchedule=1
#JobCompLoc=/var/tmp/jette/slurm.job.log
JobCompType=jobcomp/mysql
#AccountingStorageType=accounting_storage/mysql
AccountingStorageType=accounting_storage/slurmdbd
AccountingStorageHost=localhost
AccountingStoragePass=/var/run/munge/munge.socket.2
ClusterName=comeon
JobCompHost=head-node
JobCompPass=password
JobCompPort=3306
JobCompUser=root
JobCredentialPrivateKey=/usr/local/etc/slurm.key
JobCredentialPublicCertificate=/usr/local/etc/slurm.cert
MsgAggregationParams=WindowMsgs=2,WindowTime=100
PluginDir=/usr/local/lib/slurm
JobCheckpointDir=/mirror/source/cr
#Prolog=/usr/local/slurm/etc/prolog
MailProg=/usr/bin/mail
SchedulerType=sched/backfill
SelectType=select/linear
SlurmUser=slurm
SlurmctldLogFile=/var/tmp/slurmctld.log
SlurmctldPort=7002
SlurmctldTimeout=300
SlurmdPort=7003
SlurmdSpoolDir=/var/tmp/slurmd.spool
SlurmdTimeout=300
SlurmdLogFile=/var/tmp/slurmd.log
StateSaveLocation=/var/tmp/slurm.state
#SwitchType=switch/none
TreeWidth=50
#
# Node Configurations
#
NodeName=DEFAULT CPUs=8 RealMemory=5949 TmpDisk=64000 State=UNKNOWN
NodeName=head-node,compute-node,spare-node
NodeAddr=head-node,compute-node,spare-node SocketsPerBoard=1
CoresPerSocket=4 ThreadsPerCore=2
#
# Partition Configurations
#
PartitionName=DEFAULT State=UP
PartitionName=comeon Nodes=head-node,compute-node,spare-node
MaxTime=168:00:00 MaxNodes=32 Default=YES
--------------------------------------------------------------------------------------------------------------------
what is the difference between slurmdbd and mysql ?
based on the information in this page,
http://slurm.schedmd.com/accounting.html, slurmdbd has its own
configuration file called slurmdbd.conf.
is there any example of slurmdbd.conf file ? where should I store
this file ? how do I setup slurm to read slurmdbd.conf file ?
I have installed mysql. I also have created slurm_acct_db database.
I need help.
Thank you in advance
regards,
Husen
