Hello, Welcome to part 2 of my migration madness. I was able to get the postgresql extension working from my last message using the following in the ext/pgsql folder of php's source: phpize; configure --with-pgsql --with-apxs ; make ; make install; I also had to create a text file in /etc/php.d/ called pgsql.ini with a reference to the pgsql.so (RPMS make our live better in what way? :) ) Never got a chance to try Daniel's way because I stopped when I saw that it was working.
Which leads to my new problem: getting midgard to connect to the database.
The db is installed on the same server as apache, so it's just a localhost connection. This is what mysqlaccess tells me:
mysqlaccess -u midgard -h localhost -d midgard -p
Access-rights
for USER 'midgard', from HOST 'localhost', to DB 'midgard'
+-----------------+---+ +-----------------+---+
| Select_priv | Y | | Show_db_priv | Y |
| Insert_priv | Y | | Super_priv | Y |
| Update_priv | Y | | Create_tmp_table_priv | Y |
| Delete_priv | Y | | Lock_tables_priv | Y |
| Create_priv | Y | | Execute_priv | Y |
| Drop_priv | Y | | Repl_slave_priv | Y |
| Reload_priv | Y | | Repl_client_priv | Y |
| Shutdown_priv | Y | | Ssl_type | ? |
| Process_priv | Y | | Ssl_cipher | ? |
| File_priv | Y | | X509_issuer | ? |
| Grant_priv | Y | | X509_subject | ? |
| References_priv | Y | | Max_questions | 0 |
| Index_priv | Y | | Max_updates | 0 |
| Alter_priv | Y | | Max_connections | 0 |
+-----------------+---+ +-----------------+---+
NOTE: A password is required for user `midgard' :-(The following rules are used:
db : 'No matching rule'
host : 'Not processed: host-field is not empty in db-table.'
user : 'localhost','midgard','7665a2ee092047e5','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','','0','0','0'
permissions seem OK and I have no problems connecting as midgard from the command line. What could be the problem?
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
