PDA

View Full Version : ACC Guide for installation



scalesr1
2009-12-30, 00:45
Hello.



I am struggling with ACC. I am running Server V7.41 on a Windows 2008 64 bit
platform.

I have installed Album Catalogue Creator V1.6a and installed the ODBC driver
3.51.



ACC complains that it cannot connect to the MYSQL database and suggests that
it may not be set to use the default credentials or that the required OSBC
driver is not installed (the v5.x ODBC driver is also installed)



I can see from the ACC code that it is expecting username and password to be
'slimserver'



If I use the ODBC administrator I cannot connect to the database either.



Does anyone have this combination running successfully or can anyone advise
what tests I might perform in order to resolve the situation?



When ACC was first launched I can it successfully on an old Windows 2003 SBS
box (32 bit) but that hardware has long since gone!



Regards



Richard Scales

SilverRS8
2009-12-30, 02:03
ACC has been reported to work on a 64-bit platform if you install thet 32 bit ODBC driver on the 64 bit platform. Ofcourse you have to perform the manual pre-requirements first like modifying the mysql my.tt file to allow for remote access.

the username and password (both slimserver) can be left out as it is no hard requirement (but can't do any harm either).

Also Windows 2008 has a lot more security features. Make sure firewall settings etc allow for communication between ACC and the MySQL database. Experimenting first with the MySQL administration tool if ofcourse a good idea. If this communication works, so should ACC.

scalesr1
2009-12-30, 02:37
I have tried connecting via the ODBC driver and failed (MYSQL Error ever
time) - I also tried removing the password and then the user name from the
ACC hta file - still same problem.

Should I be able to test the connection to the database using the ODBC Admin
tool?

I will try removing the ODBC drivers and re-installing the 32 bit one (64
bit driver installed at present)

I did edit the .tt file but right now I am trying to connect locally.

Regards

Richard


-----Original Message-----
From: discuss-bounces (AT) lists (DOT) slimdevices.com
[mailto:discuss-bounces (AT) lists (DOT) slimdevices.com] On Behalf Of SilverRS8
Sent: 30 December 2009 09:04
To: discuss (AT) lists (DOT) slimdevices.com
Subject: Re: [slim] ACC Guide for installation


scalesr1;500253 Wrote:
> Hello.
>
>
>
> I am struggling with ACC. I am running Server V7.41 on a Windows 2008
> 64 bit
> platform.
>
> I have installed Album Catalogue Creator V1.6a and installed the ODBC
> driver
> 3.51.
>
>
>
> ACC complains that it cannot connect to the MYSQL database and suggests
> that
> it may not be set to use the default credentials or that the required
> OSBC
> driver is not installed (the v5.x ODBC driver is also installed)
>
>
>
> I can see from the ACC code that it is expecting username and password
> to be
> 'slimserver'
>
>
>
> If I use the ODBC administrator I cannot connect to the database
> either.
>
>
>
> Does anyone have this combination running successfully or can anyone
> advise
> what tests I might perform in order to resolve the situation?
>
>
>
> When ACC was first launched I can it successfully on an old Windows
> 2003 SBS
> box (32 bit) but that hardware has long since gone!
>
>
>
> Regards
>
>
>
> Richard Scales

ACC has been reported to work on a 64-bit platform if you install thet
32 bit ODBC driver on the 64 bit platform. Ofcourse you have to perform
the manual pre-requirements first like modifying the mysql my.tt file to
allowe for remote access.

the usernamen and password (both slimserver) can be left out as it is
no hard requiremend (but can't do any harm either).


--
SilverRS8

Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for
SqueezeCenter '_' (http://www.badkamerpech.nl) SlimServer.
2xSB3, 1xDuet, 1xiPhone iPeng, Ubuntu NAS + SC, Denon PMA-1500AE +
DacMagic + Monitor Audio Silver RS8 = :-)
------------------------------------------------------------------------
SilverRS8's Profile: http://forums.slimdevices.com/member.php?userid=12818
View this thread: http://forums.slimdevices.com/showthread.php?t=73198

scalesr1
2009-12-30, 02:41
Installed 32 bit driver - error has gone away - now status is 'creating ACC
table'.

As I have a large library (5K+ Albums) I shall leave it for a while.

Fingers crossed.....

Richard


-----Original Message-----
From: discuss-bounces (AT) lists (DOT) slimdevices.com
[mailto:discuss-bounces (AT) lists (DOT) slimdevices.com] On Behalf Of SilverRS8
Sent: 30 December 2009 09:04
To: discuss (AT) lists (DOT) slimdevices.com
Subject: Re: [slim] ACC Guide for installation


scalesr1;500253 Wrote:
> Hello.
>
>
>
> I am struggling with ACC. I am running Server V7.41 on a Windows 2008
> 64 bit
> platform.
>
> I have installed Album Catalogue Creator V1.6a and installed the ODBC
> driver
> 3.51.
>
>
>
> ACC complains that it cannot connect to the MYSQL database and suggests
> that
> it may not be set to use the default credentials or that the required
> OSBC
> driver is not installed (the v5.x ODBC driver is also installed)
>
>
>
> I can see from the ACC code that it is expecting username and password
> to be
> 'slimserver'
>
>
>
> If I use the ODBC administrator I cannot connect to the database
> either.
>
>
>
> Does anyone have this combination running successfully or can anyone
> advise
> what tests I might perform in order to resolve the situation?
>
>
>
> When ACC was first launched I can it successfully on an old Windows
> 2003 SBS
> box (32 bit) but that hardware has long since gone!
>
>
>
> Regards
>
>
>
> Richard Scales

ACC has been reported to work on a 64-bit platform if you install thet
32 bit ODBC driver on the 64 bit platform. Ofcourse you have to perform
the manual pre-requirements first like modifying the mysql my.tt file to
allowe for remote access.

the usernamen and password (both slimserver) can be left out as it is
no hard requiremend (but can't do any harm either).


--
SilverRS8

Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for
SqueezeCenter '_' (http://www.badkamerpech.nl) SlimServer.
2xSB3, 1xDuet, 1xiPhone iPeng, Ubuntu NAS + SC, Denon PMA-1500AE +
DacMagic + Monitor Audio Silver RS8 = :-)
------------------------------------------------------------------------
SilverRS8's Profile: http://forums.slimdevices.com/member.php?userid=12818
View this thread: http://forums.slimdevices.com/showthread.php?t=73198

scalesr1
2009-12-30, 02:52
All working well, now it would seem that I need to sort out my album art
(again!!! - last did this 5 years ago)

Thanks for your help.

Regards

Richard


-----Original Message-----
From: discuss-bounces (AT) lists (DOT) slimdevices.com
[mailto:discuss-bounces (AT) lists (DOT) slimdevices.com] On Behalf Of SilverRS8
Sent: 30 December 2009 09:04
To: discuss (AT) lists (DOT) slimdevices.com
Subject: Re: [slim] ACC Guide for installation


scalesr1;500253 Wrote:
> Hello.
>
>
>
> I am struggling with ACC. I am running Server V7.41 on a Windows 2008
> 64 bit
> platform.
>
> I have installed Album Catalogue Creator V1.6a and installed the ODBC
> driver
> 3.51.
>
>
>
> ACC complains that it cannot connect to the MYSQL database and suggests
> that
> it may not be set to use the default credentials or that the required
> OSBC
> driver is not installed (the v5.x ODBC driver is also installed)
>
>
>
> I can see from the ACC code that it is expecting username and password
> to be
> 'slimserver'
>
>
>
> If I use the ODBC administrator I cannot connect to the database
> either.
>
>
>
> Does anyone have this combination running successfully or can anyone
> advise
> what tests I might perform in order to resolve the situation?
>
>
>
> When ACC was first launched I can it successfully on an old Windows
> 2003 SBS
> box (32 bit) but that hardware has long since gone!
>
>
>
> Regards
>
>
>
> Richard Scales

ACC has been reported to work on a 64-bit platform if you install thet
32 bit ODBC driver on the 64 bit platform. Ofcourse you have to perform
the manual pre-requirements first like modifying the mysql my.tt file to
allowe for remote access.

the usernamen and password (both slimserver) can be left out as it is
no hard requiremend (but can't do any harm either).


--
SilverRS8

Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for
SqueezeCenter '_' (http://www.badkamerpech.nl) SlimServer.
2xSB3, 1xDuet, 1xiPhone iPeng, Ubuntu NAS + SC, Denon PMA-1500AE +
DacMagic + Monitor Audio Silver RS8 = :-)
------------------------------------------------------------------------
SilverRS8's Profile: http://forums.slimdevices.com/member.php?userid=12818
View this thread: http://forums.slimdevices.com/showthread.php?t=73198