MySQL on Mac OS 10.4.6 Server problems

[Tom Morrison]

I've just installed AwareIM on a Mac 10.4.6 server that's running MySQL 4.1.13a. I set the root password and changed the BASServer.props file to match (check and reset several times).

I just downloaded the installed copy of AwareIM yesterday from your site.

MySQL is running.

The only connector file is: mysql-connector-java-3.1.12-bin.jar

When I attempt to start up AwareIM, it gets to the point where it's trying to start the AwareIM Server and produces the following message:
"AwareIM was unable to create or locate the databases it requires. Please check that your database software is running."

Here's the output listing from a dump of the mysql user table:
mysql> select * from user;
+------------------------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections |
+------------------------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
| localhost | root | *84B5311B8800AE63045796781FCE9BCC079DBC39 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 |
| filewave.stvincent.edu | root | *84B5311B8800AE63045796781FCE9BCC079DBC39 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 |
| filewave.stvincent.edu | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 |
| localhost | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 |
+------------------------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
4 rows in set (0.00 sec)

[Tom Morrison]

I'm using MySQL Manager under 10.4.6 Server to start/stop MySQL. I had to check the box "Allow network connections". Evidently, that's the way you connect to MySQL.

Thanks! Sorry for wasting your time.

[aware_support]

So the problem has been resolved by ticking the "Allow network connections" checkbox?

[Tom Morrison]

Yes, the problem was corrected and I'm up and running. Thanks.