Ok, What I found was the following.
Install mysql, Install midgard Get error messages about client authentication Set the admin user account to use old style passwords Flush the privileges on the DB Midgard still threw problems. Set the old_passwords in my.cnf Restarted mysql server Created a midgard account in mysql, and run the sql to set password for the user with oldstyle passwords. Flushed privileges. Midgard worked. Why I used phpmyadmin was to ensure that the user I had created for it, could read the db and therefore a user created by datagard should/would also be able to read/write the db. It's a pain, and the MySQL docs aren't entirely clear on a full proof way (in my opinion) as some things work, some don't - but a combination of setting old_passwords in My.cnf AND using sql to change the user passwords to the old styles seemed to work. As I said, it's worth sticking with, as this problem will haunt you whatever application you try installing. >-----Original Message----- >From: news [mailto:[EMAIL PROTECTED] On Behalf Of Clifford >Sent: Wednesday, September 14, 2005 11:02 AM >To: [email protected] >Subject: [midgard-user] Re: Install Midgard 1.7.1-1 on Suse 9.3 > >[EMAIL PROTECTED] wrote: >> Whilst I agree that the installation can be confusing the problem that >> you having is a MySQL one. The link I gave: >> http://dev.mysql.com/doc/mysql/en/old-client.html >I did look at this with the use of the oldpassword function. > >What I don't understand is why as Datagard is creating the database and >user name/password access rules to it (after all it has asked for my mysql >admin sign on), then why is it not either doing this automatically or been >adjusted in these newer versions to do things correctly depending on what >version mysql is being used? Is this something that could be looked into >for the next release? > >As I say its created everything - so why does it fail to then connect - >from what I can see it gets in to create the tables in the database so why >does it then not get anyfurther? > >> You can test if all is working with the old style passwords, by say >> trying to install phpmyadmin on your server. If that works, then midgard >> should work fine. > >Are you suggesting that I create the user and not the database/tables >rather than letting datagard do it >Clifford > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
