phphelpdesk-help

[Phphelpdesk-help] I don't have permission to add users

[Corey D. <co...@ec...>]

I ran the phphelpdesk.sql and all went well, when I access the site it
lets me in, but when I try add anything it says I don't have permission.
This is loging in with the default admin/admin account, as I'm unable to
change it yet.
 
I thought the line: grant all privileges on phphelpdesk.* to
phphdadmin@localhost identified by 'phphdpassword';  but now wonder if
that's generic and I needed to edit it?  Can any help clarify this?
 
Also, where do I get to set the language options for a user?

Re: [Phphelpdesk-help] I don't have permission to add users

[Roy S. R. <rs...@in...>]

On Fri, 7 Mar 2003, Corey Duncan wrote:
> I ran the phphelpdesk.sql and all went well, when I access the site it
> lets me in, but when I try add anything it says I don't have permission.
> This is loging in with the default admin/admin account, as I'm unable to
> change it yet.
>
> I thought the line: grant all privileges on phphelpdesk.* to
> phphdadmin@localhost identified by 'phphdpassword';  but now wonder if
> that's generic and I needed to edit it?  Can any help clarify this?

The 'grant' line is to tell MySQL to grant the phpadmin (in this case) user
full access to the database.  The username should match what you have in the
conf file as the MySQL username.  PHPHD implements a level of abstraction
between PHPHD users and the actual database user.

-roy

Re: [Phphelpdesk-help] I don't have permission to add users

[Mike M. <mm...@ad...>]

Here is the mySQL data from my admin account (with a few edits of course).
This is in the security table:

basically a '1' in every permission field.

INSERT INTO security (s_user, s_firstname, s_lastname, s_password,
s_timestamp_laston, s_email, s_register_new_tickets, s_authorize_tickets,
s_assign_tickets, s_update_tickets, s_delete_tickets, s_open_closed_tickets,
s_view_unauthorized_tickets, s_view_department_tickets, s_add_categories,
s_delete_categories, s_add_departments, s_delete_departments,
s_manage_users, s_pref_viewall, s_add_parts, s_isroot,
s_pref_viewjobs_first, s_generate_reports, s_ismanager)

VALUES('admin', 'Firstname', 'Lastname', 'password', '2003-03-06 12:57:00',
you...@yo...', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1)

----- Original Message -----
From: Corey Duncan
To: php...@li...
Sent: Friday, March 07, 2003 6:35 AM
Subject: [Phphelpdesk-help] I don't have permission to add users


I ran the phphelpdesk.sql and all went well, when I access the site it lets
me in, but when I try add anything it says I don't have permission.  This is
loging in with the default admin/admin account, as I'm unable to change it
yet.

I thought the line: grant all privileges on phphelpdesk.* to
phphdadmin@localhost identified by 'phphdpassword';  but now wonder if that'
s generic and I needed to edit it?  Can any help clarify this?

Also, where do I get to set the language options for a user?