1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Access non Mysql PSA database

Discussion in 'Plesk for Windows - 8.x and Older' started by crash, Nov 16, 2006.

  1. crash

    crash Guest

    0
     
    With the new Plesk 7.6 for Windows, the psa database is by default setup as (i believe) a Mssql database.

    Can anyone give me hints on how I can access the database?
     
  2. crash

    crash Guest

    0
     
    To answer my own question.

    If the "Typical" option is chosen during Plesk setup, the Psa database is stored as a Ms Access Database located at

    Plesk\admin\db\psa.mdb

    It is easy to access the data in that database by setting up a ODBC DSN, then using DBD-ODBC in perl.
     
  3. squorpeeon

    squorpeeon Basic Pleskian

    23
    73%
    Joined:
    Jul 5, 2006
    Messages:
    29
    Likes Received:
    0
    Even easier, just copy it to your workstation, open it up in Access, edit and re-upload. :)

    Better yet is to convert it to MS SQL. I saw somewhere that it can be done but have no details on it. When I saw my DC Plesk install used Access, I uninstalled it and then re-installed it myself using MS SQL. Shame they wouldn't just give me a key so I could install it myself the first time.
     
  4. henry@

    henry@ Guest

    0
     
    Always use a custom installation method, there you can choose MS access, MSSQl or MySQL etc. Default is always the bad choice.
     
  5. crash

    crash Guest

    0
     

    That's assuming I am running a Windows work station, which I am not ;-)

    The reason I needed access to the PSA database is because I wrote some backup scripts that depend on access to information in the database.
     
  6. squorpeeon

    squorpeeon Basic Pleskian

    23
    73%
    Joined:
    Jul 5, 2006
    Messages:
    29
    Likes Received:
    0
    OK I see now, how about using ODBC and create a DSN with the Microsoft Access Driver?

    Are you using PHP for the script?
     
  7. crash

    crash Guest

    0
     
    Thats exactly what I ended up doing. Great minds think alike =)

    I wrote the script in perl. So it ended up just being a mater of adding a new "Database type" option to the script and adding few lines of code.

    This is my first time actually using ODBC, and am already a fan!
     
  8. squorpeeon

    squorpeeon Basic Pleskian

    23
    73%
    Joined:
    Jul 5, 2006
    Messages:
    29
    Likes Received:
    0
    Glad you got it sorted ;)
     
Loading...