[Building Sakai] database problem in new tool

[yolima u]

hi, thanks for your answer

i reviewed the permissions of the data base and are 777 (for chmod), and i
can change the type of other tables with type=InnoDB to MyISM and to InnoDB
again in the same database, but i can't change the tables type=MyISAM, 

i thing that it's something of each table because i can change all tables
type InnoDB but i can't change tables MyISAM

what can i do for access to USER_ID from SAKAI_USER as foreign key?


Juan Pablo Romero Bernal-2 wrote:
> 
> Hi,
> 
>> i'm doing a new tool in sakai and i'm creating new tables in the data
>> base.
>> i need USER_ID (from SAKAI_USER) as foreign key in a new table but i
>> can't
>> do that because SAKAI_USER table is type MyISAM and for to do foreign
>> key,
>> the tables must be type=InnoDB, i need change that in SAKAI_USER but i
>> can't
>> to that because SAKAI_USER table is "only read", how can i change this
>> feature of sakai_user?
>> --
> 
> I think, it is not a problem related with Sakai. Try:
> 
> if you are using MySQL in Linux/Unix:
> 
> *. Review the permissions of the files located in
> /var/lib/mysql/<sakai-database> and verify that the proprietary is
> mysql user and group mysql group.
> 
> *. Make sure that the sakai database user have UPDATE privileges.
> 
> *. Restart the mysqld service
> 
> I hope this helps.
> 
> Cheers,
> 
> -- 
> Juan Pablo Romero Bernal
> Blog: http://jpromerobx.blogspot.com/
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
> 
> 

-- 
View this message in context: http://www.nabble.com/database-problem-in-new-tool-tp23462169p23462965.html
Sent from the Sakai - Development mailing list archive at Nabble.com.