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
_______________________________________________ Users mailing list Users@lists.opennebula.org http://lists.opennebula.org/listinfo.cgi/users-opennebula.org