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.plcreate "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:

On Saturday, June 23, 2012 2:40:46 PM UTC+3, volkerbradley wrote:

> 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.plcreate "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:

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

> Thank you Volker. Waiting for your reply.

> On Saturday, June 23, 2012 2:40:46 PM UTC+3, volkerbradley wrote:

>> 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:

On Sunday, June 24, 2012 6:37:01 PM UTC+3, volkerbradley wrote:

> 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<http://www.trendsigma.net/vmware/debian6t.html>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

> On Saturday, June 23, 2012 11:13:20 AM UTC-4, sajjad.kernel wrote:

>> Thank you Volker. Waiting for your reply.

>> On Saturday, June 23, 2012 2:40:46 PM UTC+3, volkerbradley wrote:

>>> 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:

On Monday, June 25, 2012 3:38:40 AM UTC-4, sajjad.kernel wrote:

> 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.

> On Sunday, June 24, 2012 7:04:56 PM UTC+3, sajjad.kernel wrote:

>> 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.

>> On Sunday, June 24, 2012 6:37:01 PM UTC+3, volkerbradley wrote:

>>> 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<http://www.trendsigma.net/vmware/debian6t.html>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

>>> On Saturday, June 23, 2012 11:13:20 AM UTC-4, sajjad.kernel wrote:

>>>> Thank you Volker. Waiting for your reply.

>>>> On Saturday, June 23, 2012 2:40:46 PM UTC+3, volkerbradley wrote:

>>>>> 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:

On Mon, Jun 25, 2012 at 9:50 AM, volkerbradley <volkerbrad...@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.