Re: [Artanis] problem with Database operating

[Nala Ginrut]

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