[one-users] Opennebula Watch and MySQL

[Humberto N. Castejon Martinez]

Hi,

I am trying to use MySQL with Opennebula Watch, but I have problems to
connect to the database.
I created a database oneacct in my MySQL server (the documentation says
neither whether the database has to be created nor if a specific name has
to be used) and have given all privileges on that database to the oneadmin
user. I edited the /etc/one/acctd.conf file and added a line like:

:DB: mysql://oneadmin:password@localhost/oneacct

When I run oneacctd start I get the following error message (note that i
installed the gems sqlite3 and ruby-mysql):

option not implemented: 5
/var/lib/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql/protocol.rb:212:in
`initialize': Errno::ENOENT: No such file or directory - /tmp/mysql.sock
(Sequel::DatabaseConnectionError)
from /var/lib/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql/protocol.rb:212:in
`new'
from /var/lib/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql/protocol.rb:212:in
`initialize'
from /usr/lib/ruby/1.8/timeout.rb:53:in `timeout'
from /var/lib/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql/protocol.rb:209:in
`initialize'
from /var/lib/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql.rb:110:in `new'
from /var/lib/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql.rb:110:in
`real_connect'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:103:in
`connect'
from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/misc.rb:48
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool.rb:92:in
`call'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool.rb:92:in
`make_new'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:127:in
`make_new'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:113:in
`available'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:103:in
`acquire'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:147:in
`sync'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:147:in
`synchronize'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:147:in
`sync'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:102:in
`acquire'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:74:in
`hold'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/connecting.rb:225:in
`synchronize'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:23:in
`execute'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:74:in
`execute_dui'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:67:in
`execute_ddl'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/schema_methods.rb:377:in
`create_table_from_generator'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/schema_methods.rb:97:in
`create_table'
from
/var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/schema_methods.rb:120:in
`create_table?'
from /usr/lib/one/ruby/acct/watch_helper.rb:137:in `bootstrap'
from /usr/lib/one/ruby/acct/watch_helper.rb:221
from /usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in
`gem_original_require'
from /usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in `require'
from /usr/lib/one/ruby/acct/acctd.rb:35

Running the following command from the shell gives no error:

mysql -h localhost -u oneadmin -p -D oneacct

I would appreciate if someone could tell me what I am doing wrong. Thanks.

Cheers,
Humberto
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20111103/039b6561/attachment-0002.htm>