Re: stuck at ./sql_user_admin.pl create "user" "password"

[volkerbradley]

Hi,
Will try to help you figure this out.  Give me a little time to install Debian 6 as a virtual machine and run through the install instructions.
Volker


On Saturday, June 23, 2012 3:36:13 AM UTC-4, sajjad.kernel wrote:

After three years I have returned back to Linux and I feel like I am using Linux for the first time :( :(

I am trying to install freemed ver 0.8.5 on debian 6.

I am getting following error when I run this command ./sql_user_admin.pl create "user" "password" 

DBI connect('database=remitt;host=127.0.0.1;port=3306','remitt',...) failed: Access denied for user 'remitt'@'localhost' (using password: YES) at /usr/share/remitt/bin/../lib/Remitt/Utilities.pm line 365

Can't call method "prepare" on an undefined value at /usr/share/remitt/bin/../lib/Remitt/Plugin/Authentication/SQL.pm line 97.

Also note that 

1- I used mysql -uroot -p instead of mysql -uroot in step 19 and when I run GRANT ALL ON remitt.* TO remitt@localhost IDENTIFIED BY 'remitt'; it says 0 rows affected.

2- And I run /usr/share/remitt ; for I in sql/*.sql; domysql -uroot -p remitt < $I; done . I have to type password three four times till I get the message foreign_id already exists. following is the putput of this command

root@server1:/usr/share/remitt#  for I in sql/*.sql; do mysql -uroot -p remitt < $I; done

Enter password: 

ERROR 1050 (42S01) at line 23: Table 'auth' already exists

Enter password: 

ERROR 1050 (42S01) at line 23: Table 'config' already exists

Enter password: 

Enter password: 

ERROR 1060 (42S21) at line 40: Duplicate column name 'foreign_id'

Enter password: 

[sajjad.kernel]

Thank you Volker. Waiting for your reply.

[volkerbradley]

Hi,
Hmm, I'm not an expert enough to sort out why you have these errors.
I downloaded the Debian 6 Squeeze image with VMware Tools vmware image from http://www.trendsigma.net/vmware/
After opening  this image with the vmware player,  I cut and pasted the Debian 6 install instructions into the terminal paying particular attentions to the permissions.
I did make sure that when I installed all of the dependencies in step 2, I did not set a root password for mySQL during the initial configuration of mySQL.
FreeMED installed perfectly.
Volker

[sajjad.kernel]

Ok I will try again and this time I will not set mysql password. Thanks for the reply. I will post my feedback after trying again.

[sajjad.kernel]

I configured it, it is working perfectly. but I dont understand why these errors, I only differ to set root password for mysql from the guide.

[volkerbradley]

Hi,
The important thing is that you are up and running.  We're delighted.
I've added a little hint to the installation instructions about the mySQL root password.
There are a number of  tutorials with screenshots at http://www.osemr.com/freemed/tutorials/ and the extensive context-sensitive Help menu inside each page of FreeMED in the version you have just installed.
Let us know if you have remaining questions if you can't find the answers at these places.
That being said, we are all hoping that folks will consider downloading and using version 0.9.0 instead.  This version is the development version.  Feature requests would be added as needed.
You can download this version by going to www.freemed.info/.download/freemed_vm/FreeMED%20Development.7z
It would help us to know what works or doesn't work for you.  Amongst other things, the billing system is much better in this version of FreeMED.  Many other improvements over v0.85 are present as well.
Volker

[Jeff]

On Mon, Jun 25, 2012 at 9:50 AM, volkerbradley <volker...@gmail.com> wrote:
> Hi,
> The important thing is that you are up and running.  We're delighted.
> I've added a little hint to the installation instructions about the mySQL
> root password.
> There are a number of  tutorials with screenshots at
> http://www.osemr.com/freemed/tutorials/ and the extensive context-sensitive
> Help menu inside each page of FreeMED in the version you have just
> installed.
> Let us know if you have remaining questions if you can't find the answers at
> these places.
> That being said, we are all hoping that folks will consider downloading and
> using version 0.9.0 instead.  This version is the development version.
> Feature requests would be added as needed.
> You can download this version by going to
> www.freemed.info/.download/freemed_vm/FreeMED%20Development.7z
> It would help us to know what works or doesn't work for you.  Amongst other
> things, the billing system is much better in this version of FreeMED.  Many
> other improvements over v0.85 are present as well.

I'd like to add that we've been migrating development over to github,
where we're hosting REMITT, FreeMED and FreeSHIM:

https://github.com/freemed

There are also some wiki pages there with installation instructions,
integration, etc, for some of the software.

--
Thanks,
Jeff
(je...@freemedsoftware.org)
FreeMED Software Foundation, Inc
http://freemedsoftware.org/