<div>Hi,</div><div><br></div><div>I am trying to use MySQL with Opennebula Watch, but I have problems to connect to the database.</div><div>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:</div>
<div><br></div><div>:DB: mysql://oneadmin:password@localhost/oneacct</div><div><br></div><div>When I run oneacctd start I get the following error message (note that i installed the gems sqlite3 and ruby-mysql):</div><div>
<br></div><div>option not implemented: 5<br>/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)<br>
        from /var/lib/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql/protocol.rb:212:in `new'<br>        from /var/lib/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql/protocol.rb:212:in `initialize'<br>        from /usr/lib/ruby/1.8/timeout.rb:53:in `timeout'<br>
        from /var/lib/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql/protocol.rb:209:in `initialize'<br>        from /var/lib/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql.rb:110:in `new'<br>        from /var/lib/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql.rb:110:in `real_connect'<br>
        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:103:in `connect'<br>        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/misc.rb:48<br>        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool.rb:92:in `call'<br>
        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool.rb:92:in `make_new'<br>        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:127:in `make_new'<br>        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:113:in `available'<br>
        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:103:in `acquire'<br>        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:147:in `sync'<br>
        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:147:in `synchronize'<br>        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:147:in `sync'<br>
        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:102:in `acquire'<br>        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:74:in `hold'<br>
        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/connecting.rb:225:in `synchronize'<br>        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:23:in `execute'<br>
        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:74:in `execute_dui'<br>        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:67:in `execute_ddl'<br>        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/schema_methods.rb:377:in `create_table_from_generator'<br>
        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/schema_methods.rb:97:in `create_table'<br>        from /var/lib/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/schema_methods.rb:120:in `create_table?'<br>
        from /usr/lib/one/ruby/acct/watch_helper.rb:137:in `bootstrap'<br>        from /usr/lib/one/ruby/acct/watch_helper.rb:221<br>        from /usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'<br>
        from /usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in `require'<br>        from /usr/lib/one/ruby/acct/acctd.rb:35<br><br>Running the following command from the shell gives no error:</div><div><br></div><div>
mysql -h localhost -u oneadmin -p -D oneacct</div><div><br></div><div>I would appreciate if someone could tell me what I am doing wrong. Thanks.</div><div><br></div><div>Cheers,</div><div>Humberto</div><div><br></div>