[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Artanis] problem with Database operating
From: |
Nala Ginrut |
Subject: |
Re: [Artanis] problem with Database operating |
Date: |
Sat, 09 Feb 2019 00:49:59 +0800 |
User-agent: |
mu4e 1.0; emacs 25.1.1 |
Hi!
You may take a look at here:
https://gitlab.com/NalaGinrut/artanis/blob/master/artanis/config.scm#L52
Or if you've created application folder already, you may use 'art create
--upgrade' inside the folder to upgrade the conf/artanis.conf to see the
inline document.
Best regards.
xiewensheng writes:
> Hi, artanis,
>
> in the conf file, how can one disable port mode and enable sock mode?
>
> addr=false
> still enable port mode.
>
> wxie
>
>
>
> Sent from my Mi phone
> On xiewensheng <address@hidden>, Feb 1, 2019 6:52 AM wrote:
> yes, mysql REPL is fine.
>
>
>
> Sent from my Mi phone
> On Nala Ginrut <address@hidden>, Feb 1, 2019 1:36 AM wrote:
>
> Can you connect to mysql? For example:
> -----------------------------------
> mysql -u root -p
> -----------------------------------
>
> And input your passwd to see if it can enter the REPL of
> mysql.
> If you can do that, then it means mysql/mariaDB started
> successfully.
>
> Usually, the default config of mysql is to open an UNIX
> socket named
> /var/run/mysqld/mysqld.sock for connecting. And if it
> doesn't exist, it
> means mysql may not start successfully.
>
> Please give it a try.
>
> Best regards.
>
>
> xiewensheng writes:
>
> > Hi, Nala,
> > that link does not solve my problem.
> > My mysql version gives you a hint.
> > mysql ver 14.14 Distrib 5.7.25
> > for Linux (x86_64) using EditLine wrapper
> >
> >
> >
> > Sent from my Mi phone
> > On Nala Ginrut <address@hidden>, Jan 30, 2019 00:30 wrote:
> >
> > Hi Xie!
> > The problem is that MySQL can't find /var/run/mysqld/
> mysqld.sock
> > Here's a solution:
> > https://mariadb.com/kb/en/library/missing-mysqldsock-
> file/
> >
> >
> > Wensheng Xie writes:
> >
> > > Hi, Nala:
> > >
> > > Thanks for the reply.
> > >
> > > sudo service mysql restart
> > > ==> ok
> > >
> > > netstat -pan | grep mysql
> > > ==> listening xxxx - /var/run/mysqld/mysqld.sock
> > >
> > > However, I still have the same problem with
> artanis.
> > >
> > > What do you want to know about /var/run/mysqld/
> mysqld.sock?
> > > cat /var/run/mysqld/mysqld.sock
> > > ==>no such device or address
> > >
> > > Could you help?
> > > wxie
> > >
> > >
> > > On Tue, Jan 22, 2019 at 12:49 AM Nala Ginrut
> <address@hidden> wrote:
> > >
> > >>
> > >> hi Xie!
> > >> Could you confirm that your MySQL is start?
> > >> And please take a look at /var/run/mysqld/
> mysqld.sock
> > >>
> > >>
> > >> Wensheng Xie writes:
> > >>
> > >> > Hi, artanis:
> > >> >
> > >> > Using guile 2.2.4, artanis 0.3.1, I tried to run
> the mysql db
> > code:
> > >> >
> > >> > (define conn (connect-db 'mysql #:db-username
> "test_user_1"
> > >> > #:db-name "my_artanis_db" #:db-passwd
> > >> "your_passwd"))
> > >> >
> > >> >
> > >> > /etc/artanis/artanis.conf was modified for the
> db.name and user
> > name.
> > >> >
> > >> > on the mysql side, user address@hidden
> was grant all
> > priviledges
> > >> for
> > >> > my_artanis_db.
> > >> >
> > >> > However, I still got the error:
> > >> > (500 "connect to DB error:" "file not found")
> > >> >
> > >> > It points to the above line of code.
> > >> >
> > >> > Is there any body making this working?
> > >> >
> > >> >
> > >> > best regards,
> > >> > wxie
> > >>
> > >>
> > >> --
> > >> GNU Powered it
> > >> GPL Protected it
> > >> GOD Blessed it
> > >> HFG - NalaGinrut
> > >> Fingerprint F53B 4C56 95B5 E4D5 6093 4324 8469
> 6772 846A 0058
> > >>
> >
> >
> > --
> > GNU Powered it
> > GPL Protected it
> > GOD Blessed it
> > HFG - NalaGinrut
> > Fingerprint F53B 4C56 95B5 E4D5 6093 4324 8469 6772
> 846A 0058
>
>
> --
> GNU Powered it
> GPL Protected it
> GOD Blessed it
> HFG - NalaGinrut
> Fingerprint F53B 4C56 95B5 E4D5 6093 4324 8469 6772 846A
> 0058
--
GNU Powered it
GPL Protected it
GOD Blessed it
HFG - NalaGinrut
Fingerprint F53B 4C56 95B5 E4D5 6093 4324 8469 6772 846A 0058
signature.asc
Description: PGP signature