[Building Sakai] database problem in new tool

[yolima u]

it works now thanks!



yolima u wrote:
> 
> 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-tp23462169p23463406.html
Sent from the Sakai - Development mailing list archive at Nabble.com.