Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • AdminDSN and PluginSQL

    Posted by uncs23

    Hi all,

    I'm having a problem getting these two to play nice with Tiki 1.8.5

    I have my tikiwiki and mysql database on the same linux machine. I've created a DSN using the line mysql://user@localhost/tiki and then {SQL(db=>tiki)} SELECT login,email FROM users_users {SQL} from the example. When i load the wiki page, it is blank. I've tried setting the host by IP mysql://user@ipaddress/tiki as well as many other things. The user has no password, hence there is nothing after the username. Can anyone point me to where I might be having a problem? Does this plugin have a switch i need to activate or something?



    Reads: 538
    Posted by Gary Cunningham-Lee

    Just to clarify something, in the plugin, db=> the DSN name as defined on AdminDSN, not the database name itself. Did you use the DSN name here?

    Other than that, I don't know. There's no switch; the plugin should work if the DSN is defined correctly and the plugin has the right information. But my database connection requires both username and password. I don't know what happens in cases where no password is used.

    -- Gary