(eu levei em consideração que ele ja devia ter criado a database e as
tables corretamente)


On Sun, Mar 23, 2014 at 9:26 PM, Max Miorim <[email protected]> wrote:

> Tu tem que configurar tanto o MySQL quanto o Amarok, segundo a
> documentação oficial:
>
>
> http://userbase.kde.org/Amarok/Manual/Organization/Collection/ExternalDatabase
>
> Chegou a fazer a parte do Amarok ou tu só criou o usuário no MySQL?
>
> On Sun, Mar 23, 2014 at 8:24 PM, Gilberto F da Silva
> <[email protected]> wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > On Sun, Mar 23, 2014 at 05:28:17PM -0300, J. Tozo wrote:
> >> ops copiei e colei, ta errado.
> >>
> >> mysql> GRANT ALL ON amarok.* TO *amarokuser*@localhost IDENTIFIED BY
> >> 'senha';
> >
> >   Segui esses passos porém, o amarok ainda não consegue se conectar ao
> MariaDB.
> >
> > Welcome to the MariaDB monitor.  Commands end with ; or \g.
> > Your MariaDB connection id is 13
> > Server version: 5.5.32-MariaDB MariaDB Server
> >
> > Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
> >
> > MariaDB [(none)]> GRANT ALL PRIVILEGES ON amarokdb.* TO 'amarokuser'
> IDENTIFIED BY 'senha';
> > Query OK, 0 rows affected (0.00 sec)
> >
> > MariaDB [(none)]> GRANT ALL PRIVILEGES ON amarokdb.* TO amarokuser
> IDENTIFIED BY '123mudar';
> > Query OK, 0 rows affected (0.00 sec)
> >
> > MariaDB [(none)]> GRANT ALL PRIVILEGES ON amarokdb.* TO 'amarokuser'
> IDENTIFIED BY '123mudar';
> > Query OK, 0 rows affected (0.00 sec)
> >
> > MariaDB [(none)]> flush privileges;
> > Query OK, 0 rows affected (0.00 sec)
> >
> > MariaDB
> >
> >
> >
> > amarok:           [CollectionManager] initializing
> "amarok_collection-mysqlservercollection"
> > amarok:           BEGIN: MySqlServerStorage::MySqlServerStorage()
> > amarok:             Automatic reconnect successfully activated
> > amarok:             connection to mysql failed
> > amarok:             [ERROR__] Could not connect to mysql!
> > amarok:             [ERROR__] [MySqlStorage] "GREPME MySQL-server query
> failed! (1045) Access denied for user 'amarokuser'@'localhost' (using
> password: YES) on na"
> > amarok:             [MySqlStorage] Initialized thread, count== 1
> > amarok:           END__: MySqlServerStorage::MySqlServerStorage() [Took:
> 0.006s]
> > amarok:           [ERROR__] Tried to query an uninitialized m_db!
> > amarok:           [ERROR__] Tried to query an uninitialized m_db!
> > amarok:           BEGIN: bool DatabaseUpdater::update()
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:             Database version:  0
> > amarok:             BEGIN: void DatabaseUpdater::createTables() const
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:               [ERROR__] Tried to query an uninitialized m_db!
> > amarok:             END__: void DatabaseUpdater::createTables() const
> [Took: 0.001s]
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:           END__: bool DatabaseUpdater::update() [Took: 0.001s]
> > amarok:           BEGIN:
> SqlRegistry::SqlRegistry(Collections::SqlCollection*)
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:             [ERROR__] Tried to query an uninitialized m_db!
> > amarok:           END__:
> SqlRegistry::SqlRegistry(Collections::SqlCollection*) [Took: 0s]
> > amarok:           BEGIN: virtual int App::newInstance()
> > amarok:             BEGIN: static void App::handleCliArgs()
> > amarok:             END__: static void App::handleCliArgs() [Took: 0s]
> > amarok:           END__: virtual int App::newInstance() [Took: 0s]
> > bash-4.2$ amarok:           [ERROR__] Tried to query an uninitialized
> m_db!
> > amarok:           [ERROR__] Tried to query an uninitialized m_db!
> > amarok:           [ERROR__] Tried to query an uninitialized m_db!
> > amarok:           [ERROR__] Tried to query an uninitialized m_db!
> > amarok:           [ERROR__] Tried to query an uninitialized m_db!
> > amarok:           [ERROR__] Tried to query an uninitialized m_db!
> > amarok:           [ERROR__] Tried to query an uninitialized m_db!
> > amarok:           [ERROR__] Tried to query an uninitialized m_db!
> > KCrash: Application 'amarok' crashing...
> > KCrash: Attempting to start /usr/lib64/kde4/libexec/drkonqi from kdeinit
> > sock_file=/home/slackware141/.kde/socket-darkstar/kdeinit4__0
> > QSocketNotifier: Invalid socket 8 and type 'Read', disabling...
> > QSocketNotifier: Invalid socket 16 and type 'Read', disabling...
> > amarok: Fatal IO error: client killed
> >
> > - --
> > Gilberto F da Silva - [email protected] - ICQ 136.782.571
> > Stela dato:2.456.740,453  Loka tempo:2014-03-23 19:52:21 Dimanĉo
> > - -==-
> > Se o homem não sabe a que porto se dirige, nenhum vento lhe será
> > favorável.
> >                 -- Sêneca
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.4.15 (GNU/Linux)
> > Comment: +---------------------------------------+
> > Comment: ! Gilberto F da Silva - ICQ 136.782.571 !
> > Comment: ! Slackware 14.1 64   -   yahoo gfs1989 !
> > Comment: +---------------------------------------+
> >
> > iEYEARECAAYFAlMvbR4ACgkQJxugWtMhGw5qkwCeLXTF3AXZNWFjFwxAjeD+j77T
> > 3sYAoObk5w788bAUsnKNHFEBKcHlFMI2
> > =4Ik5
> > -----END PGP SIGNATURE-----
> >
> > --
> > GUS-BR - Grupo de Usuários de Slackware Brasil
> > http://www.slackwarebrasil.org/
> > http://groups.google.com/group/slack-users-br
> >
> > Antes de perguntar:
> > http://www.istf.com.br/perguntas/
> >
> > Para sair da lista envie um e-mail para:
> > [email protected]
> > ---
> > Você está recebendo esta mensagem porque se inscreveu no grupo
> "Slackware Users Group - Brazil" dos Grupos do Google.
> > Para cancelar inscrição nesse grupo e parar de receber e-mails dele,
> envie um e-mail para [email protected].
> > Para obter mais opções, acesse https://groups.google.com/d/optout.
>
> --
> GUS-BR - Grupo de Usuários de Slackware Brasil
> http://www.slackwarebrasil.org/
> http://groups.google.com/group/slack-users-br
>
> Antes de perguntar:
> http://www.istf.com.br/perguntas/
>
> Para sair da lista envie um e-mail para:
> [email protected]
> ---
> Você está recebendo esta mensagem porque se inscreveu no grupo "Slackware
> Users Group - Brazil" dos Grupos do Google.
> Para cancelar inscrição nesse grupo e parar de receber e-mails dele, envie
> um e-mail para [email protected].
> Para obter mais opções, acesse https://groups.google.com/d/optout.
>



-- 
Grato,

J. Tozo
     _
   °v°
  /(S)\    SLACKWARE
   ^ ^           Linux
_____________________
         because it works

-- 
GUS-BR - Grupo de Usuários de Slackware Brasil
http://www.slackwarebrasil.org/
http://groups.google.com/group/slack-users-br

Antes de perguntar:
http://www.istf.com.br/perguntas/

Para sair da lista envie um e-mail para:
[email protected]
--- 
Você está recebendo esta mensagem porque se inscreveu no grupo "Slackware Users 
Group - Brazil" dos Grupos do Google.
Para cancelar inscrição nesse grupo e parar de receber e-mails dele, envie um 
e-mail para [email protected].
Para obter mais opções, acesse https://groups.google.com/d/optout.

Responder a